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.
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.
Shares simple and powerful tips for making Excel spreadsheet data readable and understandable.
Explains how macros can be used to automate tasks in Excel and walks through the process of creating and running simple macros.
Excel tutorials that show how to share data between multiple worksheets and workbooks, including tips for adding, moving, and navigating worksheets and workbooks efficiently.
Provides formula examples and demystifies some of the nearly 400 functions in Excel.
Shares tips and shortcuts to increase efficiency and get the full power out of Excel 2010.
Offers solutions for optimizing the use of dates and times in Excel 2010.