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.
•Solving Case-studies After Learning and Applying 31 ExcelTips
•Convert Amount into Words Automatically
•Operating Macros
• Using Names/Ranges
•Pivot Table • Excel Subtotals
•VLOOKUP Formula
• SumIF Function
• Advance CountIF Function
• Conditional Formatting
• Using Goal Seek
• Create Custom Excel Menu Items
• Sort Excel Sheets/Worksheets
•Convert Text to Upper/Proper Case
•Create a Worksheet Calendar
• Creating a Worksheet Index
•Input Validations by Range, List and Custom Message
•Find the Difference Between Two Dates with Parameters
• Embedding Objects
• Using Hyperlink
•Absolute and Relative References
•Linking Worksheet and Workbooks
•Data Sorting
• Data Filtering
• Common Keyboard Shortcuts
•Locking and Protecting Excel Worksheet
• Change Currency Symbol (Global and Local)
• Importing Text Data
• Joining Text of Different Cells
• Splitting Text of One Cell to Columns • And more…
![](Templates/"../images/bodyedge_tr.gif"width="2"){kind=small}
![](Templates/"../images/bodyedge_tl.gif"width="2"){kind=small}
