Professional Training

Microsoft Excel Foundation to Pro Level

5
25 ratings
  • Date: 13, 20 & 21 May 2022
  • Time: 13th: 2:30 - 5:30 PM; 20th, 21st: 7:30 - 10:30 PM
  • Total Hours: 9
  • Class Schedule: Fri-Sat
  • Registration deadline: 21 May 2022
  • No. of Classes/Sessions: Total 3 Sessions
  • Venue: Online (Live Class on Zoom)
  • Price: BDT 1000

    Enrol

    What you will learn

  • This training will drill down to the overview of Excel tools, basic functions, and tools that are mostly used to operate Excel effectively which would enhance the effectiveness and efficiency. 

  • The training will also demonstrate 3 projects in the form of Human Resources, Sales & Marketing and Finance Dashboard.

     
     
  • Afterwards, it will drill down to advanced functions, reporting & presentation tools.

  • Who should attend the program?

    These 3 Online Sessions of 9 hours of exclusive training covers up to developed skills for an Advanced Level Excel User and are suited for people who use/plan to use Microsoft Excel applications extensively in the workplace to Analyze data, Presentation, and Reporting.

    Training content

    Day 01: Building Block of Excel

    Part One: Overview of Microsoft Excel [45 Minutes]

    • Introduction to File & Options
    • Explore Workbook Tabs
    • Customize Tab / Ribbon
    • Learn the Essential Operations of Excel Tab Options

     

    Part Two: Referencing & Tools [45 Minutes]

    • Cell Referencing
    • Naming Range & Table to use them in Excel Functions
    • Some Major Workbook Management Techniques
    • Sort, Filter & Advance Filter
    • 15 Amazing Copy-Paste Techniques
    • Understand the Logical Operators & Wildcard

     

    Part Three: Create Logical Formulas [1 Hour]

    • Basic Formula Syntax
    • Anatomy of the IF Statement Nested IF Statement / IFS
    • AND/OR Operators NOT vs “<>”
    • Fixing Errors with IFERROR
    • Common Errors & the IFERROR Statement 
    • Creating Custom Data Validation for avoiding Errors
    • Most Unorthodox use of IF Functions
    • Live Assignment

     

    Part Four: Print & Workbook Management [30 Minutes]

    • Setting up Page Layout
    • Add Header & Footer
    • Document Printing Best Practices
    • Password Protect Range / Worksheet / File
    • Some Useful Shortcuts
    • Create your own Shortcuts
     
    Day 02: Essential Intermediate Level Excel Functions

    Part One: TEXT Function & Number Formats [30 minutes]

     

    Part Two: Excel Statistical Functions for Data Consolidation [1 Hour]

    • COUNTIFS/SUMIFS/AVERAGEIFS 

     

    Part Three: Lookup & References [1.5 Hours]

    • VLOOKUP
    • INDEX + MATCH Function Combining MATCH with VLOOKUP
    • XLOOKUP
    • Mini Project on Lookup
    Day 03: Data Viz & Reporting using Excel

    Part One: Data Visualization [1.5 Hours]

    • Key Data Viz Principle & the 10 Second Rule The Good, Bad & the Ugly
    • Customizing Charts in Excel Bar & Column Chart
    • Line Charts
    • Pie, Donut
    • Heat Maps
    • Combo Charts Sparklines
    • Conditional Formatting

     

    Part Two: PivotTable [1.5 Hours]

    • Creating & Pivoting PivotTables Summarizing PivotTable Data Sorting & Filtering PivotTable Data Formatting PivotTables
    • Applying Conditional Formats to PivotTables Creating & Manipulating PivotCharts 

     

    Instructor's Profile

    Md.Mehanazuddin Rupom

      Md. Mehanazuddin Rupom is a seasoned HR Professional who possesses expertise in handling both local and international HR Projects for around 10+ years of his professional journey. He is also a Microsoft Certified Trainer, Microsoft Office Specialist – Excel Expert, and Certified Microsoft Innovative Educator. Mr. Rupom currently leads the HR & Administration functions of the Bangladesh unit for one of the top multinational international sewing...

    Mentor Details

    Certificate Preview

    Recommended Courses

    Nusrat Huda

    5
    Email Writing
    Total 1 Session
  • 10 Mar 2022
  • Professional Email Writing

    BDT 600

    Enrol

    Md. Rashedul Islam

    5
    MS Excel
    Total 2 classes
  • 18 & 19 Feb 2022
  • মাইক্রোসফট এক্সেলে হাতেখড়ি

    BDT 400

    Enrol

    Asad Zaman

    5
    MS Excel
    Total 4 classes
  • 30 Dec 2021 & 01, 02, 04 Jan 2022
  • MS Excel - আপনার পেশাজীবনে এগিয়ে যাবার হাতিয়ার

    BDT 600

    Enrol