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
Course Dates | Venue | Price | ||
---|---|---|---|---|
London Bridge | £299 + VAT | |||
London Bridge | £299 + VAT | |||
Online | £149 + VAT save £150 | |||
London Bridge | £299 + VAT | |||
Online | £169 + VAT save £130 | |||
London Bridge | £199 + VAT save £100 | |||
Online | £199 + VAT save £100 | |||
London Bridge | £229 + VAT save £70 | |||
Online | £229 + VAT save £70 | |||
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 |
Tom works in Internal Communications for an NHS service provider. Listen to his experience about attending our online Adobe Premiere Intro course.
Meija works for the MOD, in marketing and communications and here tells us about attending her online Social Media Marketing course with Alice.
Katie works for the Ministry of Defence as a Digital Content Editor and here tells us about attending her online Social Media Marketing course with Kirsty.
"Being very friendly and not overwhelming. Making Excel fun and accessible."