imtAnalyst

If you want to learn Microsoft Excel from Basic to Advanced, then you are at the right place. We will help you to learn Microsoft Excel.

The first thing I want to tell you is the syllabus. If you want to become an expert in Microsoft Excel then you will learn the following topics.

Microsoft Excel Course | Class-1 | MIS Training

Complete Microsoft Excel from Basic to Advance 
There are the following four modules to learn to complete 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         

Topics of Microsoft Excel Class-1

1.    Auto Fit: Alt+O+C/R+A

2.    Auto Format: Alt+O+A

3.    Insert Row & Column: Alt+I+R/C

4.    Insert Normal Serial Number: A+1 (Drag Down)

5.    Dynamic Serial Number: Subtotal

6.    Freeze System: Alt+W+F+F

7.    Filter: Ctrl+Shift+L

8.    Difference Between Normal & Dynamic Serial Numbers

9.    Flash Fill: Ctrl+E

Enroll Now: www.imtanalyst.in or www.imtanalyst.com

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: info@btlc.in and info@imtanalyst.com

Website: www.imtanalyst.com  and www.imtanalyst.com