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
Introduction to Excel
- Overview of the Excel interface and primary features
- Comprehending workbooks, worksheets, and cell referencing
- Navigating the Ribbon, Quick Access Toolbar, and contextual menus
Data Input and Formatting
- Efficiently entering and modifying data
- Applying formats to cells, rows, and columns
- Utilizing number formats, styles, and visual themes
- Data cleansing and implementing basic validation rules
Formulas and Functions
- Grasping formula syntax and calculation order
- Applying relative, absolute, and mixed cell references
- Mastering essential functions such as SUM, AVERAGE, COUNT, and IF
- Exploring modern functions including XLOOKUP, IFS, and dynamic arrays
Managing Data Ranges and Tables
- Building and maintaining structured Excel tables
- Sorting, filtering, and applying conditional filters
- Leveraging structured references within tables
- Enforcing data validation and eliminating duplicates
Data Visualization
- Generating various charts and graphs (e.g., column, line, pie)
- Refining chart elements for maximum clarity
- Employing Sparklines and Conditional Formatting for visual insights
- Adhering to best practices for effective data presentation
Foundations of Data Analysis Tools
- Utilizing PivotTables and PivotCharts
- Summarizing and grouping datasets
- Introduction to the Analysis ToolPak for fundamental statistics
Collaboration and Productivity Enhancements
- Storing and distributing files through OneDrive and SharePoint
- Co-authoring workbooks and managing comments
- Accessing version history and recovery options
- Leveraging time-saving features like Flash Fill and Quick Analysis
Conclusion and Future Learning Pathways
Requirements
- Familiarity with basic computer operations
- No previous experience with Excel is necessary
Target Audience
- Data analysts
- Office professionals
- Individuals seeking to master Excel fundamentals for data management 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.
