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
Fundamentals of the Excel Interface
- Examination of the Excel workspace and core capabilities
- Comprehending workbooks, worksheets, and cell addressing
- Utilizing the Ribbon, Quick Access Toolbar, and contextual menus
Input and Presentation of Data
- Efficient data entry and modification techniques
- Customizing the appearance of cells, rows, and columns
- Applying number formats, styles, and visual themes
- Basic data hygiene and validation procedures
Logical Operations: Formulas and Functions
- Grasping formula syntax and calculation order
- Application of relative, absolute, and mixed cell references
- Key functions including SUM, AVERAGE, COUNT, IF, and additional utilities
- Integration of contemporary features such as XLOOKUP, IFS, and dynamic arrays
Managing Data Structures and Tables
- Construction and administration of Excel tables
- Techniques for sorting, standard filtering, and conditional criteria
- Implementing structured references within tabular data
- Enforcing data validation rules and eliminating duplicate entries
Visual Representation of Data
- Generation of various chart types including column, line, and pie graphs
- Refining chart components to improve clarity
- Utilizing Sparklines and Conditional Formatting to highlight trends
- Strategies for optimal data presentation
Foundations of Analytical Tools
- Creation and interpretation of PivotTables and PivotCharts
- Methods for aggregating and categorizing data
- Overview of the Analysis ToolPak for elementary statistical tasks
Teamwork and Workflow Enhancement
- File management and distribution using OneDrive and SharePoint
- Synchronous editing and comment management in shared workbooks
- Accessing version history and utilizing recovery mechanisms
- Leveraging productivity aids like Flash Fill and Quick Analysis
Recap and Future Directions
Requirements
- Familiarity with basic computer operations
- No previous proficiency in Excel is necessary
Intended Participants
- Data analysts
- Office-based professionals
- Individuals aiming to master Excel's core capabilities 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.