Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
This course covers the advanced tools in Excel. You’ll learn how to create custom cell formats. You’ll start to learn about Pivot Tables, the slicer tool, Macros and how to record steps to common tasks. You’ll learn how to trace and watch changes with cells and formulae.
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Advanced Formatting|
This section includes the exercise files for Excel Level 3. Please download these before you start the course.
Orientation of textPreview
Merge and centre optionsPreview
Find and Select OptionsPreview
Paste special optionsPreview
|Section 2: Pivot Tables and Pivot Charts|
What is a Pivot table?
How to create a Pivot table
Working with an existing Pivot table
|Section 3: Macros|
Running an existing MacroPreview
Recording a macro
Recording a macro using relative referencing
Deleting a macro
Assigning a macro to a command button on the Quick Access Toolbar
Applying modifications to a Macro
|Section 4: Forms|
The data form
Inserting form controls and setting their properties
|Section 5: Advanced Window Options|
Using New window
Advanced Worksheet protection
|Section 6: Working with Formulae|
Our online eLearning courses build on 20 years experience of classroom training. Training is our business. The courses are delivered by our expert tutors and we know where topics become complex and need better explanations because we see it every day in our classrooms.
Some of the world’s most prominent businesses choose us to teach their employees Excel – including Google, Facebook, Pfizer, Zurich, Aer Lingus, Allianz, HSBC, Intel, Dell, KPMG – even Microsoft use our Excel courses to train their employees on Excel.