Be Master in Microsoft Excel from Beginner to Advanced

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

Course Fee - Rs. 3,999 /- 

                                   Enroll Now

 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


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

Be Master in Microsoft Excel from Beginner to Advanced  

Be Ready for upcoming Live 11 DAYS course

Course Fee - Rs. 3,999/-



CONNECT WITH US