29$

14$




Review
    (0)

    5/0.0

Categories
IT

Overview

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

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

00:01:41 Hours

    Trainer Introduction
    00:01:41

Module one

00:59:30 Hours

    The Basics
    00:13:12
    cell reference
    00:06:19
    Basic Formatting
    00:05:10
    Custom Number Format
    00:08:04
    Conditional Formating
    00:05:35
    Duplicate
    00:04:43
    Zoom Split Freeze
    00:05:04
    Spelling
    00:02:50
    Print
    00:08:33

Module Two

00:49:54 Hours

    Basic Functions
    00:05:43
    Paste Special
    00:06:13
    Filtering and Sorting
    00:04:58
    Logical Function
    00:12:27
    Concatenate
    00:02:56
    Left Mid Right and text to column
    00:07:12
    Count Sum
    00:05:25
    Change Case
    00:02:24
    Data Cleanup And Trim
    00:02:36

Module Three

00:58:26 Hours

    Vlookup Hlookup
    00:09:21
    Data Validation
    00:07:56
    Pivot table
    00:12:08
    Organogram
    00:13:22
    Basic Chart
    00:07:43
    Pie Chart and Combination Chart
    00:04:01
    Info graph
    00:03:55

Module Four

00:25:01 Hours

    Protection
    00:07:20
    Aggregate
    00:02:54
    Managing error
    00:02:41
    Macro
    00:12:06




FAQ



Instructor

Reviews

Write your own review

 
Rating