Professionals and individuals who use Excel for data analysis, reporting, or project management and want to advance their skills to the next level.

"Introduction to Advanced Functions
• Review of basic functions (SUM, AVERAGE, COUNT, etc.)
• Using logical functions (IF, AND, OR)
• Advanced lookup functions (VLOOKUP, HLOOKUP, INDEX-MATCH)

Data Analysis Techniques
• Sorting and filtering data
• Using conditional formatting for data visualization
• Grouping and outlining data

PivotTables and PivotCharts
• Creating PivotTables to analyze data
• Formatting and customizing PivotTables
• Creating PivotCharts for visual representation

Advanced Data Management
• Working with large datasets using Excel tables
• Data validation techniques
• Introduction to Power Query for data cleaning and transformation

Automation and Efficiency Tools
• Introduction to macros and VBA (Visual Basic for Applications)
• Creating and running simple macros
• Using Excel’s built-in tools for automation (Solver, Goal Seek)

Advanced Charting Techniques
• Creating advanced charts (combo charts, sparklines)
• Customizing charts and graphs
• Using chart templates for consistency

"

"Upon successful completion of the Excel Course for Intermediate participants will gain the skills and knowledge necessary to:
• Mastering advanced Excel functions such as VLOOKUP, IF statements, and PivotTables
• Analyzing data using filtering, sorting, and conditional formatting
• Enhancing data visualization with charts and graphs
• Managing large datasets with tables and data validation
• Streamlining workflow with macros and automation tools
• Improving spreadsheet efficiency and accuracy"