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
Getting Started with Excel
- Review of the Excel interface and primary features
- Comprehending workbooks, worksheets, and cell addressing
- Navigating the Ribbon, Quick Access Toolbar, and context-specific menus
Data Input and Styling
- Efficient methods for entering and modifying data
- Styling cells, rows, and columns
- Applying number formats, styles, and themes
- Data refinement and introductory validation techniques
Formulas and Functionality
- Decoding formula architecture and order of operations
- Applying relative, absolute, and mixed cell references
- Key functions: SUM, AVERAGE, COUNT, IF, and others
- Utilizing contemporary functions: XLOOKUP, IFS, and dynamic arrays
Managing Data Ranges and Tables
- Building and administering Excel tables
- Sorting, filtering, and applying conditional filters
- Incorporating structured references within tables
- Data validation and duplicate removal
Data Representation
- Generating charts and graphs (bar, line, pie, etc.)
- Refining chart components for enhanced clarity
- Employing Sparklines and Conditional Formatting for visual analysis
- Guidelines for effective data presentation
Overview of Data Analysis Utilities
- Implementing PivotTables and PivotCharts
- Aggregating and categorizing data
- Exploring the Analysis ToolPak for fundamental statistical tasks
Collaboration and Efficiency Features
- Storing and distributing files through OneDrive and SharePoint
- Co-authoring workbooks and overseeing comments
- Accessing version history and recovery utilities
- Leveraging Flash Fill, Quick Analysis, and other productivity tools
Recap and Future Steps
Requirements
- Familiarity with basic computer operations
- No previous experience with Excel is necessary
Target Audience
- Data analysts
- Office professionals
- Individuals seeking to acquire fundamental Excel skills 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.
