In the course MS Excel 2016/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.
OVERVIEW
REQUIREMENTS
- Persons who have a lot of experience on Excel and want to complete expert tools to utilise all the advantages of Excel for Office productivity, reports and analysis .
- Make sure you have completed the beginners, intermediate and the advanced courses first or make sure you understand how to complete all elements (see other courses to consider under the progression section).
CONTENT
INDICATIVE CONTENT
- 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 Access
- Import of data through Microsoft Query
- Data from external sources
- XML data
- PivotTable
- PivotTable formatting
- Sorting and filtering field items
- Calculations in PivotTables
- Other PivotTable options
- Data Model
- PivotChart
METHOD OF DELIVERY/DURATION
- Online and Customised for Organisations
CERTIFICATION
Personalised Certificate of Completion or option to complete QQI accredited course at level 3, 4, 5 and 6, ECDL, MOS
ASSESSMENT
- Online assessment
COST
€59.95. Check out the great deals on completing more than one course.
PROGRESSION
This MS Excel 2016 course is for Expert users to demonstrate advanced tools within the system.
There is the option to purchase: