Project Description

Microsoft Excel for Professionals Part-1

COURSE PLAN

  • Basic Concept About MS Excel
  • Link Worksheet and workbook
  • Visualizing Data with Charts
  • Working with Multiple Workbook o Consolidate Data o Link Cell in different workbook o Merge Workbook
  • Picture Lookup
  • Dynamic Table
  • Data Validation
  • Common Financial Function (Say PMT)
  • Conditional Formatting
  • Data Entry Form Create (Without Macro)
  • Dashboard
  • Combo Box Create (Without Macro)
  • Analyzing and Presenting Data
    • Sparklines
    • Scenarios
    • What‐If Analysis
    • Analysis‐Tool Pick
    • Power View Add‐In
    • Pivot Tables
    • Pivot Charts
    • Slicers
  • Auditing Worksheet o Scenarios
    • Sub‐Total
    • Grand‐Total
  • Export and Import Data
  • Excel File Backup
  • Project o Result Sheet o Electric Bill o Manual Attendance Sheet o Sales Report
    • Age Calculator

COURSE DURATION

Total Course Duration: 21 Hours
Per Class Duration: 3 Hours

RELATED COURSES

AUTHORIZATION

COURSE RESOURCE PERSON

TANVIR ISLAM
SENIOR TECHNICAL TRAINER

View Profile

MOHAMMAD SHIHAB UDDIN
SENIOR TECHNICAL TRAINER (PROGRAMMING)

View Profile

SUMAN CHAKRABORTY
SENIOR TECHNICAL TRAINER (NETWORKING)

View Profile

RASEL AHMED
TECHNICAL TRAINER (NETWOEKING)

View Profile

MD TAWHIDUL ALAM
SENIOR TECHNICAL TRAINER
(WEB PROGRAMMING)

View Profile

MD. FOYSAL WAHID
SENIOR TECHNICAL TRAINER
(PROGRAMMING)

View Profile

MUNTASIR MOSTAFA JAMAL
TECHNICAL TRAINER (PROGRAMMING)

View Profile
UPCOMMING BATCH
CLICK HERE