Intermediate Microsoft Excel Online Short Course

Microsoft Excel: Intermediate Online Course: | Enhance Your Excel Skills

Take your Excel skills to the next level with our Intermediate Microsoft Excel Online Course. This course focuses on advanced techniques and tools that allow you to manage complex datasets, automate tasks, and analyze data with greater efficiency. It’s perfect for those who already have a basic understanding of Excel but want to gain a deeper, more powerful command of the program.

The Intermediate Microsoft Excel Online Course goes beyond basic functions, helping you harness the power of Excel’s advanced capabilities. You will learn how to work with pivot tables, advanced formulas, conditional formatting, and data analysis features. This course is designed for individuals who need to handle more sophisticated Excel tasks, enabling you to make better data-driven decisions in your work environment.

What is Intermediate Microsoft Excel?

Intermediate Microsoft Excel refers to expanding your knowledge of Excel’s more complex features, allowing you to manage, analyze, and visualize data effectively. Key skills include using advanced functions like VLOOKUP and INDEX, creating pivot tables for summarizing data, and automating repetitive tasks using macros.

Why Take an Intermediate Microsoft Excel Online Course?

Taking this course will significantly boost your productivity and analytical skills. You’ll be able to manage large datasets with ease, apply advanced formulas, and create professional reports quickly. By mastering these techniques, you’ll not only increase your proficiency with Excel but also become a more valuable asset in any workplace requiring data analysis and management.

Course Content

  • Applying cell and range names
  • Naming ranges automatically
  • Using specialised functions
  • Fixed referencing
  • Sort and filter data
  • Excel built-in functions
  • Creating a chart
  • Modifying charts
  • Adding data to charts
  • MIN, MAX and AVERAGE
  • COUNT, COUNT-A and COUNTBLANK
  • Rounding
  • Insert graphic objects
  • Draw and modify shapes
  • llustrate workflow using SmartArt graphics
  • Add a background
  • Custom format numbers, dates etc.
  • Watch window option
  • Text to columns
  • Subtotal function
  • Protection
  • Set up calculations
  • Types of errors
  • Breaking links
  • Data validation
  • Hyperlinks
  • Working with dates and time
  • Dynamic dates and the TODAY and NOW functions
  • Conditional formatting
  • Format painter
  • Paste special
  • Pivot table
  • Count using pivot tables and drilling down into detail
  • Updating a pivot table with new data and adding multiple values
  • Using calculated fields in pivot tables
  • Removing or hiding subtotals, grand totals and filling blanks
  • Google sheets
  • Non-accredited: Short course only  
  • Duration: 1h 30m
  • Delivery: Classroom/Online/Blended
  • Access Period: 12 Months 
SpecCon-Short-Course-Footer (1)
Scroll to Top