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
- Survey of the Excel environment and principal capabilities
- Comprehending workbooks, worksheets, and cell addressing
- Navigating the Ribbon, Quick Access Toolbar, and context-sensitive menus
Data Input and Styling
- Efficient methods for entering and modifying data
- Applying styles to cells, rows, and columns
- Applying numeric formats, predefined styles, and visual themes
- Basic data cleansing and validation techniques
Formulas and Functions
- Deciphering formula syntax and calculation precedence
- Applying relative, absolute, and hybrid cell references
- Core functions including SUM, AVERAGE, COUNT, IF, and others
- Utilizing contemporary features such as XLOOKUP, IFS, and dynamic arrays
Managing Data Ranges and Tables
- Constructing and maintaining Excel tables
- Implementing sorting, standard filtering, and conditional rules
- Employing structured references within tabular data
- Data integrity checks and eliminating duplicate entries
Data Visualization
- Generating visual representations like column, line, and pie charts
- Refining chart components for improved legibility
- Incorporating Sparklines and Conditional Formatting to highlight insights
- Strategies for clear and impactful data communication
Exploring Data Analysis Utilities
- Leveraging PivotTables and PivotCharts
- Condensing and categorizing data sets
- Familiarity with the Analysis ToolPak for elementary statistical reviews
Collaboration and Efficiency Enhancements
- Distributing and storing documents through OneDrive and SharePoint
- Managing collaborative editing and feedback comments
- Accessing version control and file restoration features
- Utilizing productivity aids such as Flash Fill and Quick Analysis
Conclusion and Future Learning Paths
Requirements
- Familiarity with basic computer operations
- No previous exposure to Excel is necessary
Intended Audience
- Data analysts
- Corporate office professionals
- 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.
