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:
• Forecasting and Regression Analysis
• Excel Macro Security
• Macro: Recording and Using
• Macro with VBA: Convert Amount into Words Automatically
• Macro with VBA: Sort Excel Sheets/Worksheets
• Macro with VBA: Convert Text to Upper/Proper Case
• Macro with VBA: Creating a Worksheet Index
• Useful Functions:
-If, nested If
-CountIF
-SUMIF
-VLOOKUP
• Input Validations and Custom Messaging
• Excel Worksheet Protecting and Hiding
• Using Names
• Drop down pick list
• Using Hyperlink
• Conditional Formatting
• Absolute and Relative References
• Common Keyboard Shortcuts
![](Templates/"../images/bodyedge_tr.gif"width="2"){kind=small}
![](Templates/"../images/bodyedge_tl.gif"width="2"){kind=small}
