Course details
Course description
For individuals who are already using Excel to an advanced level. This course will teach you how to use Excel to analyse, collaborate and validate. These tools are extremely useful for auditing and streamlining your workflow. What you will learn: Macros Additional Items Editing & Deleting Macros IfAnd/IfOr Formula Record Macros IfNa Formula Customising Ribbon Convert to Table Screenshots Removing Duplicates Review Data Filter Timeline Track Changes IfError Auditing Tools HLookups Watch Window Sparklines Review Changes Pivot Tables Restricting Data Area Flash Fill Utilities Goal Seek Data Consolidation Power View Reports Create Scenarios What – If Analysis Drawing Diagrams Recommended Pivot Tables Duration: 1 Day Tutor support to help throughout the course. Pitman Training certificate awarded at the end.
Entry requirements
no pre-requisites.
Course options
Course details
Day release
8th Mar 2023 to 7th Mar 2024
Cost: £260.00 (ex. VAT)
Venue details
Pitman Training Edinburgh
4 Queen Street
Edinburgh
EH2 1JE
Course details
Online
8th Mar 2023 to 7th Mar 2024
Cost: £260.00 (ex. VAT)
Venue details
Pitman Training Edinburgh
4 Queen Street
Edinburgh
EH2 1JE
Course details
Day release
8th Mar 2023 to 7th Mar 2024
Cost: £260.00 (ex. VAT)
Venue details
Pitman Training Glasgow
1/1 82 Union Street
Glasgow
G1 3QS
Who to contact
Caroline Meikle
Training Manager for Edinburgh and Glasgow
caroline.meikle@pitman-training.com
01412230090
Course details
Online
8th Mar 2023 to 7th Mar 2024
Cost: £260.00 (ex. VAT)
Venue details
Pitman Training Glasgow
1/1 82 Union Street
Glasgow
G1 3QS
Who to contact
Caroline Meikle
Training Manager for Edinburgh and Glasgow
caroline.meikle@pitman-training.com
01412230090