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.
Course Outline
Getting Started with Excel
- Exploration of the Excel interface and its primary capabilities.
- Gaining clarity on workbooks, worksheets, and cell referencing structures.
- Navigating the Ribbon, Quick Access Toolbar, and context-sensitive menus.
Inputting and Structuring Data
- Efficient techniques for inputting and modifying data.
- Styling cells, rows, and columns for optimal presentation.
- Applying numeric formats, styles, and thematic elements.
- Fundamental data cleansing and validation techniques.
Leveraging Formulas and Functions
- Grasping formula architecture and calculation hierarchy.
- Distinguishing between relative, absolute, and mixed cell references.
- Mastering core functions such as SUM, AVERAGE, COUNT, and IF.
- Incorporating advanced tools like XLOOKUP, IFS, and dynamic array features.
Managing Data Ranges and Tables
- Establishing and controlling Excel tables.
- Applying sorting, filtering, and advanced conditional filters.
- Utilizing structured references within table environments.
- Enforcing data validation standards and eliminating redundant entries.
Visualizing Information
- Generating diverse chart types, including column, line, and pie graphs.
- Refining chart components to ensure clear communication.
- Employing Sparklines and Conditional Formatting to highlight visual trends.
- Adhering to best practices for compelling data presentation.
Exploring Analytical Utilities
- Utilizing PivotTables and PivotCharts for data summarization.
- Grouping and condensing large datasets.
- Initial exposure to the Analysis ToolPak for statistical analysis.
Teamwork and Efficiency Enhancements
- Managing file storage and distribution through OneDrive and SharePoint.
- Engaging in co-authoring workflows and managing feedback comments.
- Leveraging version tracking and recovery capabilities.
- Utilizing time-saving utilities like Flash Fill and Quick Analysis.
Recap and Future Directions
Requirements
- Fundamental familiarity with computer systems.
- No existing proficiency in Excel is necessary.
Target Learners
- Data analysts.
- Corporate office professionals.
- Individuals aiming to master the core principles of Excel for data management and analytical tasks.
14 Hours
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.
