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.
In-person study
Face-to-face learning in a physical classroom setting
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.
Skillful use of cell referencing and named ranges
Understand and apply absolute and relative referencing, as well as naming ranges and cells for clarity.
What You're Signing Up For
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
What you need to know first
Some experience with Microsoft Excel is recommended; suitable for self-taught users seeking improvement or a refresher.
What sort of industry will this job lead to
Business Administration
Office Administration
Data Analysis
Information Technology
Future employment opportunities might be
Office Administrator
Data Analyst
Project Coordinator
Finance Assistant
Business Support roles