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 (2 days)
Course Outline
Exploring Excel
- Overview of the Excel interface and primary capabilities
- Grasping the structure of workbooks, sheets, and cell addressing
- Navigating the Ribbon, Quick Access Toolbar, and contextual menus
Inputting and Styling Data
- Efficiently inputting and modifying data
- Applying styles to cells, rows, and columns
- Implementing number formats, design styles, and themes
- Data sanitization and fundamental validation checks
Formulas and Functions
- Deciphering formula syntax and operator precedence
- Applying relative, absolute, and mixed cell references
- Mastering core functions: SUM, AVERAGE, COUNT, IF, and others
- Utilizing modern functions such as XLOOKUP, IFS, and dynamic arrays
Managing Data Ranges and Tables
- Setting up and administering Excel tables
- Sorting, filtering, and applying conditional filters
- Employing structured references within tables
- Validating data and eliminating duplicates
Data Visualization Techniques
- Generating charts and graphs (bar, line, pie, etc.)
- Refining chart components for enhanced readability
- Leveraging Sparklines and Conditional Formatting for visual insights
- Adhering to best practices for compelling data presentation
Intro to Analytical Tools
- Utilizing PivotTables and PivotCharts
- Condensing and categorizing data sets
- Getting started with the Analysis ToolPak for basic statistical tasks
Collaboration and Efficiency Features
- Storing and distributing files through OneDrive and SharePoint
- Co-editing workbooks and handling comments
- Accessing version history and recovery mechanisms
- Harnessing time-savers like Flash Fill, Quick Analysis, and similar tools
Recap and Future Pathways
Requirements
- Fundamental computer literacy
- No previous background in Excel is necessary
Target Audience
- Data analysts
- Administrative and office staff
- Professionals seeking to master Excel basics for data handling 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.
