Course details
Course description
For individuals who are already using Excel to an intermediate level. This course will streamline and perfect their Excel skills by teaching the advanced features available in the Excel package. What you will learn: Formula Utilities VLookups Protecting Data IF Statements Hide & Unhide Data SumIf Named Ranges CountIf(s) Working With Dates Text Formula - Concatenate Working With Comments Linking Spreadsheets Data Validation Separating Text Data Headers & Footers Data Analysis Linking Data Advanced Sort Options Linking Spreadsheets Filters Identifying Links Subtotals Linking Separate Workbooks Updating Pivots Icons & Data Bars in Conditional Formatting Filter & Sort Using Colour Pivot Tables Creating Pivot Tables Pivot Charts Slicers Refreshing Data Updating Ranges 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