Microsoft Excel
Computer Science
A course by
WITT
This hands-on course is designed to improve your efficiency and confidence with Microsoft Excel, covering both fundamental and advanced spreadsheet features for data analysis, automation, and workflow optimization.
$ENQUIRE
Interested in this course? Enquire now for Domestic & International pricing
Core skills this course teaches
Efficient navigation and management of workbooks/worksheets
Participants will be able to navigate complex Excel files more efficiently and use advanced selection and navigation features.
Understanding and applying mathematical operations
Learners will know the correct order of mathematical operations in Excel and use array formulas.
About This Course
The Microsoft Excel course is designed for frequent Excel users who want to hone their skills and become more proficient in managing data, automating tasks, and optimizing spreadsheets. The course covers core and advanced features such as functions, Pivot Tables, macros, conditional formatting, lookup tables, and formula auditing. Participants will learn practical tips and tricks to improve productivity, understand spreadsheet security, and confidently handle complex data manipulation requirements. Attendance at both sessions is required to receive certification.
Course Content
- Navigation to speed up workflow
- Selection techniques
- Mathematical rules and logic
- Conditional functions for data analysis
- Using text functions (splitting and combining text)
- Named ranges
- Hiding columns, rows, and formulas
- Workbook and worksheet protection
- Lookup tables/lists for automation
- Automating entries
- Formula auditing
- Using multiple worksheets and 3D calculations
- Conditional formatting and data validation
- Sorting and filtering data
- Subtotalling worksheets
- Manipulating data with Pivot Tables, Pivot Charts, Slicers
- Recording and using macros
- Spreadsheet design strategies for efficiency and stability
Entry Requirements
Build towards these roles
Office AdministratorData AnalystProject CoordinatorFinance AssistantBusiness Support roles
Build skills in these industries
Business AdministrationOffice AdministrationData Analysis
