Excel Essentials for Smarter Work
Build tidy, error-resistant workbooks and quick summary reports.
Who it is for
Staff who use Excel daily but are largely self-taught, and new team members.
You will learn
- Structure data properly with tables, formats and clean layouts
- Core formulas: SUM, IF, COUNTIFS, SUMIFS, text and date functions
- Look up information accurately with XLOOKUP
- Sort, filter and apply data validation
- PivotTable fundamentals for fast summaries
- Clear charts, shortcuts and good file habits
Outcome
Build a tidy, error-resistant workbook and produce a clean summary report in a fraction of the time.