Home > Store > Computer Software > Business Office Software > Spreadsheet Software > Microsoft Excel

Power Excel 2010 with MrExcel LiveLessons (Video Training)

Add To My Wish List

  • Copyright 2011
  • Edition: 1st
  • DVD
  • ISBN-10: 0-7897-4393-0
  • ISBN-13: 978-0-7897-4393-0

Register your product to gain access to bonus material or receive a coupon.

  • Description
  • Downloads
  • Reviews
  • Sample Content & TOC

You’ve got Microsoft Excel 2010…now get the most out of it, faster and more easily than ever before! In 90 quick video lessons, Power Excel 2010 with MrExcel shows how to maximize your productivity with Microsoft Excel 2010’s best tools and shortcuts. Expert Bill Jelen simplifies powerful features including PivotTables, PowerPivot, Sparklines, Goal Seek, Cell Styles, Color Scales, Icon Sets, Data Bars, Web Queries, Backstage View, and more! Get more done faster with customized workbooks, the Quick Access Toolbar, and keyboard shortcuts…control and analyze data more effectively…communicate more visually with new charting tools and SmartArt…and plenty more! 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! For anyone who wants to master Microsoft Excel 2010 fast–from novices to experienced power users.

Customer Reviews

5 of 5 people found the following review helpful
5.0 out of 5 stars Great for people that are switching from Excel 2003!, March 24, 2011
By 
Hoppaguy (San Diego) - See all my reviews
(VINE VOICE)   
This review is from: Power Excel 2010 with MrExcel(LiveLessons) (DVD-ROM)
Customer review from the Amazon Vine™ Program (What's this?)
I consider myself to be a "power user" when it comes to Excel but I learned everything with Excel 2003. My company recently converted to Excel 2010 and I needed to learn how the software was different. This is the first time I have used a video based learning system rather than just buying an Excel textbook and I have to admit I was amazed at how much more interesting it was to learn this way. Each individual lesson is not too long so as to bore you to death but they are also not so short that it leaves you wondering where you should research next. With that being said, I watched all the lessons and found myself hardly missing a beat when it came to switching from Excel 2003 to 2010!
Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No


4 of 4 people found the following review helpful
3.0 out of 5 stars Convenient package for beginners and intermediates., February 5, 2012
By 
C (Guilford, CT USA) - See all my reviews
(TOP 500 REVIEWER)   
This review is from: Power Excel 2010 with MrExcel(LiveLessons) (DVD-ROM)
Customer review from the Amazon Vine™ Program (What's this?)
I chose this item in hopes that it would be a convenient package to help me tutor some friends on their Excel skills.

This tutoring suite is best for beginners and intermediates who want to brush up their skills and learn more advanced skills in Excel for data analysis and manipulation. It is presented in such a way that a familiarity with the previous version (2003) would help in the understanding of the course material used, as the guy in the video refers repeatedly at length to Excel 2003. However, those who are already Excel power users might find this course slow and tedious at best and would do better searching online for relevant videos and tutorials (often free) on specific task oriented skills for Excel 2010 instead of sifting through this course for applicable material.

In short, I would buy this guide for a basic-intermediate user wanting to improve their skills in the Excel 2010 version, but not for a more advanced user seeking for a quick bump-up to... Read more
Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No


3 of 3 people found the following review helpful
5.0 out of 5 stars Learn by Seeing...and it's Searchable!, March 24, 2011
By 
Patrick Reeves (Cheney, WA - USA) - See all my reviews
(VINE VOICE)    (REAL NAME)   
This review is from: Power Excel 2010 with MrExcel(LiveLessons) (DVD-ROM)
Customer review from the Amazon Vine™ Program (What's this?)
All of the "video-type" software application programs I have used before were set up where you had to find the lesson title that you thought MIGHT have the exact procedure you were trying to learn how to accomplish. I watched a lot of stuff that did not stick in my mind because it was not related to the problem at hand; but I had to stay tuned because my procedure might be the very next thing the instructor was going to cover. This made for a lot of wasted time as well.

However, in Power Excel with MrExcel, there is a search feature that you can use to zero in on the exact thing you want to learn. Just type your search term into the box, hit enter, and a list of lessons will appear that relate to your search. Click on the one that seems a best fit, and Shazam!, you're watching MrExcel point, click and explain how to do what you need to learn.
Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No


Share your thoughts with other customers:
 See all 44 customer reviews...

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

DRM-Free Video Downloads. Purchase and immediately download individual lessons from this video. Make your lesson selections below and click on the Buy button.

Videos can be viewed on: Windows 8, Windows XP, Vista, 7, and all versions of Macintosh OS X including the iPad, and other platforms that support the industry standard h.264 video codec.

Lesson 1

Power Excel 2010 with MrExcel LiveLessons:Part I Excel Interface, Downloadable Version

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 

Duration: 01:25:29  File Size: 131MB

View exampleView example
$7.99

Lesson 2

Power Excel 2010 with MrExcel Livelessons: Part 2 Text Formula, Downloadable Version

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

Duration: 00:37:23  File Size: 63MB

View exampleView example
$3.99

Lesson 3

Power Excel 2010 with MrExcel Livelessons: Lesson 3 Formulas, Downloadable Version

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

Duration: 01:07:36  File Size: 101MB

View exampleView example
$5.99

Lesson 4

Power Excel 2010 with MrExcel LiveLessons: Part 4 Sorting & Filtering, Downloadable Version

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

Duration: 00:29:17  File Size: 68MB

View exampleView example
$3.99

Lesson 5

Power Excel 2010 with MrExcel LiveLessons: Part 5 Subtotals, Downloadable Video

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

Duration: 00:23:37  File Size: 63MB

View exampleView example
$1.99

Lesson 6

Power Excel 2010 with MrExcel LiveLessons: Lesson 6 Pivot Tables, Downloadable Version

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

Duration: 01:03:40  File Size: 113MB

View exampleView example
$5.99

Lesson 7

Power Excel 2010 with MrExcel LiveLessons: Lesson 7 PowerPivot, Downloadable Version

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

Duration: 00:39:41  File Size: 62MB

View exampleView example
$3.99

Lesson 8

Power Excel 2010 with MrExcel LiveLessons: Lesson 8 Charting and SmartArt

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

Duration: 00:49:70  File Size: 87MB

View exampleView example
$4.99

Lesson 9

Power Excel 2010 with MrExcel LiveLessons: Part 9 Visual Impact, Downloadable Version

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

Duration: 00:34:05  File Size: 59MB

View exampleView example
$2.99

Lesson 10

Power Excel 2010 with MrExcel LiveLessons: Lesson 10 Tips and Tricks, Downloadable Version

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

Duration: 00:20:24  File Size: 29MB

View exampleView example
$1.99

Actual product comes full screen and in high resolution.

Actual product comes full screen and in high resolution.

Actual product comes full screen and in high resolution.

Actual product comes full screen and in high resolution.

Actual product comes full screen and in high resolution.

Actual product comes full screen and in high resolution.

Actual product comes full screen and in high resolution.

Actual product comes full screen and in high resolution.

Actual product comes full screen and in high resolution.

Actual product comes full screen and in high resolution.

 
Buy

DVD  $39.99  $31.99

Usually ships in 24 hours.

This DVD includes free shipping!

Buy

Downloadable Lessons   $39.99  $31.99

About this video

Accessible from your Account page after purchase. Requires the free QuickTime Player software.

Videos can be viewed on: Windows 8, Windows XP, Vista, 7, and all versions of Macintosh OS X including the iPad, and other platforms that support the industry standard h.264 video codec.

Purchase Reward: One Month Free Subscription
By completing any purchase on Que, you become eligible for an unlimited access one-month subscription to Safari Books Online.

Get access to thousands of books and training videos about technology, professional development and digital media from more than 40 leading publishers, including Addison-Wesley, Prentice Hall, Cisco Press, IBM Press, O'Reilly Media, Wrox, Apress, and many more. If you continue your subscription after your 30-day trial, you can receive 30% off a monthly subscription to the Safari Library for up to 12 months. That's a total savings of $199.