Excel Intermediate

Wishlist Share
Share Course
Page Link
Share On Social Media

About Course

The Excel Intermediate course is designed to take learners beyond the basics and equip them with a deeper understanding of Excel’s more sophisticated features and functions. This course is ideal for individuals who have a foundational knowledge of Excel and wish to enhance their data analysis and spreadsheet management skills.Module 1: Manage Advanced Charts and Tables focuses on mastering PivotTables and Pivot Charts, allowing learners to summarize and analyze large sets of data efficiently.Module 2: Working with Functions delves into more complex formulas, such as criteria-based calculations and various logical functions like IF and IFS, improving decision-making capabilities within spreadsheets. It also covers essential lookup and date functions, enabling learners to manage and retrieve data effectively.Module 3: Data Management teaches data consolidation, scenario creation, and understanding, as well as predictive tools like Goal Seek and Data Tables, which can aid in forecasting and optimizing data outcomes.By completing this course, learners will significantly enhance their Excel proficiency, making them adept at managing and interpreting data, and ultimately become more valuable in roles that require advanced Excel skills.

Show More

What Will You Learn?

  • Create, format, and customize PivotTables for summarizing datasets.
  • Generate and modify PivotCharts to visually represent data from PivotTables.
  • Apply functions like COUNTIF(), COUNTIFS(), SUMIF(), and SUMIFS() for criteria-based calculations.
  • Utilize the IF function to execute conditional logic in data analysis.
  • Integrate AND, OR, Nested IF(), and IFS() functions for complex decision-making formulas.
  • Implement LOOKUP functions (VLOOKUP, MATCH, XLOOKUP) to search and reference data across spreadsheets.
  • Leverage Date Functions to manage and manipulate date-related data in Excel.
  • Use YEAR, MONTH, and DAY functions to extract specific date components from date values.
  • Consolidate data from multiple sources for comprehensive analysis and reporting.
  • Understand and create scenarios, utilize Goal Seek for solving equations, and analyze data with Data Tables for predictive analysis.