Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Duration 14 hours
Course Outline
Getting Started with Excel
- Tour of the Excel interface and its core capabilities
- Comprehending workbooks, sheets, and cell addressing
- Navigating the Ribbon, Quick Access Toolbar, and situational menus
Inputting and Styling Data
- Efficiently adding and modifying information
- Adjusting the appearance of cells, rows, and columns
- Applying numeric formats, design styles, and colour themes
- Refining data quality and applying basic validation rules
Building Formulas and Functions
- Mastering formula syntax and calculation precedence
- Utilising relative, absolute, and hybrid cell references
- Key functions such as SUM, AVERAGE, COUNT, and IF logic
- Implementing contemporary functions like XLOOKUP, IFS, and dynamic arrays
Managing Data Ranges and Tables
- Establishing and maintaining structured Excel tables
- Sorting, filtering, and applying conditional filters
- Applying structured references within tables
- Enforcing data validation and eliminating duplicate entries
Visualising Data
- Generating various charts and graphs (bar, line, pie, etc.)
- Refining chart components for maximum clarity
- Employing Sparklines and Conditional Formatting for immediate visual cues
- Adopting best practices for compelling data presentation
Exploring Data Analysis Utilities
- Utilising PivotTables and PivotCharts for dynamic summarisation
- Aggregating and categorising datasets
- Initial exposure to the Analysis ToolPak for foundational statistical tasks
Teamwork and Efficiency Tools
- Storing and distributing files through OneDrive and SharePoint
- Engaging in real-time co-authoring and managing feedback comments
- Tracing version history and utilising recovery features
- Leveraging time-saving utilities like Flash Fill and Quick Analysis
Recap and Future Directions
Requirements
- Familiarity with standard computer operations
- No previous proficiency in Excel is necessary
Target Learners
- Data analysts
- Corporate office personnel
- Individuals seeking to master Excel essentials for data stewardship and analysis
Testimonials (4)
very clear, very good explanation, wishing more teachers would train like this
Mihaela - Phillip Morris
Course - Excel Basics
The practice
Eliza - DEICHMANN SRL
Course - Excel Basics
some new functions i did knew before, such as power query; fomat cell -alignment-fill
Bella - fu ma si jing mi duan jian (da lian) you xian gong si
Course - Excel Basics
The guy was really helpful and knowledgeable and i really learned a lot in two days.
