You are here:About>Computing & Technology>Spreadsheets
About.comSpreadsheets

Categories

Excel 101 (85)
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 2007 (35)
The latest version of the spreadsheet program contains a number of changes from previous versions of Excel. Here you will find step by step tutorials, tips, and other information to help you accomplish a variety of tasks in Excel 2007.

Functions in Excel (72)
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.

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.

7 more Categories below

Categories

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.

 All Topics | Email Article | | |
Advertising Info | News & Events | Work at About | SiteMap | Reprints | HelpOur Story | Be a Guide
User Agreement | Ethics Policy | Patent Info. | Privacy Policy©2008 About, Inc., A part of The New York Times Company. All rights reserved.