Excel: An Intermediate Level

This course will provide you with the right information to give you the knowledge you will need to become proficient in the Intermediate Principles of Excel.

Last updated 16/01/2024

Course overview:

This course will provide you with the right information to give you the knowledge you will need to become proficient in the Intermediate Principles of Excel.

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: Analyze conditions, make decisions, and categorize 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: Visualizes 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 summarizes data within categorized 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.

This course includes:

Video-Based Learning

Final Assessments

Participant Feedback

SA Campus Certificate

Who this course is for:

  • Office Professionals
  • Administrative Assistants
  • Students
  • Small Business Owners
  • Job Seekers
  • Data Entry Clerks
  • Non-profit Organizations
  • Teachers and Educators
  • Individuals Interested in Self-Improvement
  • People Transitioning Careers
  • Data Analysis Enthusiasts
  • Retirees and Seniors
  • Entry-Level Professionals
  • Project Managers
  • Sales and Marketing Professionals

Course Content

Section 1: Cell References
Section 2: Count
Section 3: Logical Functions
Section 4: Financial
Section 5: What-if Analysis (Goal Seek)
Section 6: What-if Analysis (Data Tables)
Section 7: Validation
Section 8: Filter
Section 9: Conditional Format
Section 10: Charts
Section 11: Headers and Footers
Section 12: Subtotals
Session 13: Links
Section 14: Printing
1 of 2
Current Status
Not Enrolled
Price
R 500,00
Get Started

Course Content

Section 1: Cell References
Section 2: Count
Section 3: Logical Functions
Section 4: Financial
Section 5: What-if Analysis (Goal Seek)
Section 6: What-if Analysis (Data Tables)
Section 7: Validation
Section 8: Filter
Section 9: Conditional Format
Section 10: Charts
Section 11: Headers and Footers
Section 12: Subtotals
Session 13: Links
Section 14: Printing
1 of 2
Current Status
Not Enrolled
Price
R 500,00
Get Started

Course Content

Section 1: Cell References
Section 2: Count
Section 3: Logical Functions
Section 4: Financial
Section 5: What-if Analysis (Goal Seek)
Section 6: What-if Analysis (Data Tables)
Section 7: Validation
Section 8: Filter
Section 9: Conditional Format
Section 10: Charts
Section 11: Headers and Footers
Section 12: Subtotals
Session 13: Links
Section 14: Printing
1 of 2