Special Webinar Series on Advance & 365 Excel in India for the First time

Connect Easy Presenting

Special Webinar Series on Advance & 365 Excel in India for the First time

There is is misconception that Microsoft 365 is very costly. However, there are many plans offered by Microsoft according to the usage and firm size which is very cost effective.

1st to 7th Sept.

Tuesday to Monday

6.30 pm to 8.00 pm

E- Participation Certificate & Practice File will be provided to all Participants.

Details -

http://tiny.cc/Advance365excel

Fees : Early Bird Rs. 700 on or before 28th Aug., 2020 thereafter Rs. 1000

Day 1: Smart shortcuts, formatting formula and technique, graphical presentation.

Day 2: Data management features (Validation tools, extraction and conversion tools and data modeling tools).

Day 3: Lookup Learnings: Concat, Textjoin, VLookup, HLookup, Fuzzy Lookup, XLookup and Nested lookups

Day 4: Advanced formula: Wildcraft, IFS instead of old IF, SUMIFS instead of old SUMIF, OR-AND-IFS, Navigations, Macros

Day 5: Power features: Power Pivot, Power Query, Data types

Day 6: Excel 365 - How to register for Excel 365, discussion of various plans, Dynamic array functions: Filter, Sortby, XMatch etc.

Day 7:

Sharing of workbook and co-authoring (Legacy feature of Excel 365 and most useful during lockdown):

Manage your own portfolio with live stock Market data: Real time web data reflection into excel with continue refresh option Viz. NSE/BSE stock price. Analyse stock history with various data analysis graph.

IDEA: Excel will analyze your data and return interesting visuals about it in a task pane. If you are interested in more specific information, you can enter a question in the query box and Excel will use Artificial Intelligence to answer the same.

Microsoft 365 in Mobile application: Convert image into auto written text tables in excel, convert image to auto written text in word, Sign PDF files, dictate though mike to auto write text in word and many more.

Faculty : CA Vaibhav Doshi, with 8 plus years of Experience in Excel training.

To Your Success.