logo
আরবি ভাষা শিক্ষক প্রশিক্ষণ কোর্স - নিবন্ধন করুন এখনি! x

Microsoft Excel Masterclass - Beginner to Advanced Level

  • No Rating
  • (0 Reviews)
  • 0 students enrolled

Microsoft Excel Masterclass - Beginner to Advanced Level

Learn Microsoft Excel from Novice to Expert & learn the art of creating quick Reports from a Professional Financial Analyst Excel Trainer

  • No Rating
  • (0 Reviews)
  • 0 students enrolled
  • 6000.00৳
  • 8000.00৳
  • Course Includes
  • Mastering Business Analytics & Intelligence course
  • Daily online Support
  • Free performance review after one month
  • Certificate after course completion


What learn

  • From this course you will achieve Solid understanding of Excel including essential formulas, data tools like Sorting, Fi...
  • • Solid understanding of Microsoft Excel
  • • Knowledge of all the essential Excel formulas
  • • Become proficient in Excel data tools like Sorting, Filtering, Data validations and Data importing
  • • Master Excel's most popular lookup functions such as Vlookup, Hlookup, Index and Match
  • • Harness full potential of Excel by creating Pivot tables with slicers
  • • Make great presentations using the Conditional and Table formatting options
  • • Visually enchant viewers using Bar charts, Scatter Plots, Histograms, Waterfall charts etc.
  • • Increase your efficiency by learning how to create and use important Excel shortcuts
  • • Learn Automation techniques by using Macros
  • • MS Excel skills from beginner to Advanced
  • • Excel Formulas, Functions & keyboard shortcuts
  • • Pivot Table and Pivot Charts & Automate reports
  • • Excel Charts and Graphs and custom based Visualizations
  • • Be able to create summary reports quickly

Course Content

12 sections • 12 lectures •
Microsoft Excel Masterclass - Beginner to Advanced Level
Course Modules
Day-1: Overview of the Course
MODULE 1
1.1 Introduction
1.2 Overview
MODULE 2
2.1 Combine what you can enter in a cell
2.2 Relative and Absolute Cell Referencing
2.3 Entering Formula
2.4 Order of Operations
2.5 Date Serial Numbers
MODULE 3
3.1 Copy and Drag
3.2 Working with rows and columns
3.3 Working with sheets
Day-2: Functions and Formatting Technique
MODULE 4
4.1 Functions
4.2 SUM Function
4.3 Copy and Drag Formula
4.4 More Basic Functions
4.5 Named Ranges
4.6 Names Constants and Formula
4.7 Shortcuts
4.8 More Shortcuts
MODULE 5
5.1 Formatting Font
5.2 Formatting Alignment
5.3 Formatting Borders
5.4 Formatting Numbers
5.5 Conditional Formatting Pre-Configured
5.6 Conditional Formatting with Formula
5.7 Conditional Formatting Dialogue Box Formula Trick
MODULE 6
6.1 Icons Shapes and Formatting
6.2 Printing Page Layout
6.3 Printing Headers Footers
Day-3:Data Analysis Technique
MODULE 7
7.1 Data Sort
7.2 Filtering
7.3 Tables
7.4 Text to Columns
7.5 Flash Fill
7.6 Data Validation
7.7 Group and Outline
7.8 Freeze Panes
MODULE 8
8.1 Relative and Absolute Referencing
8.2 VLOOKUP
8.3 Index Match
8.4 IF
8.5 Nested If
8.6 Countif Countifs
8.7 SUMIF SUMIFS
8.8 LEN
8.9 RIGHT LEFT MID
8.10 SEARCH
8.11 Common Error Types
8.12 IFERROR
Day-4: Data Visualization through Charts
MODULE 9
9.1 Chart Basics
9.2 Chart Series and Column Charts
9.3 Bar Charts
9.4 Pie Charts
9.5 Composite Charts
9.6 Waterfall Charts
9.5 Charts Management
4.8 Practical case analysis
MODULE 10
10.1 Pivot Tables
10.2 Setting up a Pivot Table
10.3 Pivot Table Field Settings
10.4 Pivot Table Calculated Fields
10.5 Pivot Table Groupings
10.6 Pivot Table Slicers and Timelines
10.7 Dashboards
Day-5: Macro  and VBA
MODULE 11
11.1 What is a macro?
11.2 Recording a Macro
11.3 Practical case analysis
MODULE 12
12.1 Introduction to VBE
12.2 Object Model
12.3 Module Worksheets Classes
12.4 Variables and Constants
DIM
SUB
END WITH
12.8 Practical case analysis
mb
2.1 Combine what you can enter in a cell ; 2.2 Relative and Absolute Cell Referencing ; 2.3 Entering Formula ; 2.4 Order of Operations ; 2.5 Date Serial Numbers ;
MODULE 2 Cell Management
2.1 Combine what you can enter in a cell
2.2 Relative and Absolute Cell Referencing
2.3 Entering Formula
2.4 Order of Operations
2.5 Date Serial Numbers
mb
3.1 Copy and Drag ; 3.2 Working with rows and columns ; 3.3 Working with sheets ;
MODULE 3 Understanding Row & Column ;
3.1 Copy and Drag ;
3.2 Working with rows and columns ;
3.3 Working with sheets ;
mb
4.1 Functions 4.2 SUM Function 4.3 Copy and Drag Formula 4.4 More Basic Functions 4.5 Named Ranges
MODULE 4 Function
4.1 Functions
4.2 SUM Function
4.3 Copy and Drag Formula
4.4 More Basic Functions
4.5 Named Ranges
4.6 Names Constants and Formula
4.7 Shortcuts
4.8 More Shortcuts
mb
5.1 Formatting Font ; 5.2 Formatting Alignment ; 5.3 Formatting Borders ; 5.4 Formatting Numbers ;
MODULE 5 Conditional Formetting
5.1 Formatting Font
5.2 Formatting Alignment
5.3 Formatting Borders
5.4 Formatting Numbers
5.5 Conditional Formatting Pre-Configured
5.6 Conditional Formatting with Formula
5.7 Conditional Formatting Dialogue Box Formula Trick
mb
6.1 Icons Shapes and Formatting 6.2 Printing Page Layout 6.3 Printing Headers Footers
6.1 Icons Shapes and Formatting ;
6.2 Printing Page Layout ;
6.3 Printing Headers Footers ;
mb