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
Getting Started with Excel
- Tour of the Excel interface and essential capabilities
- Grasping workbooks, worksheets, and cell addressing
- Utilizing the Ribbon, Quick Access Toolbar, and contextual menus
Inputting and Structuring Data
- Efficiently entering and modifying data
- Styling cells, rows, and columns
- Applying number formats, styles, and themes
- Data sanitation and basic verification
Formulas and Functions
- Comprehending formula syntax and calculation order
- Employing relative, absolute, and mixed cell references
- Key functions: SUM, AVERAGE, COUNT, IF, and others
- Leveraging contemporary functions: XLOOKUP, IFS, and dynamic arrays
Managing Data Ranges and Tables
- Building and overseeing Excel tables
- Sorting, filtering, and applying conditional filters
- Utilizing structured references within tables
- Data validation and elimination of duplicate entries
Data Presentation and Visualization
- Generating charts and graphs (column, line, pie, etc.)
- Styling chart components for improved clarity
- Using Sparklines and Conditional Formatting to reveal visual insights
- Optimal strategies for presenting data effectively
Overview of Data Analysis Utilities
- Deploying PivotTables and PivotCharts
- Consolidating and categorizing data
- Introduction to Analysis ToolPak for fundamental statistics
Collaboration and Efficiency Tools
- Storing and distributing files through OneDrive and SharePoint
- Joint editing of workbooks and handling annotations
- Managing version history and recovery mechanisms
- Utilizing Flash Fill, Quick Analysis, and other efficiency-boosting features
Recap and Future Directions
Requirements
- Foundational knowledge of computer operations
- No previous proficiency in Excel is necessary
Target Audience
- Data analysts
- Corporate professionals
- Individuals seeking to master Excel fundamentals for data governance and examination
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.
