Corporate Excel Masterclass

® Ms Excel (Basic)

® Corporate Excel Masterclass

·   Corporate Excel Foundation

·   Data Cleaning & Preparation

·   Professional Formula & Functions
(IF, VLOOKUP, XLOOKUP, INDEX + MATCH, FILTER, SORT, SUMIFS, COUNTIFS & More)

·   Data Analysis

·   Pivot Table Masterclass

·   Dashboard Development

·   Power Query & Data Transformation

·   Excel Automation (Macro & VBA Basics)

·   Security & Collaboration

® Interview Preparation

·   100+ Excel Keyboard Shortcuts

·   100 Corporate Excel Interview Questions

·   Live Practical Test

·   Excel Assessment Exam

® Corporate Live Projects

·   HR Employee Database

·   Payroll Management System

·   Inventory Management System

·   Sales Dashboard

·   Accounts Cash Book

·   Purchase Management System

·   Financial Statement (P&L)

·   Attendance Management System

·   Invoice Generator

·   MIS Dashboard

® Final Capstone Project- Corporate  

MIS Reporting System

·   Raw Data Import

·   Power Query

·   Formula Automation

·   Pivot Table

·   Interactive Dashboard

·   Printable Report

·   PDF Export