4.5 Upto 2 Month
English / हिंदी में सीखें

Advance Excel

Advance your career with this essential course for professionals and Job seekers. Learn and utilize Pivot Tables, Vlookup, PMT, Conditionals. Available online / classroom mode at our Dehradun training centers.

Rs.6500 48% off Rs.12500

Free Excel & Analytics Demo Class Complimentary class with Certificate

Duration

Advance Excel is upto 2 Month Course

Instructor Led

Interact with real trainers to clear your doubts

Real Life Assignment

Learn-by-doing model for real-life problem-solving skills

Expert Faculties

Get trained by industry experts for in-depth learning experience

Certification

Get Digital and Physical course completion certificate

SYLLABUS Advance Excel

Essential Excel 18 Topics

  • Charts

  • Multicategory Chart

  • Static Transpose

  • Find Depreciation of an Asset

  • Logical Functions like IF, IF-Else

  • Text Functions like Find, Replace, Len, Right, Left, MID, Proper, Text, Trim

  • Lookup

  • Subtotal Function

  • Rank Function

  • Rand and Randbetween

  • Sumproduct

  • Choose

  • Format as table

  • Conditional formatting

  • Page setup & Print

  • Freeze Panes

  • Date & Time Functions like Edate, Now, Eomonth, Workday, Weekday,

  • Error Handling with ISBLANK, ISTEXT, ISERROR, ISNUMBER, IFERROR functions

  • Concatenate Function

  • Logical Functions like Nested IF, Complex IF-ELSE-IF, IFERROR, AND & OR

  • Dynamic Transpose

  • Criteria Based Functions: Sumif and sumifs, Countif and Countifs, Averageif and Averageifs functions

  • Advance Filters

  • Absolute, Relative & Mixed Reference

  • Advance Conditional Formatting

  • Index, Match function

  • Data Validation

  • Data validation with Dependent List

  • PMT function

  • PPMT and IPMT Function

  • What if Analysis (Scenario, Goal seek, Data Table, Forecast)

  • Pivot Table

  • Consolidate data Sheets

  • Dsum, Dmax, Dmin & Daverage

  • Vlookup Function

  • Double Vlookup Function

  • Advance Vlookup with Max-Min, Vlookup with IfError, Vlookup with Validation, Intersheet Vlookup with Referencing

  • Hlookup Function

  • How to Export Sheet into PDF

  • Basic Macros

  • Advance Charts(Donut Chart, Speedometer Chart, Trend Arrows, Target vs Actual, Scatter chart, Thermometer Chart, Gantt chart with conditional Forma

  • Protect worksheet & Formulas

  • Advance Conditional Formatting with Form Control

  • Triple VLookup

  • VLookup & HLookup with Match Function

  • Solver Function

  • Dynamic Offset with Sum & Average Function

  • Forecast Sheet

What you'll learn Advance Excel

  • Hands on experience to the excel with understanding of shortcuts
  • Functions explained in most logical and simplest manner
  • Suitable for beginners to advanced users ideal for users who learn faster when shown.
  • Use of Logical functions like IF Functions, Nested IFs, IF AND, IF OR from Basic IF to complex IF functions.
  • Become more creative, efficient and accurate & Fast in Excel
  • We are learning arrays formula from the basic level and unleashing their extreme advance side gradually.

Get Free Participation Certificate

Take a demo class & get the FREE Certificate

Upcoming Batches

  • JOIN NOW And Get 48% Scholarship

  • Friday 01-Nov-2024

    Upto 2 Month

    Classroom / Online

    Weekday & Weekend

  • Monday 04-Nov-2024

    Upto 2 Month

    Classroom / Online

    Weekday & Weekend

  • Tuesday 05-Nov-2024

    Upto 2 Month

    Classroom / Online

    Weekday & Weekend

  • Wednesday 06-Nov-2024

    Upto 2 Month

    Classroom / Online

    Weekday & Weekend

About Advance Excel Course in login

This course will give you a deep understanding of the advanced Excel formulas and functions that transform Excel from a basic spreadsheet program into a dynamic and powerful analytics tool. While most Excel courses focus on simply what each formula does, We  teach through hands-on, contextual examples designed to showcase why these formulas are awesome and how they can be applied in a number of ways. We will not train you to regurgitate functions and formula syntax; We will teach you how to think like Excel.

By the end of the course you'll be writing robust, elegant formulas from scratch, allowing you to: Easily build dynamic tools to filter, display and analyze your data, Create your own formula-based Excel formatting rules, Join datasets from multiple sources with VLOOKUP, HLOOKUP and INDEX & MATCH functions, Manipulate dates, times, text, and arrays and also Automate tedious and time-consuming tasks using cell formulas and functions in Excel.

Exam & Certification Advance Excel

An online verifiable certificate of completion will be issued based on your performance from ISPL Academy. Student would go through an online examination after completion of the course to evaluate the skills gathered during the course.

Competition is tough when applying for a job, having a proof of successful completion of the course is an effective way to stand out and succeed. Your certificate will give the trust to the employers that you are dedicated and have required skills to become a suitable employee for them.

ISPL Academy Certificate Sample

Excel & Analytics Alumni

Frequently Asked Questions

Advance Excel is a short term course of 4 weeks.

The fee of the course Advance Excel is Rs.3600/-

This course covers Introduction of Advance Excel, Mathematical Functions, Date & Time Function, Text Functions & Data Validation, Logical Functions, Other Functions, Pivot Table, Lookup & Reference Functions, Macros, Print & Protect.

Microsoft Excel is something that we work on in our daily life be it a student or an accountant or any other business professional. While Microsoft Excel is an irreplaceable part of the business field it is also widely used in other fields such as nonprofit organizations, hospitals, and educational institutions. Every one of us knows all the basic functions of Microsoft Excel but there are many advanced terms associated with it that not many are aware of. Advanced Excel today is the need of the hour and learning the skills of advanced excel can make you stand out among a big crowd of people.

Bulk Training for Corporates, Government and Institutions

Classroom Learning

GMS Road Dehradun 99974-11884

Tilak RoadDehradun 99974-11885

Start your own centre Become a Partner