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
Fundamentals of Excel
- Overview of the Excel workspace and primary capabilities.
- Grasping the concepts of workbooks, worksheets, and cell referencing.
- Navigating the Ribbon, Quick Access Toolbar, and context-sensitive menus.
Inputting and Structuring Data
- Efficient techniques for entering and modifying data.
- Adjusting the appearance of cells, rows, and columns.
- Applying number formats, styles, and thematic designs.
- Basic data cleansing and validation techniques.
Mastering Formulas and Functions
- Deciphering formula architecture and the sequence of operations.
- Implementing relative, absolute, and mixed cell references.
- Core functions including SUM, AVERAGE, COUNT, IF, and others.
- Utilizing contemporary functions such as XLOOKUP, IFS, and dynamic arrays.
Managing Data Ranges and Tables
- Constructing and maintaining Excel tables.
- Executing sorting, filtering, and advanced conditional filtering.
- Applying structured references within table structures.
- Enforcing data validation and eliminating duplicate entries.
Visualizing Information
- Generating various charts and graphs, including column, line, and pie types.
- Refining chart components for enhanced readability.
- Leveraging Sparklines and Conditional Formatting for deeper visual insights.
- Adhering to best practices for impactful data presentation.
Exploring Data Analysis Utilities
- Implementing PivotTables and PivotCharts.
- Summarizing and categorizing data sets.
- Introduction to the Analysis ToolPak for elementary statistical analysis.
Collaboration and Efficiency Enhancements
- Storing and distributing files through OneDrive and SharePoint.
- Collaborative workbook editing and comment management.
- Tracking version history and utilizing recovery features.
- Employing time-saving utilities like Flash Fill and Quick Analysis.
Recap and Forward Path
Requirements
- Fundamental proficiency with computer systems.
- No previous hands-on experience with Excel is necessary.
Target Audience
- Data analysts.
- Corporate office professionals.
- Individuals seeking to master the core principles of Excel for effective data management and analysis.
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.
