| 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 | £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 | |||
| London Bridge | £299 + VAT | |||
| Online | £299 + VAT |
Introduction to Microsoft Excel
• The Excel Interface
• Opening a worksheet
• Amending data in a worksheet
Getting to grips with the basics
• Using Backstage View
• Understanding the Ribbon
• Using & customising the Quick Access toolbar
Effectively organising your workbooks
• Creating, saving and opening a new workbook
• Entering numbers, text and dates in a workbook
• Deleting cell contents
• Quickly sorting data
• Adding, deleting and naming sheets
Controlling the layout of spreadsheets effortlessly
• Inserting columns and rows
• Deleting columns and rows
• Using AutoFill
• Using Cut, Copy and Paste
• Using Undo and Redo
Uncomplicate tasks by defining and creating calculations
• Writing a basic formula
• Understanding the order of BODMAS
• The Sum function and AutoSum function
• Creating statistical functions (Average, Max and Min)
• Working with Relative References when copying formulas
Beautifully presenting your data
• Font formatting
• Borders and 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
Creating different visual representations of your data
• Creating a chart
• Changing the chart type
• Basic formatting of charts
Questions and answers
This course is also available as a private course. If you wish we can tailor the content for your team. Please contact us for more details.
"Trainer was very helpful with his knowledge"
>
