by Bill Jelen | Released September 2010 | ISBN: 9780132611251

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! Show and hide more

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