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
Questions & answers
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 & answers
| Course Dates | Venue | Price | ||
|---|---|---|---|---|
| Online | £129 + VAT save £170 | |||
| Online | £149 + VAT save £150 | |||
| London Bridge | £179 + VAT save £120 | |||
| Online | £199 + VAT save £100 | |||
| Online | £229 + VAT save £70 | |||
| London Bridge | £249 + VAT save £50 | |||
| Online | £279 + VAT save £20 | |||
| 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.
"Very welcoming and friendly trainer, made me feel very comfortable with the subject matter and went at a comfortable pace for everyone attending. Really enjoyed the session. Breaks were well spaced."
