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
Introduction to Excel
- Overview of the Excel interface and key features.
- Understanding workbooks, worksheets, and cell references.
- Navigating the Ribbon, Quick Access Toolbar, and contextual menus.
Data Entry and Formatting
- Entering and editing data efficiently.
- Formatting cells, rows, and columns.
- Applying number formats, styles, and themes.
- Data cleaning and basic validation.
Formulas and Functions
- Understanding formula structure and the order of operations.
- Using relative, absolute, and mixed references.
- Essential functions: SUM, AVERAGE, COUNT, IF, and others.
- Leveraging modern functions such as XLOOKUP, IFS, and dynamic arrays.
Working with Data Ranges and Tables
- Creating and managing Excel tables.
- Sorting, filtering, and applying conditional filtering.
- Utilizing structured references in tables.
- Data validation and removing duplicates.
Data Visualization
- Creating charts and graphs (column, line, pie, etc.).
- Formatting chart elements for improved clarity.
- Using Sparklines and Conditional Formatting for visual insights.
- Best practices for effective data presentation.
Introduction to Data Analysis Tools
- Using PivotTables and PivotCharts.
- Summarizing and grouping data.
- Introduction to the Analysis ToolPak for basic statistics.
Collaboration and Productivity Features
- Saving and sharing files via OneDrive and SharePoint.
- Co-authoring workbooks and managing comments.
- Version history and recovery options.
- Using Flash Fill, Quick Analysis, and other time-saving tools.
Summary and Next Steps
Requirements
- A fundamental understanding of computers.
- No prior experience with Excel is required.
Audience
- Data analysts.
- Office professionals.
- Anyone keen on mastering the basics of Excel for 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.
