Description

Are you comfortable with the basics of Microsoft Excel—creating simple formulas, adding cells, and basic formatting—but find yourself struggling with more advanced tasks? When it comes to building smarter, more efficient worksheets that handle recurring data entry with ease and accuracy, many of us either turn to IT for help or revert to manual methods like pen, paper, and calculators.

Imagine having the skills to design Excel worksheets tailored to your daily tasks, cutting down hours of repetitive work into just a few moments of data entry. Microsoft Excel is one of the most powerful tools in the Microsoft Office suite, yet its advanced features often seem intimidating or hard to grasp. The truth? With the right training, those features are easier to use than you might think.

Our Microsoft Excel Intermediate Training is designed to bridge the gap between basic understanding and professional-level proficiency. This course provides hands-on instruction, focusing on practical techniques and real-world applications to help you unlock Excel’s full potential. Don’t let outdated processes slow you down—empower yourself with the skills to excel.

This is an intermediate-level course.

Course Curriculum

Session 1: Working with Templates 
March 4th, 9 am - 11 am (AKT)

• Using Excel Online Templates
• Creating Templates from a Worksheet
• Saving and Sharing Templates
• Editing Templates
• Using Templates to Start New Worksheets
• Template Best Practices

Session 2: Data Controls
March 11th, 9 am - 11 am (AKT)

• Sorting and Filtering Data
• Finding Data
• Working With Conditional Formatting
• Integrating Filters and Conditional Formatting

Session 3: Conditional & Lookup Formulas 
March 18th, 9 am - 11 am (AKT)

• Linking Workbooks and Worksheets via Formulas
• Conditional Formulas & Functions
• Lookup Formulas & Functions
• Nesting Formulas
• Other Useful Formulas and Functions

Session 4: Charts & Tables
March 25th, 9 am - 11 am (AKT)

• Chart Planning
• Creating Basic Charts and Tables
• Chart Types and Formats
• Pivot Tables
• Sharing Charts & Tables