ADVANCED EXCEL - Live Instructor Led Class

Become a wizard at Analysing Data and Preparing Reports in Excel with this course.

starstarstarstarstar 5.0 (1 ratings)

Language: English

Instructors: Aadi Puttaswamy


Why this course?

Description

COURSE OVERVIEW

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.

WHY LEARN EXCEL?

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

DETAILED COURSE CURRICULUM
  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
 WHO SHOULD TAKE UP THIS COURSE?

The following professionals can take up this Course:

  • Data Analyst
  • Financial Analyst
  • Advanced Excel User
  • Fresher seeking jobs in Analytics/Consulting job streams
PRE-REQUISITES FOR THIS COURSE
  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
COURSE DELIVERY FORMAT & CERTIFICATE
  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

Course Curriculum

How to Use

After successful purchase, this item would be added to your courses. You can access your courses in the following ways :

  • From the computer, you can access your courses after successful login
  • For other devices, you can access your library using this web app through browser of your device.

SUBSCRIPTION PLANS

Choose the right plan that works for you.

E-LEARNING
VIDEOS

₹399

  • Unlimited Access to High Quality Interactive Video Lectures
  • Industry-specific Study Material for hands-on Experience across multiple use cases
  • Interactive MCQs and Assignments for Self-Assessment
  • Access to LMS from Mobile, Tablet or PC
  • Certificates which can be globally verified


BLENDED
LEARNING

₹1,990

  • Unlimited Access to High Quality Interactive Video Lectures
  • Industry-specific Study Material for hands-on Experience across multiple use cases
  • Interactive MCQs and Assignments for Self-Assessment
  • Access to LMS from Mobile, Tablet or PC
  • Certificates which can be globally verified
  • Weekly 3 Hour Live Doubt Clearance Session

INSTRUCTOR LED
LIVE CLASSES

₹4,960

  • Unlimited Access to High Quality Interactive Video Lectures
  • Industry-specific Study Material for hands-on Experience across multiple use cases
  • Interactive MCQs and Assignments for Self-Assessment
  • Access to LMS from Mobile, Tablet or PC
  • Certificates which can be globally verified
  • Unlimited Live instructor led Online/Offline Classes

Reviews

Launch your GraphyLaunch your Graphy
100K+ creators trust Graphy to teach online
iTech Analytic Solutions 2023 Privacy policy Terms of use Contact us Refund policy