Home

Level 3: Advanced Excel Skills

Level:
Advanced
Duration:
3 Hours
Award:
Certificate of completion
Price:
K15,000
Register now

What you'll learn

  • How to create and format Pivot Tables
  • How to use Text functions
  • Working with Date and Time Functions
  • Summarizing functions

Description

Do you have an intermediate understanding of Excel but are keen to break through to true mastery? Want to finally use the programme with ease and confidence at work and become known as an expert user?

Requirements

  • Intermediate Excel knowledge
  • You will need a PC with Microsoft Windows and Excel installed on it

Course Outline

Unit 3.1 – Working with Dates and Times plus Functions

  • Date and time formatting
  • Date and time functions.

Unit 3.1 – Working with Text Functions

  • Entering and formatting text, extracting or combining parts of text.
  • Text Functions
  • Date and Time Functions
  • Functions

 Unit 3.3 – Connecting Workbooks

  • Setting up links between Workbooks. The dangers and pitfalls of doing so.
  • Managing links between Workbooks and updating external references.

Unit 3.4 – Summarizing and Nested Functions

  • Count If(s)
  • Average If(s)
  • Nested If(s)

Unit 3.5 – PivotTables 1– Simple Summaries

  • Summarizing data (presenting database in terms of different subcategories) with pivot tables.
  • Changing Value Field Settings to show counted rather than ‘summed’ data.
  • Slicers and Timelines.

Thanks for your submission
Oops! Something went wrong while submitting the form.
Thanks for your submission
Oops! Something went wrong while submitting the form.
Thanks for your submission
Oops! Something went wrong while submitting the form.
Thanks for your submission
Oops! Something went wrong while submitting the form.
Thanks for your submission
Oops! Something went wrong while submitting the form.
Thanks for your submission
Oops! Something went wrong while submitting the form.
Thanks for your submission
Oops! Something went wrong while submitting the form.

More

Excel

Courses

Level 1: Excel for Beginners

Lorem ipsum dolor sit amet, consectetur adipiscing elit.

Duration:
3 Hours
Price:
K10,000
Level 2: Intermediate Excel Skills

Lorem ipsum dolor sit amet, consectetur adipiscing elit.

Duration:
3 Hours
Price:
K12,000