29$

14$




Review
    (0)

    5/0.0

Categories
IT

Overview

  • Quizzes No
  • Skill level Beginner
  • Language Bangla
  • Duration 03:14:32 H
  • Total Enrollments: 1

Course Description

It's time to show Excel who's boss. Whether you're starting from square one or aspiring to become an absolute Excel power user, you've come to the right place.

This course will give you a deep understanding of the advanced Excel formulas and functions that transform Excel from a basic spreadsheet program into a dynamic and powerful analytics tool.

While most Excel courses focus on simply what each formula does, I teach through hands-on, contextual examples designed to showcase why these formulas are awesome and how they can be applied in a number of ways. I will not train you to regurgitate functions and formula syntax; I will teach you how to THINK like Excel.

Certification

No

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 Basics
    cell reference
    Basic Formatting
    Custom Number Format
    Conditional Formating
    Duplicate
    Zoom Split Freeze
    Spelling
    Print

Module Two

    Basic Functions
    Paste Special
    Filtering and Sorting
    Logical Function
    Concatenate
    Left Mid Right and text to column
    Count Sum
    Change Case
    Data Cleanup And Trim

Module Three

    Vlookup Hlookup
    Data Validation
    Pivot table
    Organogram
    Basic Chart
    Pie Chart and Combination Chart
    Info graph

Module Four

    Protection
    Aggregate
    Managing error
    Macro




FAQ



Instructor

Reviews

Write your own review

 
Rating