Video description
Using Microsoft Excel 2010brings you over 45 media elements detailing everything from getting familiar with the Excel interface and accessing the Excel Web App to using SmartArt and creating macros. Watching this media is the fastest way to get comfortable with the newest version of Microsoft Excel. Topics covered include signing up for a Windows Live ID, converting formulas to values, using Format Painter, using conditional formatting, using Goal Seek to return a value, using the AutoSum feature, using the Quick Sort buttons, using the search function to filter for specific dates, linking SmartArt to cells, recording a macro using relative referencing, and much, much more!
Table of contents
- Chapter 1: Getting to Know the Excel Interface
- Chapter 2: Introducing the Excel Web App
- Chapter 3: Entering Data in Excel
- Chapter 4: Data Formatting
- Chapter 5: Using Formulas
- Chapter 6: Using Functions
- Chapter 7: Sorting
-
Chapter 8: Filtering and Consolidating Data
- SHOW ME Media 8.1—Using the Search Function to Include and Exclude Items in the Filtering Listing 00:00:55
- SHOW ME Media 8.2—Using the Search Function to Filter for Specific Dates 00:00:57
- SHOW ME Media 8.3—Using the Advanced Filter with Various Criteria 00:01:47
- TELL ME MORE Media 8.4—Finding Duplicates 00:01:39
- Chapter 9: Subtotals and Grouping
- Chapter 10: Pivot Tables
- Chapter 11: Creating Charts
- Chapter 12: SmartArt, WordArt, and Pictures
- Chapter 13: Macros and UDFs
Product information
- Title: Using Microsoft Excel 2010
- Author(s):
- Release date: August 2010
- Publisher(s): Que
- ISBN: 9780132378093
You might also like
video
Microsoft Word 2013
In this Microsoft Word 2013 training course, expert trainer Guy Vaccaro teaches you how to use …
video
Microsoft Excel 2013
In this Microsoft Excel 2013 training course, veteran trainer Guy Vaccaro takes you through the basics …
video
Visual Basic for Microsoft Excel
In this VB for Excel training course, you will learn how to apply the VBA programming …
video
Microsoft Excel 2010
In this Microsoft Excel 2010 tutorial video, veteran Infinite Skills trainer Guy Vaccaro introduces you to …