Running Count in Excel | Dynamic Number in Excel
Complete Microsoft Excel from Basic to Advance
There are the following four modules to learn to become an expert in Microsoft Excel.
Module-1: Basic Excel
1. Excel Tools, Sorting & Filter, Function & Formulas, and Array Functions.
2. Statistical Functions (CountIf, SumIf, AverageIf, Sumproduct, etc)
3. Database Functions like DSUM, DAVERAGE, DMAX, DMIN, DLOOKUP
4. Text Functions like TEXT, LEFT, RIGHT, MID, and Text Join.
5. Conditional Formatting Error Handling and Protection etc.
6. Date & Time Functions like DAYS, EDATE, EOMONTH, DAY, DATEIF
7. Logical Functions (Switch, If, Ifs, AND OR NOT Iferror, etc)
Module-2: Advance Excel
1. 16 Types of Indirect Functions (Look UP Functions)
2. 75 Types of Vlookup/Hlookup Functions
3. 30 Types of Index and Array Functions
4. Pivot Table/Power Pivot Table (Basic to Advance)
5. Slicer/Timeline, Inquire, Flash Fill Cluster
6. Dash Functions, Power Query, Power mapping
7. Web Queries and 50 Types of Offset Functions
Module-3: Analytics Projects
1. Data Fetching and Data Collection
2. Data Cleaning Formatting & Error Handling
3. Dash Board Management Training
4. 22 Types of Charts & Sparklines
5. 25 Types of Dynamic Charts & Form Controls Utilization
6. 10 Types of Dashboard & Dashboards KPIs
7. Live Dashboard doing Practice
Module-4: WFM & power bi training
1. Planning (Flow Chart of Implementation)
2. Resource Management (Staffing & Manpower Hiring)
3. Scheduling (Rostering & Time Management)
4. Forecasting and Budgeting (Analysis)
5. KPI Dashboard
6. Sales Dashboard
7. BI and RCA Dashboard
About BTLC
BlazingTech and Learning Center
BTLC (Blazing-Tech & Learning Center) is a tech company that provides technical and financial services, including educational training. BTLC is registered as an LLP in Delhi.
Contact Details
Phone: +91 – 9999653819
Email: [email protected] and [email protected]
Website: www.btlc.in and www.imtanalyst.com
Register Now for Free Course
https://imtanalyst.com