100 megs data gift for every genuine quote requested
This course advances the user's knowledge of functions, demonstrates how to manage data with Excel.
Delegates will be able to create, modify, enhance and print a wide variety of spreadsheets using their newly acquired skills. The Microsoft Excel 2016 Intermediate Training Course is designed to provide a comprehensive understanding of the basic features of Excel 2016, and how to use them correctly to fulfil various tasks.
This hands-on training course is available now Gauteng, Durban and Cape Town.
Contact us today for a group quote.
Who Should Attend
The Microsoft Excel Intermediate 2016 training course extends and expands your current Excel knowledge that provides the student with the skills to quickly produce professional and effective spreadsheets.
The course presents real-world problems and solutions to assist you with everyday use of creating and working with Excel spreadsheets.
Excel 2016 has now been supercharged with additional tools and features that allow you to create reports, analyse and manipulate data faster and more professionally than you ever thought possible.
With our expert tuition, students will learn how to manage large datasets, summarise data, create and edit complex formulas, apply more intricate formatting, create and present professional looking charts and work more effectively with existing worksheets and workbooks. Your newly developed skills will be the envy of all your colleagues.
Learning Outcomes - Microsoft Excel 2016 Intermediate Training Course
This course will provide learners with a core understanding of how to effectively operate and use the Excel spreadsheet software at an intermediate level.
After completing this course, participants will have learned to:
- Work with functions.
- Work with lists.
- Analyse data.
- Visualise data with charts.
- Use Pivot Tables and Pivot Charts.
Course Content - Microsoft Excel 2016 Intermediate Training Course
Lesson 1: Working with Functions
Topic A: Work with Ranges
Topic B: Use Specialised Functions
Topic C: Work with Logical Functions
Topic D: Work with Date & Time Functions
Topic E: Work with Text Functions
Lesson 2: Working with Lists
Topic A: Sort Data
Topic B: Filter Data
Topic C: Query Data with Database Functions
Topic D: Outline and Subtotal Data
Lesson 3: Analysing Data
Topic A: Create and Modify Tables
Topic B: Apply Intermediate Conditional Formatting
Topic C: Apply Advanced Conditional Formatting
Lesson 4: Visualising Data with Charts
Topic A: Create Charts
Topic B: Modify and Format Charts
Topic C: Use Advanced Chart Features
Lesson 5: Using Pivot Tables and Pivot Charts
Topic A: Create a Pivot Table
Topic B: Analyse Pivot Table Data
Topic C: Present Data with Pivot Charts
Topic D: Filter Data by Using Timelines and Slicers