Advanced Excel

This course is designed for individuals who want to improve their Excel skills and learn advanced techniques for data analysis and reporting. The course covers advanced functions and formulas, data validation, PivotTables, data visualization, and macros. The course will also cover best practices for data organization, efficiency, and accuracy. The course is suitable for professionals in a variety of industries, including finance, accounting, marketing, and operations.

Course Outline:

Advanced Functions and Formulas

• Lookup and Reference Functions
• Text Functions
• Date and Time Functions
• Logical Functions
• Array Formulas

Data Validation and Quality Control

• Data Validation Rules
• Error Checking and Correction
• Data Cleaning Techniques
• Data Quality Metrics and Analysis

PivotTables and PivotCharts

• PivotTable Basics
• PivotTable Options and Customization
• PivotTable Calculations and Analysis
• PivotChart Creation and Formatting

Data Visualization Techniques

• Conditional Formatting
• Sparklines and Data Bars
• Charts and Graphs
• Interactive Dashboards

Macros and Automation

• Macro Basics and Recording
• Editing and Running Macros
• Macro Security and Best Practices
• Automation and Integration with Other Tools

Best Practices for Data Organization and Efficiency

• Efficient Data Entry Techniques
• Structured and Tabular Data Formats
• Named Ranges and Tables
• Data Validation Techniques

Prerequisites:

• Basic knowledge of Excel functions and formulas
• Familiarity with data entry and basic formatting in Excel

Recommended Textbook:

• “Excel 2019 Bible” by Michael Alexander and Richard Kusleika.

Assessment:

• Midterm Exam (30%)
• Final Exam (40%)
• Excel Project (30%)

Note: The course syllabus and assessment methods are subject to change based on instructor’s discretion.