Power Excel 2010 with MrExcel LiveLessons (Video Training)

( 1 )

Overview

For anyone who wants to master Microsoft Excel 2010 fast–from novices to experienced power users!

Power Excel 2010 with MrExcel teaches the most sophisticated features and techniques visually: Just watch! You’ll master high-powered Microsoft Excel 2010 skills at your own pace–and get specific answers and solutions immediately, whenever you need them!

These practical videos simplify powerful features including Pivot Tables, Subtotals, Charting, ...

See more details below
$35.99
BN.com price
(Save 10%)$39.99 List Price

Pick Up In Store

Reserve and pick up in 60 minutes at your local store

Other sellers (Other Format)
  • All (7) from $23.02   
  • New (5) from $24.35   
  • Used (2) from $23.02   
Sending request ...

Overview

For anyone who wants to master Microsoft Excel 2010 fast–from novices to experienced power users!

Power Excel 2010 with MrExcel teaches the most sophisticated features and techniques visually: Just watch! You’ll master high-powered Microsoft Excel 2010 skills at your own pace–and get specific answers and solutions immediately, whenever you need them!

These practical videos simplify powerful features including Pivot Tables, Subtotals, Charting, Formulas, Data Visualizations, Consolidations, PowerPivot, Goal Seek, and Web Queries! Get more done faster with customized workbooks and keyboard shortcuts…control and analyze data more effectively… communicate visually with new charting tools and SmartArt…and plenty more!

Bill Jelen, Excel MVP and host of MrExcel.com, has been using spreadsheets since 1985. A long-time regular guest on Call for Help with Leo Laporte, he has produced more than 1,200 episodes of his daily video podcast, “Learn Excel from MrExcel.” His 30 books include Microsoft Excel 2010 In Depth, Charts and Graphs: Microsoft Excel 2010, and PowerPivot for the Data Analyst: Microsoft Excel 2010. He writes the monthly Excel column for Strategic Finance magazine, and leads half-day Power Excel seminars nationwide.

Looking for a better way to master today’s rapidly changing technologies? Want expert help, but don’t have the time or energy to read a book? Can’t find classroom training worth the money? Discover LiveLessons: self-paced, personal video instruction from the world’s leading experts. LiveLessons are DVD video courses organized into bite-sized, self-contained sessions–you’ll learn key skills in as little as five minutes!

Read More Show Less

Product Details

  • ISBN-13: 9780789743930
  • Publisher: Que
  • Publication date: 10/21/2010
  • Series: LiveLessons Series
  • Product dimensions: 5.40 (w) x 7.60 (h) x 1.40 (d)

Meet the Author

Bill Jelen is MrExcel, as well as an Excel MVP. He is an accomplished Excel author and the principal behind the leading Excel website, MrExcel.com. As an Excel consultant, he has written Excel VBA solutions for hundreds of clients around the English-speaking world. His website hosts more than 12 million page views annually. Jelen is author of the five-star reviewed Guerilla Data Analysis Using Microsoft Excel, co-author of VBA and Macros for Microsoft Excel, co-author of Pivot Table Data Crunching, and author of Learn Excel From Mr. Excel.
Read More Show Less

Table of Contents

Part 1 Excel Interface
1 - Ribbon, QAT, Mini Toolbar, Live Preview
2 - Finding Icons
3 - Customizing the Ribbon
4 - Backstage View
5 - Recent Documents
6 - Keyboard Shortcuts
7 - Zoom Slider and Page Layout
8 - Unlocking the Big Grid
9 - Data Entry Tricks
10 - Customize All Future Workbooks
11 - Copy Worksheets
12 - Change All Worksheets
13 - Arranging Windows
14 - Saving Workbook to PDF
15 - Saving Workbook to Excel Web App
Part 2 Text Formulas
16 - Drag the Fill Handle
17 - Create Your Own Series
18 - Joining Text
19 - Rapid Formula Copy
20 - Convert to Proper Case
21 - Joining Dates
22 - Formulas to Values
23 - Breaking Apart Text
24 - Parsing Fixed Width
Part 3 Formulas
25 - AutoSum Tricks
26 - Formula Auditing
27 - Three Ways of Entering Formulas
28 - Relative Versus Absolute Formulas
29 - Tables and Table Formulas
30 - Discovering Functions
31 - Goal Seek
32 - IF Formulas
33 - VLOOKUP
34 - Date and Time
Part 4 Sorting & Filtering
35 - Data Preparation
36 - One-Click Sorting
37 - Sorting by Color
38 - Sorting by Weekday
39 - Rearranging Columns
40 - Filter by Selection
41 - Other ways to Filter
42 - Remove Duplicates
Part 5 Subtotals
43 - Subtotals
44 - Collapsing Subtotals
45 - Copy Subtotals
46 - Formatting Subtotals
47 - Sorting Subtotals
48 - Changing Sum to Count in 1 column
49 - Data Consolidate
50 - Easy-XL
Part 6 Pivot Tables
51 - Creating a Pivot Table
52 - Changing a Pivot Table
53 - Pivot Gotchas
54 - Pivot Formatting
55 - Drill Down
56 - Pivot Calculations
57 - Summarizing Dates
58 - Pivot Sorting
59 - Filtering Row Fields
60 - Top 10 Report
61 - Filtering a Pivot Table with Slicers
62 - Slicers on Two Pivot Tables
63 - 50 Reports in 5 Seconds
64 - Using GetPivotData
Part 7 PowerPivot
65 - Getting Data into PowerPivot
66 - Adding Calculations in PowerPivot
67 - Linking Tables in PowerPivot
68 - Creating Pivot Table in PowerPivot
69 - Sorting in PowerPivot
Part 8 Charting and SmartArt
70 - Creating and Formatting a Chart
71 - Adding or Removing Chart Data
72 - Saving Favorite Chart Settings
73 - Charting Differing Orders of Magnitude
74 - Pie Chart Tricks
75 - Sparklines
76 - Labeling Sparklines
77 - Creating SmartArt
78 - Smart Art Formulas
Part 9 Visual Impact
79 - Cell Styles and Document Themes
80 - Color Scales, Icon Sets, Data Bars
81 - Icons for Only a Subset
82 - Paired Bar Charts with Negative Data Bars
83 - Picture Tools and WordArt
84 - Picture Background Removal
85 - Insert Screen Clipping
86 - Equation Editor
Part 10 Tips & Tricks
87 - Web Queries
88 - Turn Data
89 - Choose from a List
90 - ToolTips for a Cell
91 - Word Processing in Excel
92 - Have a Talk with Excel
Read More Show Less

Customer Reviews

Average Rating 5
( 1 )
Rating Distribution

5 Star

(1)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing 1 Customer Reviews
  • Posted April 4, 2014

    Mr. Excel is awesome! I highly recommend this purchase.

    I wanted to learn more about Excel functions and formulas but wanted something that would appeal to my need for visual aid in learning. The things I love about it are: quick and to the point lessons in everyday language, takes his time to explain how 2013 is different from earlier excel apps as well as shortcut tips, learn at your own pace, and it's not boring. I had a few great aha moments watching his dvd!

    Was this review helpful? Yes  No   Report this review
Sort by: Showing 1 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)