143$

14$




Review
    (3)

    5/5.0

Overview

  • Quizzes Yes
  • Skill level Beginner
  • Language Bangla
  • Duration 03:14:14 H
  • Total Enrollments: 443

Course Description

Microsoft Excel is a spreadsheet program included in the Microsoft Office suite of applications. Spreadsheets will provide you with the values arranged in rows and columns that can be changed mathematically using both basic and complex arithmetic operations. In addition to the standard spreadsheet features, Excel offers programming support via Microsoft's Visual Basic for Applications (VBA), the ability to access data from external sources via Microsoft’s Dynamic Data Exchange (DDE). Microsoft Excel is an Electronic Spreadsheet Computer Program. Microsoft Excel was first released for Macintosh systems in the year 1985, followed by the first Windows version in 1987. Check the list to know about the Excel releases for Windows: Excel 2.0 (1987) Excel 3.0 (1990) Excel 4.0 (1992) - Included in Microsoft Office 3.0 Excel 5.0 (1993) - Included in Microsoft Office 4.0 Excel 95 (1995) - Included in Microsoft Office 95 Excel 97 (1997) - Included in Microsoft Office 97 Excel 2000 (2000) - Included in Microsoft Office 2000 Excel 2002 (2002) - Included in Microsoft Office XP Excel 2003 (2003) - Included in Microsoft Office 2003 Excel 2007 (2007) - Included in Microsoft Office 2007 Excel 2010 (2010) - Included in Microsoft Office 2010 Excel 2013 (2013) - Included in Microsoft Office 2013 Excel 2016 (2016) - Included in Microsoft Office 2016 Excel 2019 (2019) - Included in Microsoft Office 2019

Certification

Yes

Learning Outcomes

    ["Master Microsoft Excel from Beginner to Advanced","Learn the most common Excel functions used in the Office","Maintain large sets of Excel data in a list or table","Wow your boss by unlocking dynamic formulas with IF, VLOOKUP, INDEX, MATCH functions and many more","Build a solid understanding on the Basics of Microsoft Excel","Harness the full power of Microsoft Excel by automating your day to day tasks through Macros and VBA","Create dynamic reports by mastering one of the most popular tools, PivotTables","Access to a Professional Trainer with 10+ years of Excel Training"]

Curriculum

Introduction

    Trainer Introduction

Module one

    The Basic
    Cell Reference
    Basic Formating
    Custom Number Format
    Conditional Formating
    Duplicate
    Zoom Split Freeze
    Spelling
    Print
    Project file

Module Two

    Basic Functions
    Paste Special
    Filtering and Sorting
    Logical Function
    Concatenate
    Left Mid Right and text to column
    Count Sum
    Change Case
    Data Clean up and Trim
    Project file module 2

Module Three

    VLook Up & HLook Up
    Data Validation
    Pivot table
    Organogram
    Basic Chart
    Pie Chart and Combination Chart
    Info Graph
    Project file module 3

Module Four

    Protection
    Aggregate
    Managing Error
    Macro
    Project file module 4

Exam

    Exam




FAQ



Instructor

Reviews

Write your own review

 
Rating
Md. Shahinur
"It was really good experience with you. Learn many thing from you. Good presentation. Thank you!"

Israt Jahan
"Best Learning session. I am Tremendously grateful for this course. Just want to say from core of my heart "Thank You" "

Sabbir Ahmmad
"Superb Training. The trainer is awesome. The content is very good. "