Course Dates | Venue | Price | ||
---|---|---|---|---|
London Bridge | £199 + VAT save £100 | |||
Online | £199 + VAT save £100 | |||
London Bridge | £229 + VAT save £70 | |||
Online | £229 + VAT save £70 | |||
London Bridge | £249 + VAT save £50 | |||
Online | £249 + VAT save £50 | |||
London Bridge | £279 + VAT save £20 | |||
Online | £279 + VAT save £20 | |||
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 |
Introduction
Refresher on basic formulas & functions
• Statistical functions (Average, Max, Min, Count and Counta)
• Using relative & absolute addressing
• Creating, using and editing range names
• Locking cells and worksheets
Working with worksheets
• Grouping worksheets
• Setting tab colour
• Performing calculations across sheets
Taking formulas to the next level
• Using SUMIFS & COUNTIFS
• The basic IF function
• Simple VLOOKUP
Highlight data with formatting
• Apply Conditional Formatting rules
• Use the Conditional Formatting rules manager
• Create Conditional Formatting using a formula
• Clearing rules
Working with lists
• Freezing panes
• Filtering data
• Using the subtotal tool
• Formatting as a table
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.
"Really Great Instructor., Very Insightful"