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): Que
- ISBN: 9780132378093
You might also like
video
5 Essential Communications Skills to Catapult Your Career
Developing great communication skills is a key to professional success. Communication skills have always been instrumental …
book
Designing Data-Intensive Applications
Data is at the center of many challenges in system design today. Difficult issues need to …
video
Data Analysis Fundamentals with Excel (Video)
7+ Hours of Video Instruction This video course takes you—the business user, business analyst, or data …
video
Project Management
The hands-on video guide to project management: master the entire project lifecycle in just hours! Description …