Ultimate Collection of Microsoft Excel Tutorials and User Guides

If you need to figure out how to solve an Excel-related problem, it’s a safe bet that Bright Hub has the perfect tutorial or user guide to help. Our vast library of Microsoft Excel tutorials covers everything from personalizing Excel to meet your own custom considerations to using Visual Basic for Applications (VBA) for more complex spreadsheet programming needs. We also feature a number of user guides that focus on solving common “everyday” problems such as those related to formatting cells, creating charts, and manipulating formulas.

In addition, Bright Hub offers a wide variety of free Excel templates that you can download and use for anything you need – whether the project is for business or personal purposes. Each template is accompanied with a full tutorial to show you how to get the most out of its use.

Microsoft Excel: Create Random Letters Problem: Instead of random numbers, you need to create random letters....	Review of Free Online Microsoft Excel Courses and Tutorials Finding gimmick-free online Excel tutorials and courses can be a real hassle. This article will review some of the best free courses and tutorials available. Some will focus on text...
The Best Free Online Excel Tutorials Learn Excel from any of this list of the Top 5 free online tutorials. All of the 5 tutorial sites listed in this article are free for anyone to use. Why pay for books or lessons when...	Microsoft Excel Tutorials Whether you’re only trying to figure out how to do one specific thing in Excel or you’re looking for a collection of materials to help you become more proficient in the...

The Best Free Online Excel Tutorials

Learn Excel from any of this list of the Top 5 free online tutorials. All of the 5 tutorial sites listed in this article are free for anyone to use. Why pay for books or lessons when you can learn Excel...

Microsoft Excel: Create Random Letters

Problem: Instead of random numbers, you need to create random letters....

Microsoft Excel: Group By Week In A Pivot Table

Problem: In the last example you noticed that the Grouping dialog allows you to group by second, minute, hour, day, month, quarter, and year. You need to group by week....

Microsoft Excel: Group Dates By Months

Your data has invoice dates and need to group the data by month. You’ve learned how to make a date look like a month. When you make a date look like a month, it’s still the 5th of the month...

Microsoft Excel: Measure the Accuracy of a Sales Forecast

There are several different ways that you can use to develop a sales forecast, but how do you measure how accurate that sales forecast is? Mr. Excel describes how to perform a forecast accuracy calculation...

Microsoft Excel: Add Subtotals To A Dataset

Problem: You have a lengthy report with invoice detail by customer, as shown in Fig. 664. You need to add a subtotal at each change in customer....

Microsoft Excel: Suppress Totals In A Pivot Table

Problem: Pivot tables are sometimes used just as an intermediate step in order to reach another result. If you are going to be copying the data to a new workbook that will be used...