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 its primary features
- Conceptual understanding of workbooks, worksheets, and cell referencing
- Navigating the Ribbon, Quick Access Toolbar, and contextual menus
Data Entry and Formatting
- Efficient techniques for entering and modifying data
- Styling cells, rows, and columns
- Application of number formats, styles, and visual themes
- Data cleansing and foundational validation methods
Formulas and Functions
- Grasping formula syntax and the order of operations
- Applying relative, absolute, and mixed references
- Key functions such as SUM, AVERAGE, COUNT, and IF
- Modern functions including XLOOKUP, IFS, and dynamic arrays
Working with Data Ranges and Tables
- Development and administration of Excel tables
- Techniques for sorting, filtering, and conditional filtering
- Implementing structured references within tables
- Data validation protocols and duplicate removal
Data Visualization
- Construction of charts and graphs (e.g., column, line, pie)
- Refining chart elements for enhanced readability
- Utilizing Sparklines and Conditional Formatting for visual insights
- Best practices for presenting data effectively
Introduction to Data Analysis Tools
- Application of PivotTables and PivotCharts
- Methods for summarizing and grouping data
- Introduction to the Analysis ToolPak for foundational statistics
Collaboration and Productivity Features
- Storing and distributing files through OneDrive and SharePoint
- Joint workbook editing and comment management
- Managing version history and recovery options
- Leveraging time-saving tools like Flash Fill and Quick Analysis
Summary and Next Steps
Requirements
- A fundamental understanding of computer operations
- No previous experience with Excel is necessary
Intended Audience
- Data analysts
- Office professionals
- Individuals seeking to master the core principles 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.
