Excel: An Advanced Level

Current Status
Not Enrolled
Price
R 500,00
Get Started

Course overview:

Are you ready to take your Excel skills to the next level? In this comprehensive Advanced Excel Course, you’ll delve into the depths of Excel’s powerful features, enabling you to become a proficient spreadsheet master. Whether you’re a business professional seeking to streamline data analysis or an Excel enthusiast aiming to unlock the full potential of this versatile tool, this course has something for you.

What you’ll learn:

  • Cell References: Identify data location within formulas for dynamic calculations.
  • Count: Tallies the number of cells containing numeric or specific values.
  • Logical Functions: Analyse conditions, make decisions, and categorise data logically.
  • Financial: Calculates financial operations, such as loans, interest, and investments.
  • What-if Analysis (Goal Seek): Predicts input changes to achieve desired results.
  • What-if Analysis (Data Tables): Generates multiple outcomes by varying two variables.
  • Validation: Sets rules to restrict input to predefined data or conditions.
  • Filter: Displays specific data by hiding non-matching rows temporarily.
  • Conditional Format: Alters cell appearance based on user-defined conditions or values.
  • Charts: Visualises data trends and comparisons using graphical representations.
  • Headers and Footers: Adds text or graphics to print at the top/bottom of pages.
  • Subtotals: Calculates and summarises data within categorised groups or ranges.
  • Links: Connects data between worksheets or files for real-time updates.
  • Printing: Prepares and formats worksheets for physical or digital printing.
  • Protection: Secures cells, sheets, or workbooks to control data access and modification.
  • Freeze Panes Mastery
  • Removing Duplicates Like a Pro
  • Harnessing the Power of MATCH
  • Logical Functions Unleashed
  • Counting Techniques
  • Mastering Lookup Functions
  • Embracing Table Features
  • Slicers for Data Visualisation
  • Visualising Data with Sparklines
  • Sheet Very Hidden Secrets
  • Pivot Tables Demystified
  • Macro Magic

This course includes:

Video-Based Learning

Final Assessments

Participant Feedback

SA Campus Certificate

Who this course is for:

  • The programme is aimed at all individuals that have Intermediate levels of skills in Excel and are upskilling themselves and improving computer proficiency.

Course Content

Expand All
Section 1: Freeze Panes
Section 2: Removing Duplicates
Section 3: Match
Section 4: Logical Functions
Section 5: Count
Section 6: Lookups
Section 7: Tables
Section 8: Slicers
Section 9: Sparklines
Section 10: Sheet Very Hidden
Section 11: Pivot Tables
Section 12: Macro's
Current Status
Not Enrolled
Price
R 500,00
Get Started

Course Content

Expand All
Section 1: Freeze Panes
Section 2: Removing Duplicates
Section 3: Match
Section 4: Logical Functions
Section 5: Count
Section 6: Lookups
Section 7: Tables
Section 8: Slicers
Section 9: Sparklines
Section 10: Sheet Very Hidden
Section 11: Pivot Tables
Section 12: Macro's
Current Status
Not Enrolled
Price
R 500,00
Get Started

Course Content

Expand All
Section 1: Freeze Panes
Section 2: Removing Duplicates
Section 3: Match
Section 4: Logical Functions
Section 5: Count
Section 6: Lookups
Section 7: Tables
Section 8: Slicers
Section 9: Sparklines
Section 10: Sheet Very Hidden
Section 11: Pivot Tables
Section 12: Macro's