Why this course?

Description

Advanced Excel 2019/ Excel 365 training course will help you facilitate and gain expertise in Advanced Excel techniques covering concepts like Lookup functions, Formula Auditing, Data validation, Pivot tables, Pivot charts, Advanced Filters, Sparklines, and Data Security.

Excel has become a required skill for nearly all jobs in the analytics and consulting industries. You will learn the advanced functions that analysts use on a daily basis in this course. You'll also become acquainted with more advanced levels of Excel use, which will be useful in the future. You will be given hands-on assignments and case studies throughout the course to put your theoretical knowledge into practice.

"Companies such as NVIDIA, Dell, Walmart have a demand for data analysts with advanced excel knowledge" - Glassdoor.com

As per Payscale.com, the average salary for a Data Analyst with MS Excel skill is Rs. 354,974 per year

"Excel is the most in-demand software skill for Indeed job posts" - Hrdrive.com

1. Introduction
2. Spreadsheet Principles
3. Understanding Screen Layout
4. Creating Auto List & Custom List
5. Entering, Selecting and Editing Data
6. Understanding References (Relative, Absolute & Mixed)
7. Working on Various Functions & Formulas
   1. Common Basic Functions (SUM, MIN, MAX, AVERAGE, COUNT, COUNTA, COUNTBLANK)
   2. Text Functions (UPPER, LOWER, PROPER, LEFT, RIGHT, MID, SUBSTITUTE & More)
   3. Date & Time Functions (DATE, EOMONTH, DATEVALUE, TODAY, NOW & More)
   4. Lookup & Reference Functions (VLOOKUP, HLOOKUP, INDEX, MATCH)
   5. Mathematical Functions (ROUND, ROUNDUP, ROUNDDOWN, PRODUCT, SUMPRODUCT)
   6. Conditional Functions (IF, NESTED IF, SUMIF, COUNTIF, AVERAGEIF)
8. Formula Auditing
9. Various Calculation Techniques
10. Working on Ranges (Static & Dynamic)
11. Sorting Techniques
12. Various Data Filtering Techniques
13. Formatting Techniques (Cells, Range, Sheets)
14. Conditional Formatting
15. Number Formatting
16. Table Formatting
17. Data Validation Techniques
18. Working on Data Tools
19. Data Consolidation
20. Group and Outline
21. Text to Columns
22. Flash Fill
23. New Ink Effects
24. Microsoft Translator
25. Linking various Sheets and Files
26. Creating Charts (Basic & Advanced)
27. Understanding Sparklines (Line, Column, Win/Loss)
28. Working with Tables
29. Pivot Tables & Pivot Charts
30. Working on Slicers & Timelines
31. Protecting Sheets & Files
32. Understanding Various Excel Window Techniques
33. Viewing Excel Spreadsheet in various Layouts
34. Advanced Printing Techniques

The following additional topics on MS Excel 365:

• New Excel 365 Formulas
• Power Query Editor
• Data Modeling
• Power Pivots
• New Charts in Excel 365
• Power Pivots

On Registering for the Course you get MICROSOFT EXCEL ASSOCIATE CERTIFICATION - FREE.

You also get 

• Study Guide
• Practice Files
• E-Books

The following professionals can take up this Course:

• Data Analyst
• Financial Analyst
• Advanced Excel User
• Fresher seeking jobs in Analytics/Consulting job streams

1. Basic understanding of operating Computers or Laptops will be supportive.
2. Laptop or Desktop with Excel 2016 version and above installed is required to use the practice material
3.  Stable Internet Connection

1. You will undergo self-paced learning where you will get an in-depth knowledge of various concepts that will be covered in the course.
2. You will get lifetime access to all the videos, discussion forum and other learning contents inside the Learning Management System.
3. Each module will contain case study, which can be completed before going to next module.
4. Towards the end of the course, you will be attending series of MCQ question where you are expected to implement the techniques learnt during the course to answer them.
5. You need to score atleast 70% in MCQ test to be eligible to get the Certification.

Have More Queries? - Contact us on 9066078793 or write to us on enquiry@itasinc.in

Facing Technical Issues? - WhatsApp us on 9066068793, issue will be resolved as early as possible