Master Class on Advanced Functions of Microsoft/Office 365 

Course Fee - INR 1,000 /- only

Why it's important!

Microsoft is aggressively planning to move almost all its users to subscription based version of Microsoft 365 where they have new powerful calculation engine and other functions, such as XLOOKUP /UNIQUE /FILTER /SORT /SEQUENCE /POWER QUERY etc. They are immensely helpful to automate our data more efficiently and accurately. Each of these functions is a great boon for all Excel Enthusiasts. 

INTRODUCTION AND
COURSE CURRICULUM

MICROSOFT/OFFICE 365 the latest and most recommended version of Excel is filled with tons of New Functions/Features. These are going to change our working tremendously and will help us to automate tasks in our spreadsheets. Unfortunately, many of us haven't explored what it has to offer. Even most of the advanced users of Excel continue working by the old "manual" way, or the "complex" way with difficult formulas of older versions. 

Advanced Functions of Office 365
  • Day 1
  • Day 2
Downloadable Working Files
  • Office 365 Working File
  • Xlookup Working File
  • Day 2 Working File

Who Should Attend : All Excel enthusiasts who want to be Excel Pro and want to automate their processes.

Prerequisite : An average knowledge of MS Excel, Basic understanding of Excel Pivot Tables and Excel Formulas will be an added advantage.

Important Note: This course is designed for Windows users having Microsoft 365 version of Excel. For Power Query you can work in Excel 2016 and Excel 2019 too. In Excel 2013, Power Query can be installed as an add-in from Microsoft site, but Microsoft 365 is recommended  should have Microsoft 365.

Salient Features of the Webinar

👉 Understanding New Functions of Microsoft 365 with Business Scenarios         

  • SEQUENCE : Create Sequece of Data with pre logic on any Matrix with single cell formula  
  • XLOOKUP : 10 Times powerful than VLOOKUP, Left or Right any side Lookup, No need of HLOOKUP, IFERROR, INDEX/MATCH                               
  • UNIQUE: Dynamically create Unique list of Data 
  • SORT : Dynamically Sort data in any order 
  • SORTBY : Sorting Data based on other Columns 
  • FILTER : Automate your reports with Filter without Refresh on Realtime basis.  

  • 👉 Unpivot Columns with in seconds from Power Query, which can take hours/days without power query.

    👉  Replace complex Excel formulas with a click of a button.

    👉 How to perform common data cleansing activities with Power Query

    👉 Consolidate data from all files in a folder

    👉  Quickly get and update data from the web, like share prices, on real time basis

    👉 Power Query can handle Millions of rows very efficiently without making file size bigger.

    👉 Create an interactive Excel Dashboard with Power Query, Pivot Tables and slicers

    👉Some interesting Business Cases     

         1. Create Dynamic Drop Downs in multiple cells which change as we type     

         2. Create Realtime Dashboard without Pivot 

         3. Import Data from Website 

         4. Solution to lots of other business problems which we face in our day to day work.     

    👉  Q&A

    And these are just a few examples of what it can do! On top of this, your actions are recorded so whenever you get new data, all you have to do is click Refresh!

    Guess what? You can apply ALL the knowledge you learn in this course to Power BI as well!

    MORE PERKS 

    CERTIFICATION 
    Obtain a digital certificate for completing this course

    WORKING FILES
    Full solution ready to use Utility/Templates. 

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

    INTERACTIVE Q/A
    Get answers to all your queries

    CONNECT WITH US