MS Excel Basic
Master the Foundations of Excel
Whether you’re new to spreadsheets or looking to refresh your fundamentals, this course builds a solid foundation in Microsoft Excel.
What You'll Learn
- Navigating the Excel Interface
- Entering and formatting data
- Basic formulas (SUM, AVERAGE, COUNT, etc.)
- Sorting and filtering data
- Creating simple charts
- Saving, printing, and sharing workbooks
- Understanding rows, columns, and cell references
Who Should Take This Course
Ideal for professionals, administrative staff, students, and anyone new to Excel.
Course Format
- Live virtual sessions
- In-person training available upon request
- Downloadable exercises and hands-on examples tailored to business and data
MS Excel Intermediate
Level Up Your Excel Skills
Take your Excel knowledge further with functions, data tools, and visualization techniques to make your workflow smarter and more efficient.
What You'll Learn
- Logical functions (IF, AND, OR, nested IFs)
- Lookup functions (VLOOKUP, HLOOKUP, XLOOKUP)
- Conditional formatting
- Data validation techniques
- Working with multiple worksheets and workbooks
- Introduction to PivotTables and basic charting
- Basic data cleaning techniques
Who Should Take This Course
Perfect for those who already use Excel and want to streamline tasks, analyze data faster, and make better business decisions.
Course Format
- Interactive live sessions
- In-person training available for teams or onsite events
- Real-world datasets, post-course quizzes, and productivity shortcuts
MS Excel Advanced
Unlock the Full Power of Excel
Designed for power users, this course dives deep into automation, dynamic analysis, and advanced data modeling.
What You'll Learn
- Advanced formulas (INDEX/MATCH, OFFSET, INDIRECT, array formulas)
- Complex PivotTables and PivotCharts
- Power Query for data transformation
- Power Pivot for data modeling
- Introduction to macros and VBA basics
- Dashboard creation and interactive visuals
- Integrating Excel with other tools (e.g., SharePoint, Access, Power BI)
Who Should Take This Course
Analysts, IT professionals, managers, or anyone managing large datasets or building reports.
Course Format
- Project-based virtual instruction
- In-person training available for enterprises and specialized groups
- One-on-one instructor feedback
- Optional integration with AI tools for enhanced automation