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.
These Excel tutorials offer 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.
Learn to analyze and communicate the data in spreadsheets more efficiently with charts in these Excel tutorials.
Use the data validation tools in Excel to control how users can input data into workbooks and ensure data is entered consistently and accurately.
Offers solutions for optimizing the use of dates and times in Excel 2007.
Shows how to move and copy data to multiple worksheets and gives tips for efficiently adding, moving, and navigating worksheets and workbooks in Excel.
Demonstrates common tasks for which macros are used, and walks through the process of creating and running simple macros in Excel 2007.
Simple and powerful techniques for making data readable and understandable, including keyboard shortcuts and tips for smoother formatting.
Demystifies some of the most useful and challenging of the 300+ formulas and functions in Excel and shows how to put them to their best use.