Excel Training(Index Error-handlers &TEXT Functions)Series 2
- Course provided by Udemy
- Study type: Online
- Starts: Anytime
- Price: See latest price on Udemy
- Take a deep dive into learning most used and versatile functions in excel like IFERROR, ISERROR, MID LEFT RIGHT INDEX MATCH.
- Not only know them individually but do see their combinations with one another, i am discussing real projects also so that you can get the real feel about their use practically.
- Classwork files with couple of amazing assignments are available for you. These are mostly adance level questions to give you a great boost in excel
- if you have not seen SERIES-1 where we studied VLOOKUP , MATCH and TRIM functions please do so. If you know these functions and their combinations then you may ignore it.
- You will be able to learn index, match, mid, left, right ,find , search functions,
- Advantages of using index over Vlookup function
- Index with Match - Why and how it can be done
- Basic INDEX using cell referencing and dynamic super advance index using two MATCH functions
- Extract the cell values from any position using MID,LEFT,RIGHT Functions
- Which is better option . Find or Search function. Explained in detail
- How to use these functions together and make a complex formula .
- Use of Find in Find and making it super advance function.
- Assignments(Super Advance) and Classwork files for you
- Online support 24*7 to answer your questions