![excel-green-logo](/documents/6636301/0/excel.png/6e00f783-90a4-9cb6-06d4-56fdab171617?t=1691677564042)
- Payment Options:
Subscription R2,500 pmSelf-paced R6,500
- Inlcudes:
- Exam Fee: No
- Labs: Yes
- Test Prep: Yes
- Mentor Support: Yes
Subscription Plan: This plan provides not only access to our extensive course catalog but also dedicated mentorship for content mastery and effective career planning. Please note, course completion is required before starting a new one, ensuring a solid grasp of material. The plan requires an initial R2,500 deposit, reflecting our commitment to quality education. You may cancel anytime with a month's notice. Start your learning journey today!
Self-paced: Unlock your learning potential with our one-time payment option. This plan offers you access to comprehensive training manuals and supplemental materials for a period of up to 12 months, empowering you to learn at your own pace. While this option does not include mentor support, our dedicated career advisors remain readily available to guide you. Make a single investment to revolutionize your learning experience and open doors to new possibilities.
Microsoft Excel 2021 Intermediate
Acquire the necessary expertise for Excel 2021 through the Microsoft Excel 2021 Intermediate course and practical exercises. This program expands on the fundamental concepts covered in the Microsoft® Office Excel® 2021: Part 1 course, empowering you to craft sophisticated workbooks and worksheets, thus enhancing your grasp of organizational intelligence. Upon completion, you'll have the ability to proficiently analyze extensive datasets, extract valuable insights, and effectively communicate this information to key decision-makers.
Lessons 1: About This Course
- Course Description
Lessons 2: Working with Functions
- Topic A: Work with Ranges
- Topic B: Use Specialized Functions
- Topic C: Work with Logical Functions
- Topic D: Work with Date and Time Functions
- Topic E: Work with Text Functions
Lessons 3: Working with Lists
- Topic A: Sort Data
- Topic B: Filter Data
- Topic C: Query Data with Database Functions
- Topic D: Outline and Subtotal Data
Lessons 4: Analyzing Data
- Topic A: Create and Modify Tables
- Topic B: Apply Intermediate Conditional Formatting
- Topic C: Apply Advanced Conditional Formatting
Lessons 5: Visualizing Data with Charts
- Topic A: Create Charts
- Topic B: Modify and Format Charts
- Topic C: Use Advanced Chart Features
Lessons 6: Using PivotTables and PivotCharts
- Topic A: Create a PivotTable
- Topic B: Analyze PivotTable Data
- Topic C: Present Data with PivotCharts
- Topic D: Filter Data by Using Timelines and Slicers
- Appendix A: Microsoft® Excel® 2021 Common Keyboard Shortcuts
Appendix B: Financial Functions
Appendix C: Working with Graphical Objects
- Topic A: Insert Graphical Objects
- Topic B: Modify Graphical Objects
- Topic C: Work with SmartArt
Hands-on LAB Activities
Working with Functions
- Creating Named Ranges
- Editing Range Names
- Using an Existing Range in a Function
- Using the Formula AutoComplete Method to Enter Range Names
- Using the TODAY Function
- Calculating the Years of Service for Each Employee
- Adding the Arguments for the IF Portion of the Nested Function
- Calculating the 1 Percent Goal Bonus for Employees
- Using the NETWORKDAYS Function
- Extracting the Building Code from the Combined Field
- Extracting the Floor Code from the Combined Field
- Concatenating the Names in a Single Field
Working with Lists
- Filtering the Data for all Employees
- Creating a Custom Filter
- Using Database Functions
Analyzing Data
- Converting the Data into a Table
- Applying a Quick Style to a Table
- Adding New Entries to a Table
Visualizing Data with Charts
- Creating a Clustered Column Chart
- Changing the Labels of the Line Chart
- Changing the Chart Type
- Creating the Combo Chart
- Adding the Trendline
- Saving a Chart as a Template
Using PivotTables and PivotCharts
- Adding Fields to the PivotTable
- Building the PivotTable Report
- Sorting the Values
- Modifying the Formatting of the PivotTable Report
- Modifying the PivotTable Report
- Inserting a Timeline
Who Should Pursue This Certification?
The Microsoft Excel 2021 Intermediate Certification is relevant for a diverse range of individuals seeking to elevate their Excel proficiency beyond basic usage. This certification is beneficial for business professionals in various fields, data analysts, accountants, project managers, students, administrative personnel, educators, small business owners, and those looking to transition into roles that require Excel expertise. Additionally, it serves as a structured pathway for anyone wishing to enhance their Excel skills, providing formal recognition of their proficiency. However, it's worth noting that continuous practice and application of Excel in practical scenarios are equally important for mastery, alongside formal certification.
🔥 Benefits and Beyond:
Beyond certification seekers, Excel 2021 Intermediate proficiency benefits business leaders, educators, job seekers, and entrepreneurs. It enables better decision-making, enhances teaching capabilities, boosts job marketability, and aids in effective financial management for small businesses.
Please contact us for any queries via phone or our contact form. We will be happy to answer your questions.
Ferndale,
2194 South Africa
Tel: +2711-781 8014 (Johannesburg)
+2721-020-0111 (Cape Town)
ZA
contactform.caption