Hot Microsoft Office How-Tos

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 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 : 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 : 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 : Find critical values with T functions in MS 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 : Turn off AutoCorrect symbols in Excel

In this Excel magic trick video the instructor shows how to stop automatic copyright symbol ©. While using Microsoft Excel when you type the letter c in between a pair of curved braces Excel automatically turns it into the copy symbol © even if we did not intend to use it. Now ...more

How To : Concatenate with criteria 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 316th installment in their series of digital spreadsheet magic tricks, you'll learn how to count & ...more

How To : Migrate from Microsoft Access 2003 to Access 2007

Interested in upgrading from Microsoft Access 2003 to MS Access 2007? Whether you're new to Microsoft's popular data management application or a seasoned MS Office professional just looking to better acquaint yourself with the Access 2007 workflow, you're sure to be well serve ...more

How To : Create a table for the VLOOKUP function in Excel

In this video tutorial, viewers will learn how to create a table for the VLOOKUP function in Excel. Create a dynamic table for the VLOOKUP function as well as a dynamic lookup area so that as you add new data or columns to the Lookup table. Create dynamic ranges using the Exce ...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 : 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 : Calculate a bonus 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 and Mr. Excel, the 24th installment in their joint series of digital spreadsheet magic tricks, you'll l ...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 : Insert movie files into a MS Word document

In order to insert movies into Microsoft Word 2007, Click on Insert. For AVI, go to Object, Create From File, and select the location of the file. Then, click on Insert. It will now appear on your document. The video should play. The video can be repositioned or adjusted. It c ...more

How To : Randomly select names without repeats 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 302nd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the ...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

How To : Set up the calendar in MS Project 2007

In this tutorial, we learn how to set up the calendar in MS Project 2007. First, open up your calendar and then click on the "work week" tab. Now, set your working times into the slots for each different day. Make sure you set your start and end times correctly. Now, go to opt ...more

Prev Page
  • Active
  • Latest