Microsoft Excel Tutorials

Working with Pivot Tables

PivotTables are one of the wildest but most powerful features of Excel, an ingenious tutorial themselves that may take some experimentation to figure out. Educational Site since: 2006-04-08 Hits: 4791 Votes: 3 Rating: 7.333 Rate

Formulas & Functions

Excel provides a number of different ways to build formulas & functions, letting you craft them by hand or point-and-click them into existence. In this tutorial, you learn about all of these techniques. Educational Site since: 2006-04-08 Hits: 4761 Votes: 3 Rating: 5.333 Rate

Working with Macros

You find yourself repeating the same actions over and over and would like to automate that process. Educational Site since: 2006-04-08 Hits: 4949 Votes: 0 Rate

How to Address Data by Name

Although cell numbers are at the foundation of everything Excel does, it's much easier to remember names, such as Item Number and Quantity, than it is to remember cell numbers, such as A1:A100. Excel makes this easy. Educational Site since: 2006-04-08 Hits: 1856 Votes: 2 Rating: 5 Rate

Reducing Workbook and Worksheet Frustration

Excel enables you to have multiple workbooks showing simultaneously, and to have a customized view of your workbooks arranged in different windows. Then you can save your view workspaces as .xlw files and use them when it suits you. Educational Site since: 2006-04-02 Hits: 1528 Votes: 0 Rate

Excel's Built-in Features

Excel comes with a wide variety of features for managing & analyzing data, the boundaries of these features are often frustrating. In this tutorial provide numerous ways in which you can escape these boundaries & make Excel a much more powerful tool Educational Site since: 2006-01-08 Hits: 2809 Votes: 0 Rate

Working with Charts

Charts (graphs) depict data visually, so you can quickly spot overall trends. You'll learn how to create many different types of charts, including pie charts, line charts, and three-dimensional area charts. Educational Site since: 2006-04-08 Hits: 1829 Votes: 0 Rate

Connecting Excel to the World

In this tutorial you'll learn how to: Load an XML document into Excel Save to SpreadsheetML and Extracting Data Access SOAP Web Services from Excel Create Excel Spreadsheets Using Other Environments Educational Site since: 2006-04-08 Hits: 1666 Votes: 1 Rating: 1 Rate

Microsoft Excel 2003 Help and Tips

Microsoft Excel 2003 advice including adjusting the macro security level, changing AutoRecover options, workbook password protection, visual tweaks, and manual spreadsheet calculation. Educational Site since: 2004-11-22 Hits: 6364 Votes: 1 Rating: 10 Rate