This full guide to Microsoft Excel will take you through all of the basic steps in creating and editing your own spreadsheets and show you some of the more advanced features.

In This Guide:

01 - Introduction to spreadsheets

Here we introduce you to spreadsheets and show you how to start Excel.

02 - Components of a Spreadsheet

Now we get into what makes up the basic collection of data in Excel: the spreadsheet.

03 - Working with Text

In this chapter we first go over how to enter, format and display text in your spreadsheets.

04 - Working with Data

After creating the basic structure of his worksheet, Sean is now ready to enter data, such as the names of the students, marks obtained, etc.

05 - Working With Formulas

We use formulas all the time. To calculate the total payment to be made to the vegetable vendor, to find out if we will overshoot the monthly budget when we buy the expensive T-shirt on display, or to estimate the profit that we will make by selling the

06 - Creating Charts

A chart is a graphic representation of the data in your worksheet. Charts give a clear overview of the data and make it easier to understand complex information. This is especially important when people want to quickly and effectively analyse the overall

07 - Printing Worksheets and Workbooks

Sean wants to make a printout of the worksheets and workbooks.

08 - Viewing Workbooks and Worksheets

Here we go over the various options and methods for viewing and laying out your worksheets and workbooks.