Charts and Graphs (16)
Charts in Microsoft Excel are visual representations of your data. As the old adage states, “A picture is worth a thousand words”. Add a chart to your worksheet and save yourself from needing those thousand words to explain your worksheet data. Tips, information, and step by step tutorials cover creating and formatting charts in Excel so that they clearly show what your spreadsheet data is about.
Excel Formatting (16)
There are a variety of formatting options available in Excel - conditional formatting, number formatting, text and general spreadsheet formatting techniques. With so many choices it is easy to get lost or miss some options altogether. Here you will find free step by step tutorials, how to's, general information, tips and shortcuts to help you format your spreadsheets effectively.
Data Management in Excel (7)
If you are new to Microsoft Excel, you will find all the basics you need right here on how to use Excel's data management tools. How to create a list, how to sort it, and how to filter the data to find the specific information you want, are covered in free step by step Excel tutorials, tips and shortcuts for using Excel's data management tools.
Advanced Excel (7)
Advanced topics, such as working with scenarios, macros, lookup functions, pivot tables, and auditing formulas can be found in this category. These topics are explained and covered in a variety of ways including FAQs, tips, step by step tutorials, and general information articles on the topics.
Excel Tools (8)
Microsoft Excel contains a number of tools and features that, while they may not be used all that often, can really simplify working with spreadsheets. Covered in this section are features such freeze panes, protecting worksheets, as well as Add-Ins and templates that can help to make using Excel as straightforward and as painless as possible.
Tips and FAQs (71)
Here you will find Excel Tips, tricks, and FAQs (frequently asked questions). Excel tips and tricks for creating effective and eye catching spreadsheets. Background information to help you understand what spreadsheets do and why they are doing it. In addition to Excel, information can be found on Google Spreadsheets, OpenOffice Calc, EditGrid, and other spreadsheet programs.
Other Spreadsheets (14)
If you are looking for an alternative to Excel, here you will find basic information for programs such as Google Spreadsheets, Microsoft Works Spreadsheets, OpenOffice Calc, EditGrid, and others. Read software reviews, tips and shortcuts, and follow step by step tutorials to help you create effective and professional looking spreadsheets.