About Workshop
Microsoft Excel is the most commonly used spreadsheet application in the world. Excel can play a crucial part in your business, and is essential for producing accurate numeric data. The vast majority of businesses use Microsoft Excel every day to produce accounting and financial reports, budgets, and many more crucial numeric data tasks, but few appreciate the extent of the features and functions within the software. This course will enable you to maximize the potential of the powerful Microsoft Excel software to produce more professional business information. The course covers some useful tips of Microsoft Excel commonly used in the workplace.
Workshop topics to be covered:
• Pivot Table
• Excel Date
---o Underlying Date Concept
---o Date short-cuts
---o Essential Date Functions
---o Difference Between Two Dates
---o Determine a future date
• Absolute and Relative Cell Referencing (use of $ sign)
• Creating/Editing/Using Excel Names
• Validations List
---o Static Validation List
---o Dependant Validation list
• Excel Worksheet Locking & Protecting
• IF() Function
• Excel Errors:
o Types of Excel Error
o Some Useful Functions
• CountIFs(),SUMIFs()
• Concatenation
• Text() Function
• VLOOKUP Formula
• Using Goal Seek
• Embedding Objects
• Hyperlink
• Conditional Formatting
• Using Comments
• Data Sorting
• Data Filtering
• Text to Columns
• Freeze panes
• Macro
---o Excel Macro Overview
---o Convert Amount into Words Automatically
---o Convert Text to Upper/Proper Case
...and Some Other Tips
![](Templates/"../images/bodyedge_tr.gif"width="2"){kind=small}
![](Templates/"../images/bodyedge_tl.gif"width="2"){kind=small}
