Microsoft Professional Excel Training specially designed for professionals to work on industry requirements

Curriculum:

Module 2: Basic and Intermediate Excel Features and Functionality part 2

Understanding the number format codes
Changing the font color with number format codes
Hide Number and Text based on criteria
GOTO SPEICAL Feature
Creating Name range and Name Manager
Hyperlink from a different sheet, workbook, cell, defined names and websites
Remove Duplicates
Data Validation: Data List, rules, modify error messages
Grouping, ungrouping and Subtotal in Excel

Free Demo

Module 3: Number Function

COUNT, COUNTA, COUNTBLANK
COUNTIF
COUNTIF with wildcard
Uses of COUNTIF with real-time example
Unique Entry using the COUNTIF function
Find duplicates using COUNTIF Function
Running Count
Example of COUNTIFS
Example of SUMIFS
Example of AVERAGEIFS
Example of DCOUNT
Example of COUNTA
Example of DSUM
Example of DAVERAGE

Free Demo

Module 4: Logical and SUMPRODUCT Functions

Logical Functions: IF, Nested IF, AND, OR, NOT, XOR, IFERROR
SMALL and LARGE function
SUMPRODUCT Function
Use SUMPRODUCT for COUNT
Use SUMPRODUCT for SUM
Use SUMPRODUCT for COUNTIF and COUNTIFS
Use SUMPRODUCT for SUMIF and SUMIFS
Use SUMPRODUCT for AVERAGE and AVERAGEIFS
Use SUMPRODUCT for MAXIF and MAXIFS

Module 5: Text functions in Excel to solve complex text problems

Introduction of TEXT Functions (LEFT, RIGHT, MID, REPLACE, SUBSTITUTE, etc) available in Excel
Use text functions to Split the words
Use text functions to split characters and numbers
What-If Analysis in Excel

Module 6: Date and Time Functions in Excel, creating a dynamic calendar for whole months and years

Introduction of Date Functions available in excel.
Create and Design Calendar using Different Date Functions (WEEKDAY, WEEKNUM, EOMONTH, EDATE) in excel.
Calculate Age using DATEDIF Function
Calculate the date and time difference
count working days using NETWORKDAYS Function

Module 7: LOOKUP, VLOOKUP, HLOOKUP functions

Introduction of LOOKUP VLOOKUP and HLOOKUP
VLOOKUP with Exact Match
VLOOKUP with Approximate Match
Usage of VLOOKUP Functions using ROW and COLUMN functions
Example of VLOOKUP with Array
Example of HLOOPKUP with multiple Examples
Example of LOOKUP with multiple examples

Module 8: INDEX and OFFSET function, Uses of Array in Excel

Introduction of the INDEX Function
Introduction of OFFSET Function
Use of INDEX Function
Advance uses of Array Function using INDEX, OFFSET, MATCH, SMALL, LARGE, ROW, and COLUMN function
Use of ROW and ROWS function using INDEX and OFFSET function

Module 9: INDIRECT and ADDRESS Function

Introduction of INDIRECT Function
Introduction of ADDRESS Function
Uses of INDIRECT Function
Uses of ADDRESS Function

Module 10: Data Analysis using Power Query and Power Pivot in Microsoft Excel

Creating a Pivot table and Pivot chart in Excel
Adding Slicer and Timeline to analyze in Excel
Using the power pivot to do the Data Analysis
Using Power Query to Source the data from Different Sources

Module 11: MIS Reports and Dashboards

Introduction of Dashboards and MIS Reports
Adding and Using User Form control in Excel
Recording Macro and run it through a command button
Creating Dynamic Formula based on` User Form control
Creating Dynamic Charts using Formula
Creating 2D charts in Excel
Importance of charts in Dashboards and MIS Reports

Module 12: Creating Dynamic Dashboard on Live data

Project work on MIS Dashboard

Module 1 : Excel Features and Funcitonality

How to work on Copy Paste and Paste Special
Row, cells, column in Excel
Sheet, work sheet and data protection
Data Validation in excel

Course Highlights

No. of hours: 45

Star Rating: (6)

Trainer:

Shiv

Shiv has over 10 years of experience in Microsoft Technologies, Infonet CRM, and as a Business Analyst in Product Management. I excel in MS Dynamics CRM 365 admin, functional operations, and creating business dashboards. TECHNICAL SKILLS Microsoft Dynamics 365: CRM Admin, Functional Sales/Service/Marketing, Workflow, Training, Technical Support. HTML: Basic knowledge SQL: Expert Microsoft Visio - Basic Infonet CRM & SAP-Training dealers, Admin Task, Material Task creation, customization of News Page, POP Management etc.

No. of learners: 169

Fee:

Online Virtual Class Room

Enroll in any above batch and attend live class at scheduled time

5000

Upcoming Batches:

FAQ:

1. What is Microsoft Excel?

Microsoft Excel is spreadsheet developed by Microsoft. It can be installed in Windows, MacOS, Android and iOS. Microsoft Excel is being used for calculation, data analysis, reporting and attractive dashboards by using it’s features like pivot table, charts, formula etc.

2. Where we can use Microsoft Excel?

If you want to create reports, dashboards or if you want to do data analysis. Excel can play a vital role for your requirements; you can use Microsoft Excel in that case. You can create dynamic dashboards on excel using Excel, SQL or any other database. You don’t have to purchase separately; it comes under Microsoft office package.

3. Any Prerequisite to learn MS Excel?

There is no prerequisite to learn excel. If you are familiar with Windows operating system, you can join our course to become professional in MS Excel.

4. System requirements to Install MS Excel?

500 MHz processor, along with 256 MB Ram and a 3 GB hard disk.

5. Recommend Audience for the course:

As it is basic of Data Analysis, any body who is aspiring towards data science or data analytics can enroll for this course.

6. In case of my absence, how can I manage my class?

You will get access of LMS (Learning management System), if you missed your class you can refer the recorded session in your LMS. If you have any doubt you can ask in your next class whenever you will join.

7. Who is the Instructor?

Our instructors are industry experts having more than 8 years of corporate experience. Since they have rich experience in their domain they will train as per the industry standards.

8. Will you help us in Job placement?

We have tied up with more than 100+ companies in corporate industry. We will schedule your interview after successful completion of our course.

9. Will you help us in resume creation?

Yes, we will help you in creating your resume so that it can shortlist easily for interview.

10. Will you help us to get the software?

Yes, we will help you with Trial version of software.

11. How long can I access my (LMS) learning management System?

Once you will enroll for the course, you can access the LMS for life long.

12. How can I get the certification?

Once you will complete your course, you will appear for an online test. Basis on your score we will issue the certificate.

13. What is Self-paced course?

If you will enroll for self-paced course you can access the pre recorded sessions and you can do self-learning. You can complete your course as per your availability.

14. What us Instructor driven course?

This is online virtual class room training, since this is live class, you can clear your doubts in the class.

15. What if I have more queries or concerns?

You can write an email at info@wifilearning.com or you can contact us at our Office numbers at 91-9999468661.

16. What is Knowledgebase?

It is our technical query support system. You can raise your technical questions and it will be resolved here. Our experts are actively answering your questions.