About Workshop
The course combines theory and practice by mixing lectures and exercises throughout the session(s). Through in class, participants will have the opportunity to put into practice the techniques introduced in the course.
Workshop topics to be covered:
3-D Formula
• Consolidating Excel Data with Case Studies
• Pivot Table with Case Studies
• Locking and Protecting Excel Worksheet
• Input Validations and Custom Messages
• Overview of Macros and Excel Security
• Macro for Converting Amount into Words (Version:2)
• Macro for Sorting Excel Sheets/Worksheets
• Macro for Converting Text to Upper/Proper Case
• Macro for Creating a Worksheet Index
• Absolute and Relative Cell References
• Linking Worksheet and Workbooks
• Conditional Formatting
• Find the Difference Between Two Dates with Options
• Using Hyperlink: Linking Object with Object
• Data AutoFiltering
• Useful Functions :If, SumIF, CountIF, EXACT, VLOOKUP
![](Templates/"../images/bodyedge_tr.gif"width="2"){kind=small}
![](Templates/"../images/bodyedge_tl.gif"width="2"){kind=small}
