+8801934-453979 info@kaizenitbd.com
register

register now

Advanced Exel

COURSE OVERVIEW

Advanced Excel is a comprehensive tutorial that provides a good insight into the latest and advanced features available in Microsoft Excel 2013.

COURSE MODULE

  • Ice Breaking and Discussion for Dashboard Reporting
  • Data Matching & Lookups for Preparing Dashboard’s Raw Data
  • Logical Function & Formula Nesting
  • Naming in Excel
  • Data Summarization from Large Data
  • Techniques to Validate Raw Data
  • PivotTable
  • PivotChart and Slicers
  • Make Protected Your Dashboard.
  • PowerPivot – Use Excel’s Built-in Self Service BI Tool.
  • Using Objects & Form Controls to Control Your Dashboard
  • Using Charts & Graphs in Dashboard
  • Applying Advanced Conditional Formatting on Dashboard
  • Macro & VBA
  • Exclusive Project Session

COURSE DURATION

Course Free: 4600 TK

Course Duration: 3 months

Total Hours: 30 hours

( Weekly 3 Class, Every Class 2 Hours )

COURSE PREREQUISITES

Basic knowledge of computer operating.

Basic knowledge of internet browsing.