New or intending users of Microsoft Excel who wish to gain a good understanding of the software.
Because of the amount of material we cover in class, we do require students to be comfortable using a mouse, opening and saving files, and the general operations of computers.
Course outline
Module 1: Getting Started with Excel
- What is Microsoft Excel?
- Excel and the Excel Environment
- Navigating and Selecting Cells in Worksheets
- Creating a New Workbook
- Saving your Work
- Opening and Closing Workbooks
- Using Help
Module 2: Creating Calculations with Formulas and Functions
- Creating Formulas
- Auto Calculate
- Inserting Functions and using AutoSum
- Copying a Formula
- Creating an Absolute Formula
Module 3: Modifying a Worksheet
- Cut, Copy and Paste Commands
- Undo and Redo Commands
- Inserting and Deleting
- Column Width and Row Height
- Hide and Unhide Options
- Find and Replace
- Performing a Spell Check
- AutoFill
-
-
Module 4: Formatting an Excel Worksheet
- Text Formatting
- Add Borders and Colours to Cells
- Cell Alignment
- Number Formatting
- Cell Styles and Galleries
- Format Painter
Module 5: Managing Worksheets and Workbooks
- Managing Worksheets
- Freezing Rows and Columns
- Splitting the Screen
- Arrange All Command
- View Side by Side
Module 6: Printing Workbooks
- Print Preview
- Setting the Print Area
- Repeating Titles on Each Page
- Manual Page Breaks
- Page Layout View
- Add Page Headers and Footers
-
-
Class Type |
Live Tutor-led Virtual Classroom |
Course Duration |
3 Days (10 hours in total) |
Course Days and Times |
Monday 9am to 1pm, Tuesday 9am to 1pm, & Wednesday 9am to 11am
|
|
|
Private Course Price |
£500 for up to 4 Learners, then £100 per additional learner |
Dates |
Will require 5 days notice to schedule training - Please call centre on 0208 443 2888 to arrange dates |