Summary
Microsoft Excel is a rich and powerful tool, but learning how to take advantage of its features or transitioning to the latest version can feel daunting. For many Accounting and Finance professionals this can mean a lot of wasted time and frustration. Excel for Accounting & Finance Professionals aims to provide a quick and easy-to-use guide to help you get more out of Excel. Give our easy-to-follow tips and shortcuts a try and you'll be more productive in no time! To insure the maximum level of understanding when learning how to effectively use Excel, there are additional training materials (such as video clips and sample Excel files) available at http://trufflesoft.com/xl4pros. Need more help? We also have instructor-led online training and limited engagement consulting.

Chapter 1: Toolbar & Short Cuts - Minimize search time & speed up tasks

Chapter 2: Ranges & References - Personalize data points & tables to quickly retrieve information on demand

Chapter 3: Lookup - Fast and accurate ways to search key data from bulky data source

Chapter 4: Conditional Function - Turn unrefi ned records into intelligent information

Chapter 5: Filtering - Hone in records of key interest

Chapter 6: Pivot Table - Summarize data and do in-depth analysis

Chapter 7: Working with text value - Systematic ways to turn ordinary text values into more user defi ned values

Chapter 8: Working with Formulas - Simplify complex tasks via advance formulas

Chapter 9: Financial Calculation - Put away your fi nancial calculators. Excel can do a better job

Chapter 10: Working with graphs - Create visual representation of data

Chapter 11: Simple Marcos - Eliminate the monotony of doing same thing over and over