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
Advance Excel 30 Topics
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
-
Wednesday 24-Apr-2024 -
Thursday 25-Apr-2024 -
Friday 26-Apr-2024 -
Monday 29-Apr-2024
About Advance Excel Course in
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.
Excel & Analytics Alumni
Frequently Asked Questions
What is the duration of the course Advance Excel?
Advance Excel is a short term course of 4 weeks.
What is the fee of the course Advance Excel?
The fee of the course Advance Excel is Rs.3600/-
What topics are covered in the course Advance Excel?
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.
What is Advance Excel?
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.