One Day Workshop on Advance Excel
One Day Workshop on Advance Excel (Physical)
Organised by Pune Branch of WIRC of ICAI
Day & Date : - Sunday, 14th May, 2023
Time :- 9.00 am to 5.00 pm
CPE :-6 hrs.
Topics to be covered for Batch 1 (Lab No. 1) |
|||
Sr. No. |
Time |
Topics |
Faculty |
| Registration & Breakfast: 9.00am to 9.30am | |||
| 1 | 9:30 AM to 11:30 AM | First Part: Basics Excel - Working with some of the Basics in Excel - Working with Logical and Summarisation functions - Different Types of referencing - Dealing with Different Date Formats & advance Date Functions - Unlocking dynamic formulas with LOOKUP’s (VLOOKUP with match, Index, Index with indirect and match, Xlookup) - Mastering one of the most popular tools, PIVOT Table - Advanced Filter application, criteria based filtering with AND & OR Logic |
Mrs. Manju Mittal |
| Tea Break: 11:30 AM to 11:45 AM | |||
| 2 | 11:45 AM to 1:30 PM | Second Part: Power Query - Extract Transform Load (ETL) - Importing data, Transform Data, Load Data - Inbuilt Transformation – Columns, Rows - Inbuilt transformation – Dates, text, numbers - Append Multiple CSV files from a folder - Append Multiple Excel Tables / sheets - Append Multiple Excel files from folder - Merging data from two tables |
CA. Abhay Gadiya |
| Lunch Break: 1:30 PM to 2:30 PM | |||
| 3 | 2:30 PM to 4:30 PM | Third Part: Data Management, Formatting Technique & Graphical Presentation - Smart shortcuts, formatting formula and technique, graphical presentation: Conditional formatting, Sparkline, Justify, Painter, People graph, Excel Maps - Data management features (Validation tools, extraction and conversion tools and data modeling tools): Pivot Slicers, Data Table, recommended Pivots (A.I) (Pivot Tables), Basic Forecasting, Flash Fill, Concat formula instead of Concatenate - Show with Multiple rows and columns, TextJoin technique, use of IFS Formula instead of IF and nested IF formula, how to create barcode scanner, how to insert YouTube video in Excel - DEA: 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. - 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. |
CA. Vaibhav Doshi |
| Tea Break: 4:30 PM to 5 PM | |||
Topics to be covered for Batch 2 (Lab No. 2) |
|||
| Sr. No. | Time | Topics | Faculty |
| Registration & Breakfast: 9.00am to 9.30am | |||
| 1 | 9:30 AM to 11:30 AM | First Part: Data Management, Formatting Technique & Graphical Presentation - Smart shortcuts, formatting formula and technique, graphical presentation: Conditional formatting, Sparkline, Justify, Painter, People graph, Excel Maps - Data management features (Validation tools, extraction and conversion tools and data modeling tools): Pivot Slicers, Data Table, recommended Pivots (A.I) (Pivot Tables), Basic Forecasting, Flash Fill, Concat formula instead of Concatenate - Show with Multiple rows and columns, TextJoin technique, use of IFS Formula instead of IF and nested IF formula, how to create barcode scanner, how to insert YouTube video in Excel - DEA: 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. - 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. |
CA. Vaibhav Doshi |
| Tea Break: 11:30 AM to 11:45 AM | |||
| 2 | 11:45 AM to 1:30 PM | Second Part: Basics Excel - Working with some of the Basics in Excel - Working with Logical and Summarisation functions - Different Types of referencing - Dealing with Different Date Formats & advance Date Functions - Unlocking dynamic formulas with LOOKUP’s (VLOOKUP with match, Index, Index with indirect and match, Xlookup) - Mastering one of the most popular tools, PIVOT Table - Advanced Filter application, criteria based filtering with AND & OR Logic |
Mrs. Manju Mittal |
| Lunch Break: 1:30 PM to 2:30 PM | |||
| 3 | 2:30 PM to 4:30 PM | Third Part: Power Query - Extract Transform Load (ETL) - Importing data, Transform Data, Load Data - Inbuilt Transformation – Columns, Rows - Inbuilt transformation – Dates, text, numbers - Append Multiple CSV files from a folder - Append Multiple Excel Tables / sheets - Append Multiple Excel files from folder - Merging data from two tables |
CA. Abhay Gadiya |
| Tea Break: 4:30 PM to 5 PM | |||
-
Limited seats on first cum first serve basis only
-
No Fees for Saturday Series Members
Event Information
| Event Date | 14-05-2023 9:00 am |
| Event End Date | 14-05-2023 5:00 pm |
| Cut off date | 14-05-2023 7:00 am |
| Individual Price | Rs. 800/- Plus GST |
| CPE Credit Hrs | 6 Hrs. |
