Microsoft Excel Tutorials and How-To Guides – Excel Tutorials for Beginners and Advanced Users

Page content

Excel How-To Guides

Even though it doesn’t take long to learn the basics of Microsoft Excel, it could take years to explore the application’s full potential. With Bright Hub’s collection of Excel tutorials, you can jump ahead and focus on the exact lesson that you want to master or you can browse through the entire library, building up your Excel skills at your own pace. Here’s a summary of some of our current most popular Excel tutorials.

Charts and Graphs

Excel’s chart and graph capabilities are among the best-known features of the spreadsheet application. Although most common charts can be created with a click of a button, some require a bit more work. If you’re using Excel 2007, there are also a number of re-designed formats that you can apply to any chart to give it a more professional appearance. This is great for those times when you want to share or distribute visual information, or when you want to insert the chart into PowerPoint presentations.

In addition to these standard graphs, you can also the SmartArt tool to create charts that display text-based information such as family trees and timelines. When you combine this feature with the other drawing tools in the application, you can construct some pretty amazing diagrams.

Excel Templates

Another aspect of Excel that makes it such a popular application is the number of spreadsheet templates available. Microsoft hosts a gallery where you can download free Excel templates or upload and share your own creations with others in the Excel community. As a matter of fact, if you don’t like the default settings in Excel, you can even customize Excel’s default template to make it better suited to your needs.

Excel Functions

Another powerful feature of Excel is its vast function library. While many people associate the term “function” with mathematics and numbers-related formulas, you can actually do a whole lot more with Excel functions. You can also use these objects to look up data in a spreadsheet or format text in a number of different ways. If you’ve never worked much with Excel functions, you may need to practice a bit before feeling entirely comfortable with them, but Bright Hub’s tutorials will walk you through all the steps of creating formulas with these building blocks.

Multiple Scenarios in One Spreadsheet

If you’re creating an Excel spreadsheet to be used for something like personal budget planning or corporate goal forecasting, you may be creating the same sheet over and over again just to analyze different possibilities. With Excel’s what-if analysis capability, you don’t have to do this. All you have to do is create the initial spreadsheet, and then you can use the alternate scenarios tool to input different numbers. After this, you can switch from one scenario to another with just a click of a button.

Other Excel Tutorials

This is just a sampling of the hundreds of Excel tutorials available here at Bright Hub. For more, be sure to browse through our dedicated Excel area of the Windows Channel. New and updated articles are being added all the time, so bookmark that page and check back often!