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
- An overview of the Excel workspace and its primary capabilities
- Gaining insight into workbooks, individual sheets, and cell referencing systems
- Utilizing the Ribbon, Quick Access Toolbar, and context-sensitive menus
Data Input and Styling
- Efficient methods for entering and modifying data
- Customizing the appearance of cells, rows, and columns
- Applying numeric formats, professional styles, and theme designs
- Basic data sanitization and validation techniques
Formulas and Functional Logic
- Comprehending formula architecture and the sequence of operations
- Working with relative, absolute, and hybrid cell references
- Core functions including SUM, AVERAGE, COUNT, IF, and other essential tools
- Modern additions such as XLOOKUP, IFS, and dynamic array capabilities
Managing Data Ranges and Tables
- Establishing and maintaining structured Excel tables
- Organizing data through sorting, basic filtering, and advanced conditional filters
- Applying structured references within table contexts
- Validating entries and eliminating duplicate records
Visualizing Data Trends
- Constructing various chart types including column, line, and pie graphs
- Refining chart components to maximize clarity
- Leveraging Sparklines and Conditional Formatting to uncover visual patterns
- Adhering to best practices for impactful data presentation
Exploring Analysis Utilities
- Utilizing PivotTables and PivotCharts for dynamic summaries
- Consolidating and categorizing data for better insight
- Introductory use of the Analysis ToolPak for fundamental statistical operations
Collaboration and Efficiency Enhancements
- Storing and distributing documents via OneDrive and SharePoint
- Simultaneous editing of workbooks and managing feedback comments
- Tracking version control and utilizing recovery features
- Harnessing time-saving utilities like Flash Fill and Quick Analysis
Wrap-up and Future Learning Paths
Requirements
- General familiarity with computer systems
- No previous exposure to Excel is necessary
Target Audience
- Data analysts
- Corporate office personnel
- Individuals seeking to master the core principles of Excel for data stewardship 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.
