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
- Familiarization with the Excel interface and primary features
- Grasping the concepts of workbooks, worksheets, and cell references
- Navigating the Ribbon, Quick Access Toolbar, and contextual menus
Data Input and Formatting
- Efficiently entering and modifying data
- Applying formatting to cells, rows, and columns
- Utilizing number formats, styles, and themes
- Basic data cleaning and validation techniques
Formulas and Functions
- Comprehending formula architecture and order of operations
- Applying relative, absolute, and mixed cell references
- Mastering core functions: SUM, AVERAGE, COUNT, IF, and others
- Exploring modern functions: XLOOKUP, IFS, and dynamic arrays
Managing Data Ranges and Tables
- Building and maintaining structured Excel tables
- Sorting, filtering, and applying conditional filters
- Leveraging structured references within tables
- Implementing data validation and eliminating duplicates
Visualizing Data
- Generating various charts and graphs (column, line, pie, etc.)
- Refining chart elements for maximum clarity
- Employing Sparklines and Conditional Formatting for visual insights
- Adhering to best practices for impactful data presentation
Overview of Data Analysis Tools
- Utilizing PivotTables and PivotCharts
- Aggregating and categorizing data
- Introductory use of Analysis ToolPak for fundamental statistics
Collaboration and Efficiency Features
- Storing and distributing files through OneDrive and SharePoint
- Co-authoring workbooks and managing feedback/comments
- Accessing version history and recovery options
- Using productivity aids like Flash Fill, Quick Analysis, and other time-saving tools
Conclusion and Path Forward
Requirements
- General familiarity with computer systems
- No previous experience with Excel is necessary
Target Audience
- Data analysts
- Office professionals
- Individuals seeking to master the basics 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.
