Welcome

Join our Microsoft Office World now to meet up with other Office users on the Web. Learn how to make spreadsheets in Excel, documents in Word, and presentations in PowerPoint. And don't forget to share your own MS Office tips and tricks for using everybody's favorite office suite.

- Ask questions in the Forum.
- Share some Inspiration.
- Post a How-To article.

Looking for another interesting topic? Check out all of the other Worlds on WonderHowTo!

Hot Microsoft Office Posts

How To : Create a basic attendance sheet in Excel

This video teaches you how to make a functional attendance sheet in Microsoft Excel. This video shows you a lot of neat tricks to make keeping attendance simple and easy. It shows you how to use the SUM and the IF functions in excel, which are formulas that make the program do ...more

How To : Find a p-value with Excel

This how-to-video helps to find the P-Value using MS excel function tdist. For demonstration this tutorial takes the following examples. Case I: Right tailed Test with n=7 and test statistic t = 3.500 [=tdist(3.5,6,1)]Case II: Left tailed test with n=27 and test statistic t = ...more

How To : Create a frequency polygon line chart in MS Excel

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 655th installment in their series of digital spreadsheet magic tricks, you'll learn see how to cre ...more

How To : Enter formulas in Excel with a macro

In order to enter formulas in Excels with a macro, you will need to open your spreadsheet. Formulas are used to do calculations. Go to the field, where you want to enter a formula. Type in the formula. Then, highlight the formula. Press Control + C to copy the formula. Next, d ...more

How To : Do bank reconciliation in Microsoft Excel

As you might guess, one of the domains in which Microsoft Excel really excels is business math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 37th installment i ...more

How To : Create an Excel spreadsheet to calculate your GPA

Open Microsoft Office Excel. Across the top notice letters (columns), along the sides are numbers (rows). The columns and rows can be extended by highlighting sections and right clicking and choosing the high of the row. You can also select to add a border, and change the orie ...more

How To : Generate random numbers (with decimals) in Excel

This video shows you how to generate random numbers with decimals in Microsoft Excel.When generating random numbers you must have a lower and upper limit, so that your number will be generated between the two limits. For a number without decimals, you only have to use the "=ra ...more

How To : Completely hide the Ribbon menu in Excel

The instructor of this video shows you how to completely hide the ribbon, or the menu, in Excel. If you only want to partially hide the ribbon, you can use the shortcut control + F1. To completely hide the ribbon, though, go to the Visual Basic screen, hit Alt + F11. Then, go ...more

How To : Create a tangent line with Excel

If you're a MS Excel user and looking how to graph a tangent with the program, this video will help you out. With the Excel spreadsheet you can find the slope of the tangent line through a converging sequence of secant line slopes. Goes well with Stewart Calculus section 2.1 a ...more

How To : Calculate incentive rates by formula in MS Excel

As you might guess, one of the domains in which Microsoft Excel really excels is business math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 39th installment i ...more

How To : Creating data-entry forms in Microsoft Access 2010

Learn how to create data-entry forms when working in Microsoft Access 2010. Whether you're new to Microsoft's popular database management application or a seasoned MS Office professional just looking to better acquaint yourself with the Access 2010 workflow, you're sure to be ...more

How To : Sort data by multiple columns in Microsoft Excel

Today we are going to learn how to sort data in a Microsoft Excel 2003 spread sheet. We will go over single column and multiple column sorting. In a single column sort you may high light the data or just click on any cell in the column. Once the data is selected look for the s ...more

How To : Pull data from a master sheet in Microsoft Excel

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 357th installment in their series of digital spreadsheet magic tricks, you'll learn how to pull da ...more

How To : Work with bank checks in Microsoft Excel

As you might guess, one of the domains in which Microsoft Excel really excels is business math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 34th installment i ...more

How To : Make a basic bar graph in Microsoft Excel

In this Software video tutorial you will learn how to make a basic bar graph in Microsoft Excel. You will also learn how to give your chart a title and how to label the axes. First you put in all your data in to an Excel spreadsheet. Then you highlight the data you want to put ...more

How To : Embed a YouTube video into MS Powerpoint 07

Chris Davis with the Educational Technology Center shows us a few easy steps to putting YouTube videos in our Microsoft PowerPoint 2007 presentations. To start you'll need to have an active internet connection and you should have the developer tab in PowerPoint active. To do t ...more

How To : Cross tabulate categorical data in Microsoft Excel

If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's Excel ...more

How To : Build a 15-minute schedule in Microsoft Excel

Want to make a time schedule in Microsoft Excel partitioned into perfectly regimented 15-minute intervals? It's easy, provided you know how to go about it. And in this Excel tutorial from ExcelIsFun, the 543rd installment in their series of Excel magic tricks, you'll learn how ...more

Prev Page

Active Forum Threads

Sites

  • Active
  • Latest