Microsoft Excel
Info Systems
A course by
WITT
A hands-on two-day course to advance your Microsoft Excel skills, focusing on data analysis, automation, and spreadsheet design for more efficient workflow and productivity.
$ENQUIRE
Interested in this course? Enquire now for Domestic & International pricing
Core skills this course teaches
Efficient navigation
Navigate around workbooks and worksheets more efficiently using Excel features.
Mathematical operations
Understand and apply the correct order of mathematical operations within Excel formulas, including array formulas.
About This Course
This live, online workshop is designed to improve your proficiency with Microsoft Excel. Over two consecutive mornings (3 hours each), you will learn workflow tips, advanced features, and automation techniques to streamline analysis, budgeting, forecasting, and reporting. Suitable for users seeking to deepen their Excel capabilities, consolidate knowledge, and adopt a more efficient approach to spreadsheet use.
Course Content
- Navigation and workflow speed techniques
- Selection techniques
- Mathematical rules and operations in Excel
- Conditional Functions and data analysis
- Using text functions (splitting, combining)
- Name Ranges
- Hiding and protecting columns, rows, and formulas
- Lookup tables and list automation
- Automating entries
- Formula auditing and error tracing
- Absolute and relative referencing (locking cells)
- Conditional formatting and data validation
- Sorting and filtering data
- Subtotalling worksheets
- Manipulating data using Pivot Tables, Pivot Charts, Slicers
- Multi-worksheet formulas (3D calculations)
- Consolidating worksheets/workbooks
- Automation using Macros
Entry Requirements
Build towards these roles
Data AnalystAdministrative AssistantBusiness Analyst
Build skills in these industries
Information TechnologyBusiness
