Microsoft Advanced Excel Training online in delhi ncr

Curriculum:

Module 1: Basic Excel Features and Functionality part 1

Introduction of Excel compare MS Excel 2016 with other Excel versions
Copy/Paste, Paste Special
Add and Edit Comments
Fill Effects
Wrapping text within a cell
Data Formatting
Filter, Advanced Filter, Color Filter
Sorting, Advance Sorting, Custom Sorting
Flash Fill Feature
Text to column functionality of excel to Split words
Absolute, Relative and Mixed Cell References
Protect sheet and workbook
Protect Range
Table Feature
Freeze and unfreeze panes and Split
Excel Keyboard Shortcut Keys
Conditional and Custom formatting

Free Demo

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

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

Course Highlights

No. of hours: 24 hrs

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: 67

Fee:

Online Virtual Class Room

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

4000

Offline Class Room

Visit our centre and enrol for the course, The course Fee will vary as per the Metro/ Non Metro or locality.

4000

Upcoming Batches:

2024-10-19 10:00 AM IST	Weekend Batch (2 Hours Sat & Sun)	₹4000 ₹3600 (10% OFF) Offer Ends in 10 d: 13h : : 58s
2024-10-07 8:00 AM	Weekdays Batch	4000
2024-10-14 8:00 PM IST	Weekdays Batch	₹4000 ₹3600 (10% OFF) Offer Ends in 5 d: 13h : : 58s

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.