O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Power Excel 2013 with MrExcel LiveLessons (Video Training)

Video Description

You got Microsoft Excel 2013... now get these video lessons and master it faster and more easily than ever before! In 97 quick video lessons, Power Excel 2013 with MrExcel shows how to maximize your productivity Excel's best tools and shortcuts. Expert Bill Jelen simplifies powerful features including PivotTables, PowerPivot, Charting, Flash Fill, VLOOKUP, Combo Chart, Mail Merge, SmartArt, and more! Get more done faster with Excel Web App, the Quick Access Toolbar, and keyboard shortcuts... control and analyze data more effectively…communicate more visually with charting tools…and plenty more! Just watch: You’ll master high-powered Excel 2013 skills at your own pace–and get specific answers and solutions immediately, whenever you need them! For anyone who wants to master Microsoft Excel 2013 fast–from novices to experienced power users.

About the Author:

Bill Jelen is the host of MrExcel.com and the author of 18 books on Microsoft Excel, including Special Edition Using Excel 2007, Pivot Table Data Crunching, VBA & Macros for Microsoft Excel, Excel for Marketing Managers, and Guerilla Data Analysis Using Microsoft Excel. He has made more than 60 guest appearances on TechTV with Leo Laporte and was voted guest of the year on the Computer America radio show. He has produced more than 600 episodes of his daily video podcast “Learn Excel from MrExcel.” Bill will entertain you while showing you the powerful tricks in Excel. Before founding MrExcel.com in 1998, Jelen spent 12 years in the trenches as a financial analyst for the accounting, finance, marketing, and operations departments of a publicly held company. Since then, his company has automated Excel reports for hundreds of clients around the world. The website answers more than 30,000 questions a year—for free—for readers all over the world. Jelen joins us from Akron, Ohio.

Table of Contents

  1. Introduction
    1. Introduction to Power Excel 2013 with MrExcel LiveLessons 00:02:19
  2. Excel Interface
    1. Learning objectives 00:00:32
    2. Sign in to Office 00:04:19
    3. Start Screen 00:03:25
    4. Dual Monitors 00:05:07
    5. Flash Fill 00:06:14
    6. Quick Analysis 00:04:07
    7. Apps for Office 00:04:54
    8. Ribbon Customizing 00:08:28
    9. Keyboard Shortcuts 00:10:58
    10. Page Layout View 00:06:13
    11. Customize Future Workbooks 00:07:06
    12. Copy Worksheets 00:03:59
    13. Change All Worksheets 00:03:48
    14. Create PDF 00:03:57
    15. Finding Icons 00:04:11
    16. Snow Blindness 00:06:19
  3. Text
    1. Learning objectives 00:00:33
    2. Fill Handle 00:09:10
    3. Custom List 00:03:35
    4. Joining Text 00:02:15
    5. Rapid Formula Copy 00:03:00
    6. Proper Case 00:02:12
    7. Joining Dates 00:05:22
    8. Formulas to Values 00:04:03
    9. Breaking Apart Text 00:05:10
  4. Formulas
    1. Learning objectives 00:00:39
    2. AutoSum Tricks 00:03:55
    3. Formula Auditing 00:07:11
    4. Entering Formulas 00:04:12
    5. Absolute Reference 00:04:43
    6. Tables 00:04:39
    7. Loan Calculations 00:04:34
    8. Goal Seek 00:02:43
    9. What-If Table 00:06:47
    10. IF Formulas 00:10:10
    11. VLOOKUP 00:10:48
    12. Date & Time 00:11:28
    13. Intersection 00:03:26
    14. Coerce an Array 00:06:28
  5. Sort & Filter
    1. Learning objectives 00:00:40
    2. Data Preparation 00:03:35
    3. One-Click Sorting 00:03:10
    4. Sort by Color 00:02:50
    5. Sort by Weekday 00:03:04
    6. Rearranging Columns 00:02:39
    7. Sort with a Formula 00:05:25
    8. Filter by Selection 00:04:11
    9. Filtering 00:03:55
    10. Remove Duplicates 00:05:13
  6. Subtotals
    1. Learning objectives 00:00:36
    2. Subtotals 00:03:13
    3. Collapsing Subtotals 00:01:26
    4. Copy Subtotals 00:03:44
    5. Formatting Subtotals 00:02:16
    6. Sorting Subtotals 00:02:30
    7. Count, Last 00:07:12
    8. Grouping 00:02:03
    9. Data Consolidate 00:03:51
  7. Pivot
    1. Learning objectives 00:00:44
    2. Creating a Pivot Table 00:05:12
    3. Changing a Pivot Table 00:03:39
    4. Pivot Gotchas 00:07:46
    5. Pivot Formatting 00:06:12
    6. Drill Down 00:04:06
    7. Pivot Calculations 00:11:02
    8. Summarizing Dates 00:05:17
    9. Pivot Sorting 00:03:41
    10. Filtering Row Fields 00:02:08
    11. Top 10 Report 00:05:21
    12. Filtering with Slicers 00:07:41
    13. Multiple Pivots, One Slicer 00:05:48
    14. 50 Reports in 5 Seconds 00:03:01
    15. New Cache 00:02:52
    16. Frequency Chart 00:02:45
    17. Compare 2 Lists 00:03:42
    18. Perfect Formatting 00:06:14
  8. PowerPivot
    1. Learning objectives 00:00:48
    2. Data Model 00:04:51
    3. PowerPivot 00:06:32
    4. Grid Calculations 00:05:42
    5. Calendar Table 00:05:02
    6. Calculated Fields 00:08:15
    7. Power View 00:09:53
  9. Charting
    1. Learning objectives 00:00:57
    2. Recommended Charts 00:05:55
    3. Formatting Chart 00:08:18
    4. Data Labels 00:05:32
    5. Combo Charts 00:02:16
    6. Scatter Charts 00:04:07
    7. Saving Template 00:02:26
    8. Sparklines 00:04:15
    9. Labeling Sparklines 00:05:45
    10. Color Scales, Icon Sets, Data Bars 00:06:55
    11. Creating SmartArt 00:04:15
    12. SmartArt Formulas 00:04:09
  10. Tips & Tricks
    1. Learning objectives 00:00:36
    2. Turn Data 00:03:09
    3. Choose from List 00:02:22
    4. Cell Tooltips 00:03:00
    5. Mail Merge 00:02:10
    6. Talk with Excel 00:03:10
  11. Excel Web App
    1. Learning objectives 00:01:13
    2. Web Data 00:04:31
    3. Publish to Web 00:05:13
    4. Embed in Webpage 00:02:47
    5. Excel Button 00:03:05
    6. Surveys 00:04:23
  12. Introduction
    1. Summary of Power Excel 2013 with MrExcel LiveLessons 00:01:07