2 Days Workshop on Advance Excel (Physical)
Fees Includes Breakfast & Lunch
Faculties : Ms. Manju Mittal & Ms. Jayashree Tawari
Venue : 3rd Floor, ITT Lab, ICAI Bhawan, Bibwewadi
Content :-
- Working with some of the Basics in Excel
- Working with Text, Logical and Summarisation functions
- Different Types of referencing
- Dealing with Different Date Formats & advance Date Functions
- Array 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, criteriabased filtering with AND & OR Logic.
- Advanced Conditional Formatting with data Bars, Icon sets and Formula as well.
- Restriction of type of data on various part of worksheet using formula’s in Data Validation
- Power Pivot (Create pivot from multiple tables)
- Introduction to Power Query
- Append Multiple CSV files from a folder in 3 clicks
- Append Multiple Excel Tables in 3 clicks
- Append Multiple Excel files from folder in few steps
- Append Multiple PDF files from a folder in few steps.
- Merging data from two tables in Excel
- Merging data from two Excel files in
- Dashboards using different type of controls
At the end 15-20 mins specially for queries
Event Information
Event Date | 12-11-2022 10:00 am |
Event End Date | 13-11-2022 5:00 pm |
Cut off date | 12-11-2022 8:00 am |
Available place | 0 |
Individual Price | Rs. 1500/- Plus GST for Both Days |
CPE Credit Hrs | 12 Hrs. |