Excel 101 (13)
Excel beginners will find all the basics needed on how to create effective and professional looking spreadsheets. A beginner’s guide covers essential information and a labeled diagram of the Excel screen, helps you learn what some of this spreadsheet terminology means. Free step by step tutorials and tips help make that first adventure in creating spreadsheets go smoothly.
Formulas in Excel (8)
One of Excel's most useful features is that it allows users to create custom formulas to perform calculations on their data. You can create formulas for basic number crunching, such as addition or subtraction, as well as more complex calculations such as payroll deductions or averaging a student's test results.
Excel Functions (93)
Built-in functions in Excel can be used to perform calculations on spreadsheet data. While most people use only those functions specific to their needs, there are many functions such as SUM, COUNT, AVERAGE, MAX, MIN, and the IF function that just about everyone uses. Here you will find step by step tutorials, tips and shortcuts on how to use the common and less common functions available in Excel.
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 (9)
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.
Excel 2003 (12)
Want to learn how to use Excel? Here you will find tips, step by step tutorials, and other information that will help you learn to use a variety of features and tools in versions of Excel from 97 to 2003.
Advanced Excel (10)
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.
Spreadsheet Lesson Plans (17)
Spreadsheet Lesson Plans contain step by step examples that can be used as lessons for a wide range of age groups. Topics covered include creating and using spreadsheets, functions, graphing, formatting and creating formulas.
Excel Tools (10)
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 (58)
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.
Excel Videos (14)
Watch these training videos on various aspects of Microsoft Excel. Through live screencasts, experts will show you how you can use a variety of features in Excel. A full transcript is provided so you can follow the training videos on your own.
Spreadsheet Terms (64)
Common spreadsheet terms and definitions used in programs such as Excel, Google Spreadsheets, OpenOffice Calc, and EditGrid are listed here. Navigate through this handy glossary to refer to definitions of some of the common terms used in spreadsheets. Learn spreadsheet terms and definitions easily.
Other Spreadsheets (16)
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.