Explores the functions, commands, and techniques in Excel that
quickly restructure data, remove unwanted characters, convert
date data into the desired format, and prepare data for
efficient analysis. Shares easy-to-use database commands and
methods for maintaining an Excel database. Spells out the design
considerations and tools needed for creating a database in
Excel. Analyze and communicate the data in spreadsheets more
efficiently with charts in Excel. Use the data validation tools
in Excel to control how users can input data into workbooks and
ensure data is entered consistently and accurately. Shows
managers and executives how to assess their organization's data
effectively by applying statistical analysis techniques. Offers
solutions for optimizing the use of dates and times in Excel
2007. Introduces object-oriented programming and shows how to
automate routine tasks and provide custom functionality to
enhance the features in Excel. Shows business owners and
managers how to use Excel to create useful b