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