MS Excel 2019: Expert Tools eLearning Course
Intoduction
In the course MS Excel 2019: Expert Tools you will familiarise yourself in detail with various options of external data import from other formats compatible with Excel. You will also learn how to export data from Excel to these formats. The course later focuses on pivot tables and pivot charts, covering also their formatting, sorting and filtering of data as well as using them in further calculations. Beside that you will become familiar with several advanced functions and Excel features that will help you to process data in larger databases.
Lessons
- Advanced data validation
- OFFSET function
- Advanced filter
- Database functions
- SUBTOTAL function
- Advanced IF functions
- VLOOKUP and HLOOKUP functions
- INDEX and MATCH functions
- External data from web
- External data from MS Access
- Microsoft Power Query Editor
- External data from a Microsoft SQL Server database
- XML data
- PivotTable
- PivotTable formatting
- Sorting and filtering field items
- Calculations in PivotTables
- Other PivotTable options
- Data Model
- PivotChart
This course has a minimum of 25 learner registrations for us to provide a quotation.
Request a Quotation- Language
- UK
- Date last updated
- 1/5/2021
- Duration
- 10 Hours
- Can this course be authored/customised by the end-client
-
- No
- Does this Course have Downloadable Resources (e.g. guide, templates etc)
-
- Downloadable exercise files
- Does this course have Multi Language Support Available
-
- Y (Other language versions available too)
- Does this Course use Audio
-
- Yes
- Does this Course use Videos
-
- No
- Is this course Accredited
-
- No
- Is this Course Mobile Responsive
-
- HTML5 version available
