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:54
- 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): Pearson
- ISBN: 9780132378093
You might also like
video
Microsoft Excel 2010
In this Microsoft Excel 2010 tutorial video, veteran Infinite Skills trainer Guy Vaccaro introduces you to …
video
Advanced Microsoft Excel 2010
In this Advanced Excel 2010 training video, expert author Guy Vaccaro follows up his bestselling Beginners …
video
Microsoft Excel - Managing Multiple Worksheets
In this Microsoft Excel – Managing Multiple Worksheets training course, expert author Erin Olsen teaches you …
video
Excel 2016 For Dummies Enhancing & Sharing Data Course
Does enhancing and sharing data with Excel 2016 interest you? In just over a half an …