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
• Linear Forecasting Techniques
• Excel Macro
--o Macro Security Overview
--o Recording and Using Custom Macro
--o Sample Macro: Convert Amount into Words Automatically
--o Sample Macro: Sort Excel Sheets/Worksheets
--o Sample Macro: Convert Text to Upper/Proper Case
--o Sample Macro: Creating a Worksheet Index
--o Sample Macro: Creating a Calendar to Insert Date
• Useful Functions:
--o IF, nested IF
--o Count, CountA, CountBlank
--o CountIF (CountIFs for Excel 2007)
--o SUM and Variation of SUM
--o SumIF (SumIFs for Excel 2007)
--o VLOOKUP, HLOOKUP
--o Text, Mid, Left, Right, Len
--o Match
--o Search, Find
--o Indirect
--o Index
• Mastering Date Times
--o Excel Date Concept
--o Date short-cuts
--o Determine a Future Date
--o Find the Difference Between Two Dates
--o Time Calculation
• Restrict and Validate Inputs and Custom Messaging
• Static Validation List
• Dependant Validation List
• Worksheet Locking, Protecting and Hiding
• Benefits of Using Names
• Using Hyperlink
• Conditional Formatting
• Absolute and Relative References
• Data Sorting
• Data Filtering
• Common Keyboard Shortcuts
![](Templates/"../images/bodyedge_tr.gif"width="2"){kind=small}
![](Templates/"../images/bodyedge_tl.gif"width="2"){kind=small}
