AI-Powered Microsoft Excel and Data Analytics(Basics to Advanced)
Industry Expert Faculties
Our trainers are highly experienced & Microsoft certified Trainer.
Md. Sazadur Rahman Shajib
● Site Human Resources (HR) Head
● Healthcare Pharmaceuticals Limited
● Part-Time Lecturer of Business Administration
● Daffodil International University (DIU)
● BBA (Management Studies) & MBA (HRM) from University of Dhaka
● MS Excel Trainer & Mentor
●Member of Academy to Innovative HR (AIHR), Netherlands
● Member of Institute of Strategic Management & Finance (ISMF), USA
● CHRG, CHRC, CHRAP, CHRTS, CPAS, CHRBP, MCT (MOS-01), CRSS,
- Course Duration: 1.5 Months
- Class Duration: 2 Hours
- Total Session: 12
- Ongoing Batch: Batch 06
- Class Starts: 16 August, 25
- Classes on: Sunday & Thrusday
- Classes Time: 09:00 PM - 11:00 PM
Course Content
Module 01: Introduction
- 1. Introducing Excel Interface
Module 02: Getting Familiar with the Excel Interface
- L-1: Shortcuts
- L-2: Format Painter, Flash Fill
- L-3: Wrap, Shrink, Merge
- L-4: Advance Numbering, Percentage, Decimal
- L-5: Advanced Printing, Page Setup, Fit to 1 Page
- L-6: Basic Cell Reference
- L-7: Row, Column & Cells Handling
- L-8 Ribbon, Toolbar, Backstage View
- L-9: Fill Handle, Series
- L-10: Advance Pasting
Module 03: Excel Text Options
- L-11: Text Options
- L-12: Borders Options
- L-13: Text Alignment Tools-Cell Alignment-Upper, Mid, Lower
- L-14: Advance Merge / Unmerge
- L-15: Splitting Cell Text
- L-16: Sentence Justify
- L-17: Converts a Text String to Number
- L-18: H2O; (a2 + b2) righting writing
- L-19: UPPER, lower, Proper
- L-20: LEN, LEFT, RIGHT & MID
- L-21: Text Orientation
- L-22: Spelling Checking
- L-23: Translate
- L-24 Joining Cell Text
Module 04: Basic Excel Functions
- L-25: TRANSPOSE Function
- L-26: FIND & SEARCH Function
- L-27: REPLACE & SUBSTITUTE Function
- L-28: Comments in cell
- L-29: Duplicate Values
- L-30: Remove Duplicates
- L-31: Cell Rules
- L-32: Data Validation
- L-33: Data Consolidation & 3D Formula
- L-34: Header and Footer
- L-35: Sticky Row and Column (Freezing Rows & Columns)
- L-36: Excel sheet protection, Editable permission
Module 05: Sorting & Filtering
- L-37: Single Click-Sorting
- L-38: Advance Sorting with multiple Conditions
- L-39: Sorting by Color
- L-40: Filtering by Selection, Color, Letters
- L-41: Other ways to Filter for Advanced filtering queries
- L-42: Creating and Formatting a Chart
- L-43: Chart Formatting Techniques
- L-44: Adding or Removing Chart Data
- L-45: Sparkline
- L-46: Pie, Bar, Line, Rader, Stock, Area, Surface etc Charts' Tricks
- L-47: Combo Chart
- L-48: Formulas in Context: Addition, Substraction
- L-49: Formulas in Context: Multiply, Divide, Percentage
- L-50: SUM and AUTOSUM
- L-51: AVERAGE, MIN and MAX
- L-52: SUBTOTAL
Module 06: Excel Illustrations
- L-53: Creating Smart Art
- L-54: Smart Art Formats
- L-55: Basic to Advance Shapes
- L-56: Screenshot Functions
- L-57: Online and offline picture inserting tools
- L-58: Advance Word Art Functions
- L-59: Automated Excel Tables
- L-60: Working with Automated Excel Tables
- L-61: Advance Table Designs
- L-62: Convert Tables to Normal
- L-63: If & Nested If Formula with AND & OR
- L-64: EDATE & EOMONTH
- L-65: SUMIF & SUMIFS Formula
- L-66: OFFSET & INDIRECT
Module 07: CHOOSE, WEEKDAY & NETWORKDAYS
- L-68: Date Formula (Datedif), Text Function
- L-69: Common Financial Functions (PMT, NPER, PV, FV)
- L-70: ROUND & Advance Rounding Formulas (Ceiling & Floor)
- L-71: ROUNDUP & ROUNDDOWN Formula
- L-72: AVERAGE, AVERAGEA Formula
- L-73: AVERAGEIF, AVERAGEIFS Formula
- L-74: COUNT, COUNTA Formula
- L-75: Advance COUNTIF, COUNTIFS Formula
- L-76: MAX, MAXIFS Formula
- L-77: MIN, MINIFS Formula
- L-78: MEDIAN, MOD, Standard Deviation, Correlation & Regression
Module 08: LOOKUP Function
- L-79: VLOOKUP function
- L-80: Dynamic VLOOKUP
- L-81: VLOOKUP without remembering Formula
- L-82: Exact Match, Nearly Match Data Lookup
- L-83: INDEX-MATCH
- L-84: HLOOKUP
Module 09: PivotTables
- L-85: Creating PivotTables
- L-86: Changing PivotTables
- L-87: Common Errors with PivotTables
- L-88: Formatting PivotTables
- L-89: Drill Down at PivotTables
- L-90: Pivot Calculations
- L-91 Summarizing Dates
- L-92: Sorting at PivotTables
- L-93: Filtering Row Fields
- L-94: Filtering a Pivot Table with Slicers
- L-95: Slicers on Two Pivot Tables
- L-96: Sample Reports by PivotTables
- L-97: Varieties of Reports in a Second
Module 10: Dashboard Preparation in Excel
- L-99: Module: Array Formula (Sumproduct) & Use of Wildcard
- L-100: Module: Using Macros Efficiently
- L-101: Module: Hyperlinks (Linking with different Sheets)
- L-102: Module: What-if Analysis in Excel
- L-103: Module: Forecasting & Trend Analysis in Excel
- L-104: Module: Mail Merge
- L-105: Module: Handling Error Message with Formula Auditing
- L-106: Module: Personal / Company Loan Database
Module 11: AI for Excel
- L-107: Meet Your New Excel Assistant: AI
- L-108: Excel With ChatGPT
- L-109: Advanced Excel With ChatGPT
- L-110: Analyzing Data With AI
Module 12: AI Functions Part 1: Excel Labs
- L-112: AI Functions Part 2: ChatGPT For Excel
- L-113: Introducing…..Microsoft Copilot
Registration Now
Milestones and
Achievements
Highlighting our impactful accomplishments and successful milestones with meaningful metrics.
Total Learners
0
+
Certified Professionals
0
+