COURSE Instructor
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,
Class-01 Module: Introducing Excel Interface
Class-02 Module: 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
Class-03 Module: 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
Class-04 Module: 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 (Select first sheet & last sheet with pressing “Shift” button)
L-34 Header and Footer
L-35 Sticky Row and Column (Freezing Rows & Columns)
L-36 Excel sheet protection, Editable permission
Class-05 Module: 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
Module: Excel Charts
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
Module: Excel Formulas
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
Class-06 Module: 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
Module: Automated Tables Functions
L-59 Automated Excel Tables
L-60 Working with Automated Excel Tables
L-61 Advance Table Designs
L-62 Convert Tables to Normal
Module: Advanced Excel Formulas
L-63 If & Nested If Formula with AND & OR
L-64 EDATE & EOMONTH
L-65 SUMIF & SUMIFS Formula
L-66 OFFSET & INDIRECT
Class-07 : L-67 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 Formula
Class-08 Module: 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
Class-09 Module: 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
Class-10 Module: Dashboard Preparation in Excel
L-98 Module: Array Formula (Sumproduct) & Use of Wildcard
L-99 Module: Using Macros Efficiently
L-100 Module: Hyperlinks (Linking with different Sheets)
L-101 Module: What-if Analysis in Excel
L-102 Module: Forecasting & Trend Analysis in Excel
L-103 Module: Mail Merge
L-104 Module: Handling Error Message with Formula Auditing
L-105 Module: Personal / Company Loan Database
Closing of the Batch
Class-11 Data Analytics
L-106 Data Analysis Introduction
L-107 Data Preparation for Analysis
L-108 Common Data Problem
L-109 Classification of Analytics
L-110 Univariate Data Analysis
L-111 Data Analysis with visual Chart