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:
Data Table
Pivot Table
Macro
• Convert Amount into Words Automatically
• Excel Security Protection (Workbook Security, Macro Security)
Excel Worksheet Locking, Protecting and Hiding
Dates
• Excel Date Concept
• Determine a future date
• Date short-cuts
• Essential date functions
• Find the Difference Between Two Dates
VLOOKUP formula
Conditional Formatting
Using Names
Absolute and Relative References (Use of $ Sign)
Static validation list
Dependant validation list or dropdown pick list
Data Sorting
Data Filtering
Variation of SUM ()functions
SUM IFs ()
Count IFs (),Count (),Count A (),Count Blank ()
Text () Function
Using Goal Seek
Concatenation
Text to Columns
Freeze panes
Types of Excel Error
Error handling functions in Excel
![](Templates/"../images/bodyedge_tr.gif"width="2"){kind=small}
![](Templates/"../images/bodyedge_tl.gif"width="2"){kind=small}
