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
Foundations of Excel
- Exploring the Excel interface and its core capabilities.
- Grasping the concepts of workbooks, worksheets, and cell addressing.
- Navigating the Ribbon, Quick Access Toolbar, and context-sensitive menus.
Inputting and Structuring Data
- Efficiently inputting and modifying data.
- Styling cells, rows, and columns for better readability.
- Applying number formats, predefined styles, and themes.
- Performing initial data cleansing and validation checks.
Calculations with Formulas and Functions
- Understanding formula syntax and the hierarchy of operations.
- Applying relative, absolute, and mixed cell references effectively.
- Utilizing core functions such as SUM, AVERAGE, COUNT, IF, and others.
- Incorporating modern functions like XLOOKUP, IFS, and dynamic array capabilities.
Managing Data Ranges and Excel Tables
- Building and maintaining structured Excel tables.
- Sorting, filtering, and applying conditional filters.
- Leveraging structured references within tables.
- Enforcing data validation rules and eliminating duplicates.
Presenting Data Visually
- Generating charts and graphs (column, line, pie, etc.).
- Refining chart elements for maximum clarity.
- Utilizing Sparklines and Conditional Formatting to highlight visual insights.
- Adopting best practices for impactful data presentation.
Overview of Analytical Tools
- Creating and interpreting PivotTables and PivotCharts.
- Summarizing and grouping complex datasets.
- Getting started with the Analysis ToolPak for foundational statistics.
Teamwork and Efficiency Features
- Storing and sharing files via OneDrive and SharePoint.
- Co-authoring workbooks and managing collaborative comments.
- Accessing version history and recovery options.
- Boosting productivity with Flash Fill, Quick Analysis, and other utility tools.
Conclusion and Future Learning Paths
Requirements
- Familiarity with fundamental computer operations
- No previous experience with Excel is necessary
Target Audience
- Data analysts
- Corporate and office professionals
- Individuals seeking to master the basics of Excel 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.
