Western India Regional Council of
The Institute of Chartered Accountants of India

(Setup by an Act of Parliament)

Virtual Workshop on Excel

Fees: Member ₹2360                          Non Member ₹2950                         

Please Pay your Attention here: Separate Link will be sent for each day for Joining Webinar. Each day new Link will be shared on the email id submitted while carrying out registration. 

To ensure timely receipt of link, kindly: 1. White list email from wirc@icai.in /customercare goto webinar.com. 2. Check Spam Box. 3. Incase of non-receipt of link & technical difficulty write email with payment details on wircevents@icai.in 

Event Details

Event Date 23-01-2021 5:00 pm
Event End Date 29-01-2021 7:00 pm
CPE Credit Hrs No CPE

Object of Workshop: To get advanced Excel Knowledge and to automate office work with Excel for Audit, Tax, Compliances, Data analysis etc.

 

Topic

Speaker

23.01.2021: 05.00 pm to 07.00 pm

Day 1: Smart shortcuts, formatting formula and technique, graphical presentation: Conditional formatting, Justify, Painter, Paste values shortcut, Text breakup (Proper, trim, left, right, mid), copy titles, Sub - Total & Sparkline, Date formats, Special formats, Excel Maps, Quick analysis tool, 3D references, People graph, protect/lock, fill - series, find - constant and formula, insert - screenshot, hyperlink formula, create Emoji and replace with text.

CA. Vaibhav Doshi

24.01.2021: 05.00 pm to 07.00 pm

Day 2: Data management features (Validation tools, extraction and conversion tools and data modeling tools): Pivot table with Pivot slicer features and Excel table, recommended Pivots (A.I), Goal Seek, Scenario Manager, Data Table, Basic Forecasting, Flash Fill, data validation, remove duplicates, splitting data, sub totals, conversion of exported reports into Excel data, advanced filter, advanced transpose. CA. Vaibhav Doshi

25.01.2021: 05.00 pm to 07.00 pm

Day 3: Advanced formula Part 1: Concat formula instead of Concatenate - Show with Multiple rows and columns, TextJoin technique, match function with Lookup, V Lookup, H Lookup & Fuzzy Lookup, Xlookup, how to create barcode scanner, how to insert YouTube video in Excel CA. Vaibhav Doshi
 26.01.2021: 05.00 pm to 07.00 pm
Day 4: Advanced formula Part 2: Adjusted wildcard & nested V Lookup, use of IFS Formula instead of IF and nested IF formula, IF function with And/or, formula creation analysis along with navigations, SUMIFS instead of SUMIF, Macros CA. Vaibhav Doshi
27.01.2021: 05.00 pm to 07.00 pm
Day 5: Advanced features Part 3: Power Pivot (file - option - Add-ins) - Useful for reconciliation of inward register with GSTR 2A, Power query - useful for appending any number of sheets into one sheet), Data Types - real time web data reflection into excel with continue refresh option Viz. NSE/BSE stock price, Currency price etc., Data Geography CA. Vaibhav Doshi
28.01.2021: 05.00 pm to 07.00 pm
Day 6: Microsoft 365 features - Dynamic array functions: This feature allows formulas to return multiple results to a range of cells on the worksheet based on a single formula entered in one cell. This behavior is called "spilling" and results appear in a "spill range". It includes various formula – Filter, Randarray, Sequence, Sort, Sortby, Unique, XMATCH and Unique. Dynamic dashboard, informative dynamic charts will also be covered. CA. Vaibhav Doshi
 29.01.2021: 05.00 pm to 07.00 pm 
Day 7: Sharing of workbook and co-authoring (Legacy feature of Excel 365 and most useful during lockdown): Work together on the same excel sheet with two different users at different locations. Both users can work simultaneously in the same excel sheet (without any server). CA. Vaibhav Doshi
 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.