Description 

"Topics often ignored in other advanced online programs have been included"

◾Microsoft Excel all in One Package :- This Microsoft Excel course combines 4 different courses

      🔹 An Introduction and Basics to 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 in your team

◾Carry out regular tasks faster than ever before

◾Become a proficient user able to work with Excel functions, pivot tables, Power Query, visualizations, and advanced features of Excel 365

 WHAT YOU WILL LEARN :-

👉 Beginner's guide to excel

_{👉Excel sheet tips}

_{👉 Excel powerful Short Cut Keys}

_{👉 Creating own short cut keys} 

 _{👉3D Formulae In Excel}

_{👉 Pro tips to Use Smart copy/paste Features}

_{👉 Some Most Used  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}

_{👉Understand the difference between ABSOLUTE REFERENCE and RELATIVE REFERENCE}

_{👉 Text function - REPT, LEN, FIND, LEFT, RIGHT, TEXT, TRIM, MID, SEARCH, SUBSTITUTE, CONCAT, TEXT JOIN ETC}

 _{👉 Logical function - IF, NESTED IFS, IFS}

_{👉 Statistical function -AVERAGE, AVERAGEIFS, COUNT, COUNTA, COUNTBLANK, COUNTIFS}

_{👉 Math Function- ROUND, CEILING, FLOOR, SUMIFS Etc.} 

_{👉 Date and time function -EOMONTH, EDATE, Workday, Network day, Date, Month, Year Etc.}

_{👉 LookUps – Use Of VLOOKUP On Large Data, Dynamic Lookups, Lookup from Left Side, Multi VLookups}

_{👉Magical Xlookup Formula}

_{👉MOST POWERFUL FORMULA of Excel 365 - FILTER}

_{👉 Advanced and New Formulas of Office 365: TextJoin, Sequence, Unique, Sort, XLookup}

_{👉 Full concept For Creating pivot tables, Pivot tables options Changing and updating data range}

_{👉Pivot tables : 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 Lot of Exercises}

 _{👉 AND MANY MANY MORE .......}

_{👉 Q&A}

 MORE ADVANTAGES

✅ 90 Days Access to Recording after each Live Class for revision

_{✅Access to a Professional Trainer who is CA/CS with 28+ years of Excel Training
✅Create dynamic reports by mastering most used User Friendly software EXCEL
✅IMPRESS your boss by unlocking dynamic formulas of Excel 365
✅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

MORE PERKS

CERTIFICATION
Obtain a digital certificate for completing this course

WORKING FILES
Get access to the working and business solution files

90 DAYS ACCESS
Get access to the webinar recording for 3 months

INTERACTIVE Q/A
Get answers to all your queries

Be Master in Microsoft Excel from Beginner to Advanced  

Be Ready for upcoming Live 11 DAYS course

Course Fee - Rs. 3,999/-