Microsoft Excel Course Class 6 Excel Questions Asked in Job Interviews
Welcome to our Excel Mastery channel, where we take you from basic Excel functions to advanced data analytics projects. Our modules cover everything from basic sorting and filtering to advanced tools like Pivot Tables, Power Query, and Power Mapping. Join us and become an Excel pro!
Ready to take your Excel skills to the next level? Our channel covers everything you need to know to become an expert in Excel, from basic statistical functions like CountIf and SumIf to advanced tools like Power Pivot Tables and BI and RCA Dashboards. Subscribe now and start mastering Excel!
Get ready to become an Excel master with our comprehensive video tutorials! Our channel covers all four modules of Excel training, from basic Excel functions to advanced analytics projects and WFM training. Subscribe now and unlock the full potential of Excel!
Looking to improve your Excel skills? Our channel is here to help! We cover a range of topics, from basic Excel tools to advanced analytics projects and Power BI training. Whether you're a beginner or an advanced user, we've got you covered. Subscribe now and start learning!
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 Us
Blazing-Tech and Learning Center provides skill-based educational training and IT services across India.
Address: Naya Nagar Market at Farrukhabad Road Dara Sarai Samdhan Gursahaiganj Kannauj 209722.
Mobile: +91 – 9999653819
Email Id: [email protected] and [email protected]
Website: www.btlc.in and www.imtanalyst.com