Microsoft Excel 2016 – Level 2 (Advanced) , International Leadership Academy, dinsdag, 15. juni 2021
Learn on this course in a fast and efficient way to calculate with Excel. You will learn to make calculations through advanced features, databases and PivotTables. In addition, it will be explained how this data can be presented in an optimal way.
Who is this course for?
This course is designed for those who want to enhance their working knowledge of Excel. This course is suitable for those who have an understanding of Excel to the extent of the Level 1 course.
What’s Involved?
With a group of no more than ten participants, you will explore Excel focussing specifically on the areas below:
Formats
Modify Number format
Create and modify Cell styles
Create Table styles
Conditional formatting
Copy formatting
Working with databases
Creating and formatting Tables
Sort lists (or tables)
Filter lists (or tables)
Group and outlines of data
Using subtotals
Calculating with advanced functions
Working with cell names
Creating calculations over more worksheets and files
Calculate with Date and Time functions
Calculate with Financial functions
Calculate with Statistical functions
Calculate with Lookup functions
Calculate with Logical functions
Calculate with Database functions
Presenting data with Charts
Creating a chart
Modify a chart
Formatting a chart
Moving a chart
Sparklines
Introduction to Pivot Tables
Creating a PivotTable
Creating a PivotChart
Graphical objects
Insert a picture
Creating shapes
Formatting graphical elements
Changing the following order of objects
Grouping objects
Moving, duplicating and changing the size of objects
Using SmartArt
Modify the Excel environment
Creating a new workbook using a template
Using themes
Insert, create, modify and delete Custom lists
Inserting, modifying en removing hyperlinks
Programme Date
Thursday 15th June 2021
Programme Cost
€195 Euros
Programme Facilitator
Westhaghe Training & Advies - Bert Roos
Cancellation
Cancellation can be made up to six weeks before the first day of delivery by contacting us directly at email . Any participant cancellation after this time is non-refundable.
Who is this course for?
This course is designed for those who want to enhance their working knowledge of Excel. This course is suitable for those who have an understanding of Excel to the extent of the Level 1 course.
What’s Involved?
With a group of no more than ten participants, you will explore Excel focussing specifically on the areas below:
Formats
Modify Number format
Create and modify Cell styles
Create Table styles
Conditional formatting
Copy formatting
Working with databases
Creating and formatting Tables
Sort lists (or tables)
Filter lists (or tables)
Group and outlines of data
Using subtotals
Calculating with advanced functions
Working with cell names
Creating calculations over more worksheets and files
Calculate with Date and Time functions
Calculate with Financial functions
Calculate with Statistical functions
Calculate with Lookup functions
Calculate with Logical functions
Calculate with Database functions
Presenting data with Charts
Creating a chart
Modify a chart
Formatting a chart
Moving a chart
Sparklines
Introduction to Pivot Tables
Creating a PivotTable
Creating a PivotChart
Graphical objects
Insert a picture
Creating shapes
Formatting graphical elements
Changing the following order of objects
Grouping objects
Moving, duplicating and changing the size of objects
Using SmartArt
Modify the Excel environment
Creating a new workbook using a template
Using themes
Insert, create, modify and delete Custom lists
Inserting, modifying en removing hyperlinks
Programme Date
Thursday 15th June 2021
Programme Cost
€195 Euros
Programme Facilitator
Westhaghe Training & Advies - Bert Roos
Cancellation
Cancellation can be made up to six weeks before the first day of delivery by contacting us directly at email . Any participant cancellation after this time is non-refundable.