You have been using Excel 2019 for a while and either in training or through self-development you have a solid foundation in the basic and intermediate skills for working in Excel. You have used Excel to perform tasks such as running calculations on data and sorting and filtering numeric data. In this course, you will extend your knowledge into some of the more specialised and advanced capabilities of Excel by automating some common tasks and applying advanced analysis techniques to more complex data sets such as PivotTables.
This course is aimed at end users who want to develop their skills so they can use advanced techniques to manipulate Excel data. Delegates should have attended CourseMonster's Excel 2019 Intermediate course or have equivalent knowledge.
Create macros to automate common tasks
Create and manipulate PivotTables and PivotCharts
Write advanced Lookup and Reference Functions
Use advanced techniques to analyse data
Ensure acceptable data entry with Data Validation
Create, edit and format spreadsheets
Navigate within worksheets and books
Use Insert Function to create built-in functions
Work with absolute references
Create named ranges
Create Tables within Excel
Sort and filter data
Module 1: Creating Macros
Creating a Macro
Comparing Relative and Absolute Macros
Running a Macro
Editing a Macro
Assigning Shortcuts to Macros
Enabling Macros in the Backstage View
Copying a Macro between Workbooks
Document Properties and the Document Inspector
Module 2: Collaborating With Others
Module 3 - Creating PivotTables, PivotCharts and Slicers
Creating a PivotTable
Amending the Fields in a PivotTable
Updating a PivotTable
Adding Calculations to a PivotTable
Add Grouping to a PivotTable
Creating a PivotChart
Creating PivotTables from Tables and Related Tables
If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. It's a cost effective option.
Submit an enquiry from any page on this site, and let us know you are interested in the requirements box, or simply mention it when we contact you.
ITILv3, RESILIA, PRINCE2, PRINCE2 Agile, AgileSHIFT, MSP, M_o_R, P3M3, P3O, MoP, MoV courses on this page are offered by QA Affiliate of AXELOS Limited. ITIL, RESILIA, PRINCE2, PRINCE2 Agile, AgileSHIFT, MSP, M_o_R, P3M3, P3O,MoP, MoV are registered trademarks of AXELOS Limited. All rights reserved.