Microsoft Excel for Professionals

Microsoft Excel for Professionals

Microsoft Excel is the most used tool in the professional world. In every sector including sales, finance, marketing, engineering, supply chain, HR & administration excel can ease your workload.

course at a glance

  • Date : 13 Apr - 20 Apr 2020
  • No. of Classes/ Sessions : 6
  • Total Hours : 18
  • Last Date of Registration : 12 Apr 2020
  • Class Schedule :
    • Saturday - 6.00 PM - 9.00 PM
    • Monday - 6.00 PM - 9.00 PM
    • Wednesday - 6.00 PM - 9.00 PM
  • venue : Lucid Maze House# 01, Road# 10, Mirpur# 2, Dhaka Opposite of stadium VIP gate. #01939900697 #01892477359

Price: TK. 6,000
(Excluding VAT & TAX)

Day 1:

  1. Excel intro.
  2. Absolute & relative cell reference
  3. Breaking & joining text.
  4. Sorting & filtering.
  5. Subtotal & AutoSum Tricks

 

Day 2:

 

  1. Alphabetic series and new series.
  2. Date Time
  3. Number to word
  4. Define Name
  5. Table
  6. Formulas (SUM, SUMIF, COUNT, COUNTA, COUNTIF, AVARAGEIF, CONCATINATE, AND, OR, PROPER, LOWER, UPPER and many more.)

 

Day 3:

 

  1. Advanced formula (VLOOKUP, HLOOKUP, IF, MATCH, INDEX and many more)
  2. Conditional formatting
  3. Data validation
  4. Conditional drop down

 

Day 4:

 

  1. Goal seek
  2. Excel solver
  3. Developer options. Button, checkbox etc.
  4. Form
  5. Excel tips and tricks.
  6. Hyperlink
  7. Macro recording

 

Day 5:

 

  1. Pivot table
  2. Data model & pivot table with multiple data source.
  3. Pivot chart
  4. Visuals
  5. Pie chart, Doughnut Chart, Sparkline.
  6. Slicers & time line

 

Day 6:

 

  1. Prepare a full dashboard.
  2. Customized chart.
  3. Power pivot
  4. Power query
  5. Power BI intro.
  6. And many more…….

 

Curriculum

Microsoft Excel for Professionals Data Driven Decision Making 18 Hrs

Tentative Class Start

13th April, 2020

Available Seat

10 / 20

who can join

This course is designed for professionals. The target audiences are the Managers, Executives, Teachers, Entrepreneurs, Developers, Students, and Researchers.

Meet the Instructor