Hot Microsoft Office Posts

How To: Create a stem & leaf chart with Excel's REPT & COUNTIF

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 ExcelsFun, the 28th installment in his "Excel Statistics" series of free video lessons, you'll learn how to create quantitative data stem & leaf charts using the REPT and COUNTIF functions.

How To: Create a sudoku puzzle in Excel with array formulas

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 242nd installment in their series of digital spreadsheet magic tricks, you'll learn how to create a sudoku puzzle using array formulas, the INDEX function with criteria and data validation.

How To: Multiply & divide fractions using Excel key points

To multiply and divide the two fractions is a single step problems. Just multiply both the numerators and denominator for obtaining multiplication of two fractions, and for the division just multiply numerator of first fraction with denominator of second fraction and keep it in numerator place, and for the denominator place you just multiply the denominator of first fraction with numerator of second fraction.

How To: Calculate monthly sales with Excel's SUMPRODUCT & TEXT

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 45th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the SUMPRODUCT & TEXT functions together in 1 formula to sum the month's sales. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Score a Full Version of Microsoft Office for Only $10

When it comes to text documents and spreadsheets, Microsoft Office is the be-all and end-all office suite—but it's not cheap. Paying anywhere from $140 to $400 puts a big dent in your bank account, especially if you're a broke college student eating ramen for breakfast, lunch, and dinner. Something that I wish I would've known about during college is Microsoft's HUP (Home Use Program). With HUP, any employee or student of an organization that has a Microsoft volume license is eligible to purc...

How To: Randomly select a name from a list 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 11th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create a formula that will randomly select a name from a list of names without having the list of names sitting in cells.

How To: Retrieve data from many tables on many sheets in Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 77th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to do a complicated payroll formula when tax data must be retrieved from multiple tables. See how to use the INDEX, INDIRECT AND MATCH functions in one big formula to retrieve tax data from multiple tables on multiple sheets. Learn to love digital spreadshe...

How To: Calculate income tax payroll deductions 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 42nd installment in his "Excel Business Math" series of free video lessons, you'll learn about the wage bracket and percentage methods for calculating federal income tax payroll deductions.

How To: Create an Excel pivot table with 4-variable tabulation

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 216th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a pivot table (PivotTable) with 4-variable cross tabulation. Learn to use multiple fields in a pivot table with this free video tutorial.

How To: Create a checkbook-balancing formula in 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 233rd installment in their series of digital spreadsheet magic tricks, you'll learn how to create an efficient checkbook balance formula and see when to use the ROUND function on a sales invoice.

How To: Create frequency distributions with Excel pivot tables

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 ExcelsFun, the 15th installment in his "Excel Statistics" series of free video lessons, you'll learn how to use create a frequency distribution, relative frequency distribution, percent frequency distribution and pie chart wi...

How To: Insert and format a text box in Microsoft Word for Mac 2011

Interested to learn how to insert and format text boxes in Word for Mac 2011? This video will show you how it's done. Whether you're new to Microsoft's popular word processing application, new to MS Word 2011 or even an expert merely looking to brush up on the fundamentals, you're sure to be well served by this quality video tutorial from the folks at Lynda. For all of the details, and to get started using text boxes in your own Mac 2011 projects, watch the video.

How To: Calculate future value for a sinking fund 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 48th installment in his "Excel Business Math" series of free video lessons, you'll learn how to use the Excel functions FV and PMT to make a future value calculation for a sinking fund.

How To: Make a histogram chart in Excel

In this tutorial, we learn how to make a histogram chart in Excel. To create a vertical histogram, you will enter in data to the chart. Then, highlight all of the data and go to "insert", "chart", then choose a regular column chart. Grab a regular 2D column and then make sure your values are correct. Then, right click and go to "chart options", then take the legend off. Now, make these columns all touch each other by right clicking over the columns and formatting them. Go to "options" then ch...

How To: Repeat a list of names 7 times in Excel

The ExcelIsFun shows how to repeat a list of names seven times. He starts out by telling you a fast way to do this. He starts out by selecting the names already typed in then he presses Control C (Ctrl + c) on the keyboard. The next thing he does is move the cursor to a different column and in the first row. He presses Control V (Ctrl + v) to paste the names into the other column. By watching this video, you will find out how to quickly repeat a list of names 7 times or more.

How To: Create a savings plan with Excel's FV & PMT functions

Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 22nd installment in his "Highline Excel Class" series of free video Excel lessons, you'll see a lifetime savings plan using the FV and PMT functions and other formulas. See how to calculate how much you will have at retirement from a basic savings plan. Then see ...

How To: Use a MODE IF function 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 145.5th installment in their series of digital spreadsheet magic tricks, you'll learn how to a formula that will calculate the mode when you have more than 1 criterion.

How To: Find confidence intervals without the sigma in 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 ExcelsFun, the 82nd installment in his "Excel Statistics" series of free video lessons, you'll learn how to construct confidence intervals when the sigma value (the population's standard deviation) in NOT Known using the TINV...

How To: Build an Excel table of fraction & percent equivalents

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 24th installment in his "Excel Business Math" series of free video lessons, you'll learn how to build a table of decimal, fraction and percent equivalents. See how fractional formatting can be misleading.

How To: Remove tracked changes from a Word document

Leaving visible revision marks and comments in a document that you thought was "final" can be embarrassing. In this instructional video, a Microsoft employee demystifies what's going on with those tracked changes that you thought were gone from your Microsoft Office Word 2007 document. He also shows you how to banish those markings permanently in two ways and gain peace of mind.

How To: Add yearly totals from monthly data in MS Excel 2010

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 679th installment in their series of digital spreadsheet magic tricks, you'll learn how to summarize yearly totals from monthly totals when there Year Criteria is entered as a serial date. See the SUMPRODUCT and SUMIFS functions. Learn about criteria and how to enter it into the SUMIFS functions.

How To: Repeat each successive date in an Excel date column

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 579th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the MOD function and date math to create a column of dates where each successive date is repeated twice.

How To: Use HLOOKUP across two worksheets in Microsoft Excel

Microsoft Office Excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets, as well as analyze and share information to make more informed decisions. In this MS Excel video tutorial, you'll learn about using the HLOOKUP function to generate adaptable grades from marks. For more on using HLOOKUP across multiple documents, watch this Microsoft Office how-to.

How To: Add continuous music to your PowerPoint presentation

This video helps us how to add continuous music to your PowerPoint presentation. To add continuous music to your PowerPoint presentation, click "Insert" in the Main toolbar. Place arrow key on the Sound icon and wait for options to appear. Select "Sound from File". Locate for and select the sound file. Select "Automatically" button once a window appears. Select "Animation" and then "Custom Animation". A window appears on the right side of the screen. Select "Effect" options and choose the num...

How To: Turn a Ctrl + Shift + Enter formula into an Enter array formula in 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 52nd installment in their joint series of digital spreadsheet magic tricks, you'll learn how to use the INDEX function to turn a Ctrl + Shift + Enter array formula into just an Enter array formula. Avoid Ctrl + Shift + Enter by using the INDEX function and a blank as the row argument.

How To: Create a formula timer in Microsoft Excel

Are you looking for a way to make your Microsoft Excel formulas simpler, faster and more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the 2nd installment in his "Excel Formula Efficiency" series, you'll learn how to compare alternative formulas to see which is faster.

How To: Create a chart for a linear function of X 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 239th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a chart for a linear function of X in Excel as well as how to use a text formula to display a function of X.

How To: Use the NORMSINV & NORMSDIST 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 ExcelsFun, the 93rd installment in his "Excel Statistics" series of free video lessons, you'll learn how to use the NORMSINV and NORMSDIST functions to complete a hypothesis test about a population proportion.

How To: Use conditional IF formulas in Microsoft Office Excel

New to 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 Excel tutorial from ExcelIsFun, the 334th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the IF function. This video starts with IF function basics and then shows 12 different examples of how the IF function can be used in formulas. Also see how to use AND, OR, SUM, AVERAGE, STDEVP and VLOOKUP functions.

How To: Work with the VBA environment in Microsoft Excel 2007

Learn how to use the VBA environment within MS Excel 2007 to create custom macros. Whether you're new to Microsoft's popular spreadsheet application or a seasoned business professional just looking to better acquaint yourself with the unique features of Excel 2007, you're sure to be well served by this video tutorial. For more information, and to get started working within Excel 2007's VBA environment yourself, watch this free video guide.

How To: Use a macro to arrange a data set in a column in 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 644th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a recorded macro that uses formulas to rearrange a proper data set to one listed in a column.

How To: Arrange email messages by date or sender in Microsoft Outlook 2007

Sort your emails by either date or sender within MS Outlook 2007. This clip will teach you how. Whether you're new to Microsoft's popular email and scheduling application or a seasoned MS Office professional just looking to better acquaint yourself with the Outlook 2007 workflow, you're sure to be well served by this video tutorial. For more information, and to get started organizing your own inbox, watch this free video guide.

How To: Avoid double-counting duplicates within a list in Microsoft Excel 2010

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 726th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SIGN, COUNTIF and SUMPRODUCT functions to count 1 for each item in a first list that's also contained in a second list.

How To: Make an Excel gradebook that removes the lowest score

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 195th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUM, MIN and VLOOKUP functions to create a grade book based on given total score that drops the lowest score and calculates grades automatically.

How To: Add drawings and free-form shapes in MS Word 2007

In this Microsoft Word tutorial the instructor shows how to add a drawing or a free form shape to a document. Using the canvas in the Microsoft Word 2007 can be very helpful in adding graphical content to your document. Adding shapes and special effects like shadows, 3D will give a rich look to the document. To do this open a document in Word 2007. In the tool bar go to the Insert tab and in that select the Shape button. Now you are presented with plenty of predefined auto shapes. First at th...