Excel Advanced
£300
About this course
For Versions: Excel 2013, 2016, 2019 and Office365
Prerequisites: Attendees should be familiar with the modules from the Excel Intermediate course or happy with creating formulas such as VLookup, IF or comfortable working with large data sets.
Using Styles
Cell Styles Themes Editing styles and Themes
Using Scenarios and Goal Seeking
Using the Scenario Manager Creating a Scenario Displaying a Scenario Editing a Scenario Creating a Scenario summary report Using Goal Seek and Solver
Using Data Tables
Creating Data Tables Placing formulas in data tables Creating a one-variable table Creating a two-variable table
Data Manipulation
What is a Table? Inserting a table Text to Columns Adding records Advanced Filtering Eliminating Duplicate Records Creating Subtotals
Validation
Restricting user Entries Creating Drop-down lists Setting entry parameters Working with Error Alters
Pivot Tables
Creating a PivotTable report Adding PivotTable report fields Refreshing a PivotTable report Formatting a PivotTable report Creating a Pivot Chart Using Slicers in Pivot Tables
Recording Macros
What is a Macro? Recording a macro Assigning a shortcut key Using relative references Assigning a macro to a menu Deleting a custom menu item Deleting a macro
I am text block. Click edit button to change this text. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

Syllabus
Week 1 0/5
Useful Expressions
Tools for Professional Approach: It’s not just about learning, it’s about having the confidence to use English in real life and upgrade your business communication skills.
Week 2 0/4
Diplomatic Language
Tools for Professional Approach - Step 2: It’s not just about learning, it’s about having the confidence to use English in real life and upgrade your business communication skills.
Reviews
Lorem Ipsn gravida nibh vel velit auctor aliquet. Aenean sollicitudin, lorem quis bibendum auci elit consequat ipsutis sem nibh id elit. Duis sed odio sit amet nibh vulputate cursus a sit amet mauris. Morbi accumsan ipsum velit. Nam nec tellus a odio tincidunt auctor a ornare odio. Sed non mauris vitae erat consequat auctor eu in elit.