8 IN 1
Microsoft Excel Bundle
39+ Hours
Certificate
Lifetime Access
এই বান্ডেলে পাচ্ছেন সেরা ৮টি কোর্স
Most Common Features of Excel for Professionals
Microsoft Excel – Advanced Level
Business Reporting with PivotTables
Data Visualization Using Charts & Graphs
Advanced Dashboard Reporting Using Excel
Excel Interactive Dashboards with Formulas & ChatGPT
Automate Data Tasks in Excel using Power Query
Microsoft Excel – VBA & Macro
Watch Course Demo
Most Common Features of Excel for Professionals
Microsoft Excel – Advanced Level
Business Reporting with PivotTables
Data Visualization Using Charts & Graphs
Advanced Dashboard Reporting Using Excel
Excel Interactive Dashboards with Formulas & ChatGPT
Automate Data Tasks in Excel using Power Query
Microsoft Excel – VBA & Macro
Curriculum
Most Common Features of Excel for Professionals
Course 1 of 8
- Course Overview
- Start Working with Excel
- Different Cell Formatting Techniques
- Page Setup and Print Professionally
- Insert Data in Cells and Ranges
- Viewing Data on Excel Sheet
- Create and Manage Tables
- Cell Reference (Relative vs Absolute)
- Most Common Functions for Text Handling
- Most Common Functions for Number Handling
- Logical Functions
- Data Sorting
- Data Filtering
- Conditional Formatting
- Lookup and Reference Functions
- PivotTable
- Data Validation
- Secure Your Sheet and File with Password Protection
Microsoft Excel – Advanced Level
Course 2 of 8
- How to Prepare Dynamic Summary Reports in a Tabular Way
- Writing Complex Functions in a Single Formula
- Customizing Dynamic and Static Charts
- Describing Data Using PivotTable, PivotChart, and Slicers
- Use Popular Dynamic Functions: VLOOKUP, INDEX, MATCH, and OFFSET
- Data Reconciliation Techniques in an Easy Way
- Business Modeling and Various Analysis Techniques
- Analyzing and Visualizing Data Using Advanced Conditional Formatting
Data Visualization Using Charts & Graphs
Course 3 of 8
- General Charts – Bar, Column, Pie, Doughnut, Area, and Line Charts
- Advanced Charts – Waterfall, Bubble, Radar, Sunburst, Treemap, and Funnel Charts
- Special Charts – Speedometer Chart and Thermometer Chart
- Visualizing KPIs Using Excel’s Built-in Features as Alternatives to Charts
- Performing Standard Format Changes in Charts
- Customizing Chart Elements Professionally
- Techniques to Choose the Most Suitable Chart for Your Dataset
- Do’s and Don’ts for Creating and Customizing Charts
- Pro Tips for Creating and Customizing Charts
Business Reporting with PivotTables
Course 4 of 8
- Identify how to format data for use in a PivotTable.
- Discover how to create a new PivotTable.
- Define how to connect to data sources.
- Evaluate and consolidate data from multiple data sources.
- Identify how to create calculated fields.
- Summarize field data.
- Review PivotTable sorting.
- Review PivotTable filters.
- Discover how to work with Excel slicers.
- Recall how to format PivotTables with styles and formats.
- Assess how to build PivotCharts.
- Assess how to run macros.
- Evaluate how to create a PivotTable using the data model.
- Prepare business dashboards and reporting.
Advanced Dashboard Reporting Using Excel
Course 5 of 8
- Functions for Data Summarization & Aggregation from big Data
- Charts & Graphs – Customization & setting conditions
- Dashboard Project-1: Using PivotTable, PivotChart, Slicers and Timeline
- Dashboard Project-2: Using PowerPivot, the Excel’s Built-in Self Service BI Tool
- Dashboard Project-3: LIVE Data linking from multiple files Using Power Query
- Dashboard Project-4: Using Form controls, functions, Various Tools and Charts
- Questions & Answers in the Whole Session
Excel Interactive Dashboards with Formulas & ChatGPT
Course 6 of 8
- Introduce the advanced option of Excel.
- Custom and attractive dynamic Chart.
- How to design a dashboard & dashboard theme.
- Create a Dashboard with Pivot.
- Create Professional Interactive & dynamic Dashboards with advanced formulas, Buttons, and Drop-Down Menus from scratch.
- How to Create a dashboard by using ChatGPT.
Automate Data Tasks in Excel using Power Query
Course 7 of 8
- Introduction – Power Query
- Getting Data into Power Query
- Power Query Editor
- Text Column
- Number Column
- Date and Time
- Combine
- Data Reshaping
- Add Column
- Grouping
- Power Query: Others
Microsoft Excel – VBA & Macro
Course 8 of 8
- Introduction
- Start Working with VBA and Macros
- Visual Basic Editor (VBE) – Change the VBA Script
- Various Visual Basic Concepts and Environments
- Subroutine and Execution
- Event and Execution
- MessageBox and InputBox
- Using UserForm in Excel
- Managing Various Form Controls
- Errors, Debugging and Error Handling
- Complete Project to Create a Data Entry Form
- User Defined Function (UDF)
- Creating Add-ins
Instructor
Nazmul Muneer
Accounts & Finance, Microsoft Certified Traine
Finance and ERP professional with 15+ years of experience, currently serving in a key role at Beximco Pharmaceuticals Ltd. My expertise lies in functional business process mapping, ERP (Oracle EBS) support, and driving system-based solutions across finance and operations.
View Profile
M. Hasan Haider
FCCA, FCMI
PPP Expert, Financial Specialist, Transaction Advisory, Venture Capitalist
View Profile
Md. Abdullah Al Mahmud
Founder & CEO @ Thriving Skills
Founder & CEO @ Thriving Skills | Policy Development Consultant | Expert in Skills & Education Policy, Digital Transformation & AI Strategy
View Profile
Md. Sajib Hossain
Stock Market Analyst
Md. Sajib Hossain, CFA, is an Assistant Professor in the Department of Finance at the University of Dhaka and a Ph.D. student at Washington University in St. Louis.
View Profile
Hear what learners have to say about
Our Training
The trainer is rally expert in excel. The content is well organized that very helpful to learn step by step. I especially love the working files those shared with the videos. The excel files are exactly same files those used in the presentation. It will really help me to practice further.
Nobel Haider
Thanks for awesome training both Thriving Skill and Instructor Humaira Sharim Medam. Wish you all the best.
Muhammad Imran Sabuj
Excellent Presentation. It will help many corporate professional along with new comer into corporate world. Simply great.
Kazi Md Siddikul Azam
Just Remarkable ! Professionals must go through it.
MAHMUDA AKTER
Very Effective and I think i will do better to follow your guideline.
khandker Moniruzzaman
Special thanks to Moinuddin sir for the excellent content and presentation and thanks to Thriving Skills for this platform!
MD. MUSFIQUR RAHMAN BHUIYAN
Thank you for sharing your vast knowledge of the sales profession.
Soumitro Sarkar
GET CERTIFICATE
Earn a Course Completion Certificate to validate your skills and boost your career profile.
