At the completion of this course, participants should be able to:
• Describe the basic structure of a Microsoft® Excel formula
• Identify the purpose of Worksheet functions and how they are used
• Utilize ranges of data for improved organization and calculation functionality
• Transform existing data into a chart using the available styles and formats
• Understand the proper methods for sorting data
Description:
This course is the second of a two part tutorial further introducing the business and organizational application of Microsoft ® Excel 2010. It provides instruction on the appropriate design and use of the formula. Techniques on how to calculate large amounts of data through the process of worksheet functions are offered. Methods of auditing and resolving computational errors are discussed along with techniques for making the most of your time. Finally, methods of converting spreadsheets into tables and charts are reviewed with an explanation of Excel 2010’s newest feature: Sparklines.
Keywords: Microsoft, Office, Excel, 2010, MS Excel 2010, MS Office, Software, Excel, PowerPoint, Word
