Home
Our Courses
Course Prices
Current Offers
Microsoft Access
Microsoft Excel
Microsoft Outlook
Microsoft PowerPoint
Microsoft Publisher
Microsoft Word
Introduction to IT
Dreamweaver
Client Feedback
FAQ's
Contact Us

Back to Courses

Excel Intermediate
Excel Advanced

Microsoft Excel Introduction Course Overview
(Versions 2000, XP, 2003, 2007)

The Excel Introduction course will allow you to produce practical spreadsheets for everyday uses.  The course will allow you to feel more confident and be able to create, edit, and format spreadsheets.  You will also learn how create and use formulas effectively and visually see your data in chart format.  The course is suitable for complete beginners to Microsoft Excel

 

By the end of the course you will be able to :

  • Effectively use common built in formatting and Formula in Excel
  • Create and produce business like spreadsheets that can be used both at work and home

Getting Started

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

Entering and Editing data

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

Modifying a Worksheet

  • Moving and copying data
  • Moving and copying formulas
  • Using absolute references

Using Functions

  • Entering functions
  • Using AutoSum
  • Using AVERAGE, MIN, and MAX
Formatting
  • Formatting cells
  • Formatting rows and columns
  • Autoformat
  • Conditional formatting

Printing

  • Preparing to print
  • Page Setup options
  • Printing worksheets

Creating Charts

  • Chart basics
  • Modifying charts
  • Printing charts

Excel Intermediate, Excel Advanced

Back to Courses

 

 

 

 

 

 

 

 

 

©2007 Training Smart Ltd