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