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
- Surveying the Excel interface and core capabilities.
- Grasping the concepts of workbooks, worksheets, and cell addressing.
- Navigating the Ribbon, Quick Access Toolbar, and context-sensitive menus.
Inputting and Structuring Data
- Efficiently entering and modifying information.
- Adjusting the appearance of cells, rows, and columns.
- Applying number formats, styles, and thematic elements.
- Performing initial data cleansing and validation checks.
Formulas and Functions
- Analyzing formula syntax and operational precedence.
- Utilizing relative, absolute, and mixed cell references.
- Mastering key functions such as SUM, AVERAGE, COUNT, and IF.
- Leveraging advanced tools like XLOOKUP, IFS, and dynamic arrays.
Managing Data Ranges and Tables
- Establishing and administering Excel tables.
- Implementing sorting, standard filtering, and conditional filters.
- Employing structured references within table contexts.
- Validating data integrity and eliminating duplicate entries.
Visualizing Information
- Generating various chart types, including column, line, and pie graphs.
- Refining chart components for maximum readability.
- Applying Sparklines and Conditional Formatting to highlight trends.
- Adhering to best practices for clear data presentation.
Introduction to Analytical Tools
- Utilizing PivotTables and PivotCharts for summary reporting.
- Aggregating and categorizing datasets.
- Exploring the Analysis ToolPak for introductory statistical tasks.
Collaboration and Efficiency Features
- Storing and distributing documents through OneDrive and SharePoint.
- Engaging in simultaneous editing and comment management.
- Tracking version control and utilizing recovery mechanisms.
- Saving time with Flash Fill, Quick Analysis, and auxiliary utilities.
Recap and Future Directions
Requirements
- Familiarity with basic computer operations.
- No previous experience with Excel is necessary.
Target Audience
- Data analysts.
- Corporate professionals.
- Individuals seeking to master Excel fundamentals for data management and analysis.
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.
