1. Understanding Excel and Its User Interface
Why use Excel?
()
Checking out the Backstage view with the File tab
()
Examining your file's info
()
Exploring the Ribbon
()
Customizing the Ribbon and Quick Access Toolbar
()
2. Getting Started with Basic Tasks in Excel
Creating workbooks from templates
()
Saving workbooks to different file formats
()
Switching between views
()
Moving around your worksheets and workbooks
()
Adding, copying, and removing worksheets
()
3. Developing Your Spreadsheet
Entering and formatting text and numbers
()
Aligning text and numbers
()
Choosing number formats
()
Totaling rows and columns with AutoSum and Fill
()
Referencing cells by row and column
()
Referencing cells in another worksheet
()
Cutting, copying, and pasting
()
Clearing contents and deleting cells
()
Splitting the worksheet view and freezing panes
()
Working with two workbooks and syncing the view
()
4. Creating More Complex Formulas
Writing your own formulas
()
Understanding relative and absolute references
()
Using functions like ROUNDUP, AVERAGE, and IFERROR
()
Formatting dates and times
()
Using date and time functions
()
Naming cells and ranges
()
Fixing common errors
()
Tracing Errors
()
5. Making Changes to Your Workbook
Moving, inserting, and removing cells, rows, and columns
()
Transposing rows and columns
()
Merging and unmerging cells
()
Adding comments to worksheets
()
6. Visualizing Your Data with Color, Charts, and Graphics
Changing worksheet colors, fonts, and effects
()
Creating charts
()
Choosing the right chart for your data
()
Changing your chart's appearance
()
Using sparklines as "data words"
()
Inserting photos, graphics, and clip art
()
Using an image for a header
()
7. Analyzing Data
Creating a data table
()
Adding records and modifying a data table
()
Sorting and filtering data in a table
()
Importing data from an outside source
()
Grouping data in outlines
()
Building a pivot table
()
Highlighting data with conditional formatting
()
8. Printing and Sharing Your Worksheet
Printing a worksheet with column and row headers
()
Setting up page breaks
()
Emailing a workbook
()
EX_Files_Up_and_Running_with_Excel_2010.zip
(205 KB)