Course Dates | Venue | Price | ||
---|---|---|---|---|
London Bridge | £179 + VAT save £120 | |||
Online | £199 + VAT save £100 | |||
London Bridge | £199 + VAT save £100 | |||
Online | £229 + VAT save £70 | |||
London Bridge | £229 + VAT save £70 | |||
Online | £249 + VAT save £50 | |||
London Bridge | £249 + VAT save £50 | |||
Online | £279 + VAT save £20 | |||
London Bridge | £279 + VAT save £20 | |||
Online | £299 + VAT | |||
London Bridge | £299 + VAT | |||
Online | £299 + VAT | |||
London Bridge | £299 + VAT | |||
Online | £299 + VAT | |||
London Bridge | £299 + VAT | |||
Online | £299 + VAT | |||
London Bridge | £299 + VAT | |||
Online | £299 + VAT | |||
London Bridge | £299 + VAT | |||
Online | £299 + VAT |
Getting to Grips with the Basics
• The Excel Interface
• Using Backstage View
• Understanding the Ribbon
• Using & customising the Quick Access toolbar
Effectively Organise Your Workbooks
• Creating, saving & opening a new Workbook
• Entering numbers, text & dates in a Workbook
• Deleting Cell Contents
• Quickly sorting data
• Adding, deleting & naming sheets
Controlling the Layout of Spreadsheets Effortlessly
• Inserting Columns & Rows
• Deleting Columns & Rows
• AutoFill
• Using Cut, Copy & Paste
• Using Undo & Redo
Uncomplicate Tasks by Defining & Creating Calculations
• Writing a basic formula
• Understanding the order of BODMAS
• The Sum function & AutoSum
• Creating statistical functions (Average, Max and Min)
• Working with Relative References when Copying Formulas
Questions & answers
Beautifully Presenting Your Data
• Font formatting
• Borders & Shading
• Number formatting (currency etc)
• Alignment options
• Clearing formats
Fine-Tuning Your Page Layout before Printing Worksheets
• Setting page margins & page orientation
• Creating a Header & Footer
• Printing all or part of a worksheet
• Setting Print Titles for large Worksheets
Visual Representations of Your Data
• Creating a chart
• Changing the Chart Type
• Basic Formatting of Charts
Questions & answers
"Lisa done very well at making it interactive and easy to ask questions where and when needed"