Business Solutions & Training Using Microsoft Excel & Access
 
  Microsoft Excel - Essentials

Getting started
Spreadsheet terminology
Exploring the Excel window
Getting help
Opening and navigating workbooks
Closing workbooks

Entering and editing data

Creating workbooks
Entering and editing labels and values
Entering and editing formulas
Saving and updating workbooks

Modifying a worksheet
Moving and copying data
Moving and copying formulas
Using absolute references
Inserting and deleting ranges

Using functions

Entering functions
Using AutoSum
Using AVERAGE, MIN, and MAX

Formatting worksheets
Formatting text
Formatting rows and columns
Number formatting
Using Format Painter and AutoFormat

Printing
Preparing to print
Page Setup options
Printing worksheets

Creating charts

Chart basics
Modifying charts
Printing charts

Web features

Saving workbooks as Web pages
Hyperlinks
Sending workbooks via e-mail

 

 
   
© 2010 Excelmastery Ltd. All rights reserved. Paul Cavanagh ACMA - Microsoft Excel Expert
Telephone: +44 (0) 7968 629074
Email: paul@excelmastery.com