TAP>Intermediate Microsoft Excel online Elearning.co.za

Course Purpose:

Deepen your understanding of functions, delve into data analysis tools such as pivot tables and charts, and explore advanced formatting and conditional formatting techniques to efficiently manage and present complex data sets. Additionally, you’ll learn to work with larger datasets, employ more sophisticated formulas, and streamline processes through data validation and automation features.

What you’ll learn

“The Intermediate Microsoft Excel course is for those who understand the basics of Excel and are familiar with the Excel screen, formatting and basic formulas. You will explore basic VLOOKUP and pivot tables to ensure that you understand the more advanced formulas and functions of MS Excel.”

Duration: 1 Day

Featured Course

Fundamentals of project management

Course Curriculum

Featured Course

Advanced Microsoft Excel

Course Content

Curriculum

11 Sections
37 Lessons
3 Days

Expanse all sectionsCollapse all sections

Unit 1: Calculating data with advanced formulas
Calculating data with advanced formulas
4
Unit 2: Organising worksheet and table data
Organising worksheet and table data
2
- 2.0
  Sort and filter data
- 2.1
  Excel built-in functions
Unit 3: Presenting data using charts
Presenting data using charts
3
Unit 4: Simplistic formulas
Simplistic formulas
3
Unit 5: Inserting graphic objects
Inserting graphic objects
4
Unit 6: Custom formatting
Custom formatting
1
- 6.0
  Custom format numbers, dates etc.
Unit 7: Other functions
Other functions
9
Unit 8: Dates
Dates
2
- 8.0
  Working with dates and time
- 8.1
  Dynamic dates and the TODAY and NOW functions
Unit 9: Formatting functions
Formatting functions
3
Unit 10: Reporting formula
Reporting formula
5
Unit 11: Google sheets
Google sheets
1
- 11.0
  Google sheets

Requirements

Grade 11
NQF Level 3 or 4

Course Features

Lectures 37
Quizzes 0
Duration 3 days
Skill level All levels
Language English
Students 1580
Assessments Yes

Computer

TAP> Intermediate Microsoft Excel