Excel Data Analysis: Your visual blueprint for creating and analyzing data, charts and PivotTables - Softcover

Über die Autorin bzw. den Autor

Denise Etheridge (Burlington, NJ) is a certified public accountant as well as the president and founder of BayCon Group, Inc. She publishes Web sites, provides consulting services on accounting-related software, teaches college-level computer and accounting courses, and has authored or coauthored two computer related books: Flash ActionScript: Your visual blueprint for creating Flash-enhanced Web sites. In addition, she authored Excel 2007 Visual Quick Tips and Excel 2007 Top 100 Simplified Tips and Tricks. Denise has trained and assisted clients with the implementation of accounting-related software since 1985. Stanford University and the United States House of Representatives are among her former clients. Prior to founding BayCon Group, she spent two years working for Oracle Corporation as an Oracle Financials software consultant.

Von der hinteren Coverseite

Welcome to the only guidebook series that takes a visual approach to professional-level computer topics. Open the book and you'll discover step-by-step screen shots that demonstrate over 190 key Excel data analysis techniques, including:

• Using Web-based applications in Excel

• Creating formulas and using functions

• Calculating interest rates and depreciation

• Working with statistical functions

• Using database functions

• Creating PivotTables and using Slicer

• Performing "what-if" analysis

• Automating Excel with macros

• Adding illustrations to worksheets

• Customizing the Ribbon

• High-resolution screen shots demonstrate each task

• Succinct explanations walk you through step by step

• Two-page lessons break big topics into bite-sized modules

• "Apply It" and "Extra" sidebars highlight useful tips