fbpx

Excel for Professionals Part-1

Excel for Professionals Part-12020-07-29T11:00:57+00:00

Project Description

Course Details

Excel for Professionals Part-1

Total Course Duration: 20 Hours
Per Class Duration: 2 Hours

Overview

  • 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

Resource Person

Faisal Wahid
Faisal WahidSenior Technical Trainer Programming
Mohammad Shihab Uddin
Mohammad Shihab UddinSenior Technical Trainer Programming
Amin Tanvir
Amin TanvirTrainer Graphics & Multimedia BSE in CSE,
Suman Chakraborty
Suman ChakrabortySenior Technical Trainer Networking
Tawhidul Alam
Tawhidul AlamSenior Technical Trainer Programming
Shariful Islam
Shariful IslamSenior Technical Trainer Web Programming