Certified Master Course on Microsoft Excel for Professionals

Enroll Now
  • Duration: 16 Hours
  • Module: 8 Modules
  • Platform: Online & In-Person
  • Master Microsoft Excel and transform your data management skills with our Certified Master Course. Designed for professionals seeking advanced knowledge, this course will elevate your Excel expertise, enabling you to efficiently analyze data, automate tasks, and make informed decisions with confidence.
  • Hands-on learning with up to Date Projects.
  • Certified Instructors.
  • Course Material and Additional Self Study Resources.
  • Certificate of Completion.
  • Alumni Discount.

Course Content

Module 1: Essential Formula Knowledge

1. Understanding Cell References (Relative, Absolute, Mixed)
2. Basic Math and Logical Functions (SUMIF, COUNTIF)
3. Text Functions (CONCATENATE, LEFT, RIGHT, MID)

Module 3. Advanced Functions and Formulas

1. Advanced Lookup Functions (VLOOKUP, HLOOKUP, XLOOKUP)
2. Match Function
3. Logical and Nested Functions (IF, AND, OR)
4. Understanding Array Formulas
5. Practice Exercise: Develop a customer lookup tool using VLOOKUP and nested functions.

Module 5: Advanced Charting Techniques

1. Combo Charts and Dual-Axis Charts
2. Advanced Chart Elements (Trendlines, Error Bars, Data Labels)
3. Creating Dynamic Charts with Form Controls
4. Practice Exercise: Create a dynamic sales performance dashboard.

Module 7: Power Query for Data Transformation

1. Introduction to Power Query Editor
2. Data Importing from Different Sources
3. Transforming Data with Power Query
4.Practice Exercise: Import and transform data from a CSV file using Power Query.

Module 9: Data Analysis Tools

1. Goal Seek and Solver
2. Advanced Data Validation
3. Consolidating Data from Multiple Sheets
4. Advanced Conditional Formatting
5. Scenario Manager

Module 2: Managing Worksheets and Printing

1. Managing Multiple Worksheets and Workbooks
2. Printing Options (Print Area, Page Layout, Headers/Footers)
3. Protecting Worksheets and Data

Module 4: Data Analysis with PivotTables

1. Creating and Modifying PivotTables
2. Using Slicers and Timelines for Interactive Filtering
3. Grouping Data in PivotTables
4. PivotTable Layout and Design Options
5. Calculated Fields & Dynamic Reporting
6. Practice Exercise: Analyze sales data with a PivotTable

Module 6. Working with Large Datasets

1. Removing Duplicates and Data Validation
2. Using Flash Fill and Text-to-Columns
3. Data Cleaning Techniques (TRIM, CLEAN)
4. Practice Exercise: Clean and prepare a customer data file for analysis.

Module 8. Introduction to Power Pivot and Data Models

1. Understanding Power Pivot and Data Models
2. Building Relationships between Data Tables
3. Introduction to DAX Functions
4. Practice Exercise: Create a simple data model using Power Pivot and basic DAX.

Module 10. Capstone Project and Final Assessment

1. Project: Comprehensive Business Case Analysis
2. Feedback, Q&A, and Certification Assessment
Registration Policy (Check before registration)

WHY CHOOSE ICDB

Experience

We have been in the market since 2016, and we kept accumulating experience in the training business, and providing training for more than 20,000 trainees ever since, in Bangladesh & India.

Premium Facilities

ICDB facilities are well-equipped with strong hardware and software technologies that aid both students and trainers lead very effective smooth training programs.

Customer Support

We provide our clients with the best solutions, customized to their specific needs and goals. Our team is highly qualified to answer whatever questions you have.

Global Accredited

ICDB is an authorized and accredited partner by technology leaders. This means that our training programs are of the highest quality source materials.

Up To Date

We keep tabs on every change in the market and the technology field, so our training programs will always be updated up to the World-class latest standards, and adapted to the global shape-shifting job market.

Certified Instructors

We select the best instructors, who are certified from trustworthy international vendors. They share their professional experience with the Trainees, so they can have a clear hands-on experience.

Our Strategic Clients