Excel - Basic To Advance

 Rs. 4,999 /- 

Buy Now

 Description 


πŸ”Ή 30+ Hours Of Video Content 

πŸ”Ή INTRODUCTORY & BASIC LEVEL EXCEL      

πŸ”Ή Intermediate Level Excel 

πŸ”Ή Advanced Level Excel      

πŸ”Ή Pro Level Excel


β—Ύ Master Microsoft Excel and many of its advanced features

β—Ύ Become one of the top Excel users On your team

β—Ύ Carry out regular tasks faster than ever before



πŸ‘‰ Beginner's guide to excel

πŸ‘‰ Excel sheet tips

πŸ‘‰ Excel powerful Short Cut Keys

πŸ‘‰ Creating Your Own Shortcut keys 

πŸ‘‰ 3D Formulae In Excel

πŸ‘‰ Pro tips to Use Smart Copy/paste Features

πŸ‘‰ Complete Use of Paste special Option, Go To Command, Advanced Sorting

πŸ‘‰ Different Uses of Flash Fill

πŸ‘‰ Conditional Formatting- Data Bars, ICON Sets, Duplicates, Use of Formulas

πŸ‘‰ Data Filter/Group/Subtotal - Single click filtering

πŸ‘‰ Complete Data Validation, Data Consolidation

πŸ‘‰ MIS Reports

πŸ‘‰ Financial Functions To Calculate EMI

πŸ‘‰ Excel DATE FORMULAS (99% Excel MIS Reports need these Date Formulae)

πŸ‘‰ Unpivot Data with Power Query

πŸ‘‰ Easiest Way To Merge Data Using POWER QUERY

πŸ‘‰ Difference between ABSOLUTE REFERENCE and RELATIVE REFERENCE

πŸ‘‰ Text function - REPT, LEN, FIND, LEFT, RIGHT, TEXT, TRIM, MID, SEARCH, ETC

πŸ‘‰ Logical function - IF, NESTED IFS, IFS

πŸ‘‰ Statistical Function - AVERAGE, AVERAGEIFS, COUNT, COUNTA, COUNTBLANK

πŸ‘‰ Math Function- ROUND, CEILING, FLOOR, SUMIFS Etc. 

πŸ‘‰ Date and time function -EOMONTH, EDATE, Workday, Date, Month, Year Etc.

πŸ‘‰ LookUps – Use Of VLOOKUP, Dynamic Lookups, Lookup , Multi VLookups

πŸ‘‰ Magical Xlookup Formula

πŸ‘‰ MOST POWERFUL FORMULA of Excel 365 - FILTER

πŸ‘‰ New & Advanced Formulas: TextJoin, Sequence, Unique, Sort, XLookup

πŸ‘‰ Full concept For Creating pivot tables, Changing and updating data range

πŸ‘‰ Pivot Table: Basic Concepts and Pre-Condition

πŸ‘‰ Macro Overview

πŸ‘‰ Create Weekly Report, Monthly Report, yearly Report, quarterly Report

πŸ‘‰ Ageing Analysis

πŸ‘‰ Multiple reports with Single Click

πŸ‘‰ Pivot Charts

πŸ‘‰ Slicer, Time Lines

πŸ‘‰ Dash Boards - Practical Business Scenarios

πŸ‘‰ Goal Seek, Watch Window

πŸ‘‰ Protection of Sheet, Cell, Workbook, File

πŸ‘‰ In Between Lots of Exercises

πŸ‘‰ AND MUCH MORE ...





 MORE ADVANTAGES


βœ… 90 DAYS ACCESS TO RECORDING AFTER EACH LIVE CLASS FOR REVISION 

βœ… Access to a Professional Trainer who is CA/CS with 25+ years of Excel Training

βœ… Create dynamic reports by mastering EXCEL

βœ… Become a successful EXCEL EXPERT in no time – if you follow the course fully



Who this course is for 

πŸ”ΊPeople who want a successful career in Excel

πŸ”ΊPeople who are ambitious and want to learn faster than their peers



By completing this course, you will:

πŸ”ΈBe able to work comfortably with Microsoft Excel and many of its advanced features

πŸ”ΈBecome one of the top Excel users in your team

πŸ”ΈBe much quicker at carrying out regular tasks





Step 1: Signup

Click on 'Enroll Now' button and do Signup first.


Step 2: Payment

After Signing up go for payment method.


Step 3:  Your Registration is successfully done. Now you are eligible for FULL 11 DAYS course