Dreamweaver course in north London

Microsoft Excel: Essentials/Introduction

Microsoft Excel is the popular spreadsheet from Microsoft and part of the Microsoft Office suite. This training course is designed to let users get to grips with the main features of Microsoft Excel. It is entirely 'hands on', so those attending will get lots of practice in creating and modifying actual spreadsheets.

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
 
 

We recommend the following courses that relate to this class: Microsoft Excel Intermediate and Microsoft Access Introduction

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