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.

0
(0 rating)
12 students
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
Admin bar avatar
Arthur Viljoen Instructor
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