Microsoft Excel Course – Module 1 Essentials

Is it right for me?

Our Excel Module 1 - Essentials course introduces the basic features of Excel and focuses on creating spreadsheets, adding different types of formula, formatting and printing.

You should be competent in using a PC for general business use. No previous experience of Excel is required.

What will I get out of it?

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

• Create, save and print worksheets, e.g. timesheets, sales figures, invoices, etc
• Create different types of formula
• Use basic Excel functions
• Edit and manipulate information
• Format worksheets for professional presentation

Versions available

2003, 2007, 2010

Related courses in our range

• Excel - Mastering Formulas and Functions
• Excel Module 2 -– Gathering and Presenting Data
• Excel Module 3 –- Data Analysis

What does it cover?

Creating a worksheet

• Adding text, numbers, dates and times
• Using automatic features
• Renaming worksheets
• Saving a workbook
• Compatibility with earlier versions of Excel (2007 and 2010)
• Using the Ribbon  (2007 and 2010)

Creating simple formulas

• Basic formulas
• Ordering calculations

Handling formulas

• Editing formulas
• Using absolute references in formulas

Using basic functions

• The function wizard
• Autocalculate

Working with workbooks

• Navigating and editing worksheets
• Moving and copying
• Deleting data
• Inserting and deleting columns and rows
• Zoom
• Freeze panes

Text and number formatting

• Changing text attributes
• Changing number formats
• Using list autofill
• Adjusting column widths and row heights
• Adding simple borders
• Using the Mini Toolbar (2007 and 2010)
• Applying cell styles (2007 and 2010)

Printing worksheets

• Using print preview
• Amending page setup options
• Printing a worksheet
• Using Page Layout view (2007 and 2010)