Course: Excel Intermediate Course | SA Campus Student Portal

• Course information

  Collapse all Expand all

  Welcome to the Intermediate Excel Course!

  
  Take your spreadsheet skills to the next level.

  If you’ve already got a basic understanding of Excel and are ready to dig deeper, you’re in the right place. This course is designed to bridge the gap between beginner and advanced Excel skills, giving you the tools to work smarter, faster, and with more confidence.

  Through this course, you’ll explore key features and functions that will help you analyse, visualise, and manage data more effectively. From dynamic formulas to financial calculations and data validation, you’ll learn how to make Excel work for you in a more powerful way.

  By the end of this course, you'll know how to:

  • Use cell references to create flexible formulas

  • Apply the COUNT functions to work with numeric and text data

  • Use logical functions to make decisions based on your data

  • Perform financial calculations for budgeting, loans, and investments

  • Conduct what-if analysis using tools like Goal Seek and Data Tables

  • Set up data validation to control inputs and reduce errors

  • Use filters to quickly find the information you need

  • Apply conditional formatting to highlight trends or exceptions

  • Create charts that bring your data to life

  Not available unless: You are a(n) Student

• Cell References

  

  Not available unless: You are a(n) Student

• Count

  

  Not available unless: The activity 2 Relative Reference is marked complete

• Logical Functions

   

  Not available unless: The activity 11 CountIF is marked complete

• Financial

   

  Not available unless: The activity 14 SumIF is marked complete

• What-if Analysis (Goal Seek)

  

  Not available unless: The activity 16 Payment is marked complete

• What-if Analysis (Data Tables)

  

  Not available unless: The activity 18 Goal Seek Example 2 is marked complete

• Validation

  

  Not available unless: The activity 20 Two data table is marked complete

• Filter

  

  Not available unless: The activity 27 Removing a validation is marked complete

• Conditional Format

  

  Not available unless: The activity 31 Removing the filter is marked complete

• Charts

  

  Not available unless: The activity 34 Conditional Format Example 3 is marked complete

• Headers and Footers

  

  Not available unless: The activity 42 Axis Reverse order is marked complete

• Subtotals

  

  Not available unless: The activity 43 Headers and footers is marked complete

• Links

  

  Not available unless: The activity 46 Removing subtotals is marked complete

• Printing

  

  Not available unless: The activity 51 Paste Link is marked complete

• Protection

  

  Not available unless: The activity 60 Printing overview is marked complete

• Assessment

  

  Not available unless: The activity 69 Very Hidden is marked complete

• Certificate of Completion
  Show more Show less

  Not available unless: The activity Excel: An Intermediate Level Course: Assessment is marked ... ...

  Not available unless: The activity Excel: An Intermediate Level Course: Assessment is marked complete