Certificate Program in Advanced Excel

Mode of Learning- Virtual Live Sessions

Excel is a vital tool for speeding up productivity and allowing workers to be more efficient when dealing with large amounts of data and calculations. When you understand Excel at a more advanced level, you will have the ability to use its more sophisticated tools, which will allow you to complete your tasks and analyze your data more quickly.

35

Hours of Learning


Full Lifetime Access

#1

Program for Beginners

100%

Live Content

Requirements?

This program was created with excel 2013. But all features will work in Excel 2010, 2013, 2016, and most will work in 2007.

Eligibility for this program?

Anyone with a minimum qualification of 10+2 can enroll in this program.

Ideal jobs for Excel Users

Financial Analysts, Retail Store Managers, Administrative Assistants, Data Journalists, Business Analysts, Project Managers, Accountants, Information Clerk....and many more.

Admission Criteria

There are no mandatory tests to enroll in this program.

Key Takeaways

01.

Learn the most common Excel functions used in the office.

02.

Wow your boss by unlocking dynamic formulas with IF, VLOOKUP, INDES, MATCH functions, and many more...

03.

Create dynamic reports by mastering one of the most popular tools, PivotTables

Learners will get this certficate upon successful completion of the program.

Course Curriculum

32 Modules         

Certificate-Program-in-Advanced-Excel

expand_more

label_important

Understanding Excel and its Introduction

label_important

Interface of Excel

label_important

Shortcut Keys- 1

label_important

Shortcut Keys- 2

label_important

Test 1- Shortcut Keys

label_important

Basic Functions (SUM, AVERAGE, COUNT)

label_important

Functions Class 2- SUMIF, AVERAGEIF, COUNTIF etc.

label_important

Test 2- Functions (Level 1)

label_important

Recap- Basic Formulas & Shortcuts

label_important

Cell Referencing & it's types

label_important

Intermediate Formulas & its Uses

label_important

Introduction to Error Output

label_important

Data Validation- Sorting & Filtering

label_important

Practical Concepts in Editing, Formatting, and Referencing

label_important

Test 3- Functions (Level 2)

label_important

Introduction to the Lookup Functions

label_important

Improvisation of the Lookup Functions (INDEX, MATCH)

label_important

Test 4- Functions (Level 3)

label_important

Advanced Sorting, Filtering & Data Validation with Text-to-Column

label_important

Performing Various Charts in EXCEL & Conditional Formatting

label_important

Pivot Table & Pivot Charts

label_important

Slicers, Spraklines & Timelines

label_important

Live Test- 1

label_important

Live Test- 2

label_important

Introduction to Macros

label_important

Excel Macros - VBA & Editor

label_important

Macros in a Single Workbook / Multiple Workbooks

label_important

Running / Editing A Macro & Assigning Macros to Objects - 1

label_important

Running / Editing A Macro & Assigning Macros to Objects - 2

label_important

Running / Editing A Macro & Assigning Macros to Objects - 3

label_important

Assignment 1- Macros

label_important

Assignment 2- Macros

Program Fee

INR 3,499   4,999  (30% discount)

(+18% GST)

ENROLL NOW

Contact Us

Address

Saraswati Encl., 

Pataudi Road, Gurugram, Haryana- 122001

Follow Us


© Copyright 2021 ProfSkills4U

Launch your GraphyLaunch your Graphy
100K+ creators trust Graphy to teach online
Profskills4u 2022 Privacy policy Terms of use Contact us Refund policy