Power Excel 2013 with MrExcel LiveLessons (Video Training)

Power Excel 2013 with MrExcel LiveLessons (Video Training)

by
Released February 2013
Publisher(s): Pearson
ISBN: 0133259552

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

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
  2. Excel Interface
    1. Learning objectives
    2. Sign in to Office
    3. Start Screen
    4. Dual Monitors
    5. Flash Fill
    6. Quick Analysis
    7. Apps for Office
    8. Ribbon Customizing
    9. Keyboard Shortcuts
    10. Page Layout View
    11. Customize Future Workbooks
    12. Copy Worksheets
    13. Change All Worksheets
    14. Create PDF
    15. Finding Icons
    16. Snow Blindness
  3. Text
    1. Learning objectives
    2. Fill Handle
    3. Custom List
    4. Joining Text
    5. Rapid Formula Copy
    6. Proper Case
    7. Joining Dates
    8. Formulas to Values
    9. Breaking Apart Text
  4. Formulas
    1. Learning objectives
    2. AutoSum Tricks
    3. Formula Auditing
    4. Entering Formulas
    5. Absolute Reference
    6. Tables
    7. Loan Calculations
    8. Goal Seek
    9. What-If Table
    10. IF Formulas
    11. VLOOKUP
    12. Date Time
    13. Intersection
    14. Coerce an Array
  5. Sort Filter
    1. Learning objectives
    2. Data Preparation
    3. One-Click Sorting
    4. Sort by Color
    5. Sort by Weekday
    6. Rearranging Columns
    7. Sort with a Formula
    8. Filter by Selection
    9. Filtering
    10. Remove Duplicates
  6. Subtotals
    1. Learning objectives
    2. Subtotals
    3. Collapsing Subtotals
    4. Copy Subtotals
    5. Formatting Subtotals
    6. Sorting Subtotals
    7. Count, Last
    8. Grouping
    9. Data Consolidate
  7. Pivot
    1. Learning objectives
    2. Creating a Pivot Table
    3. Changing a Pivot Table
    4. Pivot Gotchas
    5. Pivot Formatting
    6. Drill Down
    7. Pivot Calculations
    8. Summarizing Dates
    9. Pivot Sorting
    10. Filtering Row Fields
    11. Top 10 Report
    12. Filtering with Slicers
    13. Multiple Pivots, One Slicer
    14. 50 Reports in 5 Seconds
    15. New Cache
    16. Frequency Chart
    17. Compare 2 Lists
    18. Perfect Formatting
  8. PowerPivot
    1. Learning objectives
    2. Data Model
    3. PowerPivot
    4. Grid Calculations
    5. Calendar Table
    6. Calculated Fields
    7. Power View
  9. Charting
    1. Learning objectives
    2. Recommended Charts
    3. Formatting Chart
    4. Data Labels
    5. Combo Charts
    6. Scatter Charts
    7. Saving Template
    8. Sparklines
    9. Labeling Sparklines
    10. Color Scales, Icon Sets, Data Bars
    11. Creating SmartArt
    12. SmartArt Formulas
  10. Tips Tricks
    1. Learning objectives
    2. Turn Data
    3. Choose from List
    4. Cell Tooltips
    5. Mail Merge
    6. Talk with Excel
  11. Excel Web App
    1. Learning objectives
    2. Web Data
    3. Publish to Web
    4. Embed in Webpage
    5. Excel Button
    6. Surveys
  12. Introduction
    1. Summary of Power Excel 2013 with MrExcel LiveLessons

Product information

  • Title: Power Excel 2013 with MrExcel LiveLessons (Video Training)
  • Author(s):
  • Release date: February 2013
  • Publisher(s): Pearson
  • ISBN: 0133259552