Home / eLearning / Mastering Microsoft Excel - From Scratch to End

Professional Training

Mastering Microsoft Excel - From Scratch to End

5
25 ratings
  • Date: 20, 21, 27, 28 Feb & 05, 06, 12, 13, 19 Mar 2024
  • Time: 08:00 PM - 10:00 PM
  • Total Hours: 18
  • Class Schedule: Tue-Wed
  • Registration Deadline: 20 Feb 2024
  • No. of Classes/Sessions: Total 9 Sessions
  • Venue: Online (Live Class on Zoom)

    • Price: BDT 1999

    Enrol

    What you will learn

  • A complete guide for beginners to advanced applications of Microsoft Excel

  • To work with large data sets and make dynamic DASHBOARD

  • Create an effective spreadsheet

  • Master the use of Microsoft Excel\'s most popular and highly sought-after functions (SUM, VLOOKUP, IF, AVERAGE, INDEX/MATCH, and many more)

  • To use different tools and techniques with real-life examples

  • Manage large sets of data

    • Who should attend the program?

    The course is applicable for graduate students, academics, and working professionals of government and private sector in the field of Sales and Marketing, HR, Finance, Business Analytics, and Operations - who regularly use data to prepare reports and presentations, and want to upskill themselves in their profession.

    Training content

    Detailed Content of the Training

    Microsoft Excel- Excel for Beginners

    • Section E101: Microsoft Excel Fundamentals.
    • Section E102: Entering and Editing Text and Formulas.
    • Section E103: Working with Basic Excel Functions.
    • Section E104: Modifying an Excel Worksheet.
    • Section E105: Formatting Data in an Excel Worksheet.
    • Section E106: Inserting Images and Shapes into an Excel Worksheet.
    • Section E107: Creating Basic Charts in Excel.
    • Section E108: Printing an Excel Worksheet.

     

    Microsoft Excel: Intermediate Level

    • Section E201: Working with an Excel List.
    • Section E202: Working with Large Sets of Excel Data.
    • Section E203: Excel Data Validation.
    • Section E204: Excel PivotTables and Pivot Charts.
    • Section E205: Making a Dashboard using Pivot Charts.
    • Section E206: Protecting Excel Worksheets and Workbooks.

     

    Microsoft Excel for Professionals- Advanced Level

    • Section E301: Working with Excel\'s Conditional Functions.
    • Section E302: Working with Excel\'s Lookup Functions.
    • Section E303: Working with Excel\'s Text Based Functions.
    • Section E304: Excel Date Functions.
    • Section E305: Auditing an Excel Worksheet.
    • Section E306: Automating Repetitive Tasks in Excel with Macros.

     

    Microsoft Excel -Excel Hacks (For Advanced Only)

    • Section E401: Microsoft Excel Tips and Tricks.
    • Section E402: Real life queries with solutions.

    Instructor's Profile

    Mir Masud Uz Zaman

    Mir Masud Uz Zaman is a professional MS Excel...

    Mentor Details

    Certificate Preview

    Student Feedback

    Recommended Courses

    M B Subhana

    5
    Web Design
    Total 33 Sessions
  • 24, 27, 28 Jan, 03, 04, 10, 11, 17, 18, 24, 25 Feb, 02, 03, 09, 10, 16, 17, 23, 24, 30, 31 Mar, 06, 07, 13, 14, 20, 21, 27, 28 Apr, 04, 05, 11 May 2024

    • Frontend Web Development

    BDT 5000

    Enrol

    Mir Masud Uz Zaman

    5
    PPT
    Total 5 Sessions
  • 24, 29, 31 Jan & 05, 07 Feb 2024

    • Microsoft PowerPoint - Beginners to Pro

    BDT 999

    Enrol

    Mir Masud Uz Zaman

    5
    Excel & PPT
    Total 14 Sessions
  • 27, 29 May, 03, 05, 10, 12, 17, 19, 24, 26 Jun & 03, 08, 10, 15 July 2023

    • Mastering Microsoft Excel and Microsoft PowerPoint

    BDT 3000

    Enrol