Publisher : Live Lessons
Language : English
Duration : 8 Hours
Release Date : 6 Mar. 2013
Size : 1,49 Gb
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.
Table of Contents
Introduction
Introduction to Power Excel 2013 with MrExcel LiveLessons 00:02:19
Excel Interface
Learning objectives 00:00:32
Sign in to Office 00:04:19
Start Screen 00:03:25
Dual Monitors 00:05:07
Flash Fill 00:06:14
Quick Analysis 00:04:07
Apps for Office 00:04:54
Ribbon Customizing 00:08:28
Keyboard Shortcuts 00:10:58
Page Layout View 00:06:13
Customize Future Workbooks 00:07:06
Copy Worksheets 00:03:59
Change All Worksheets 00:03:48
Create PDF 00:03:57
Finding Icons 00:04:11
Snow Blindness 00:06:19
Text
Learning objectives 00:00:33
Fill Handle 00:09:10
Custom List 00:03:35
Joining Text 00:02:15
Rapid Formula Copy 00:03:00
Proper Case 00:02:12
Joining Dates 00:05:22
Formulas to Values 00:04:03
Breaking Apart Text 00:05:10
Formulas
Learning objectives 00:00:39
AutoSum Tricks 00:03:55
Formula Auditing 00:07:11
Entering Formulas 00:04:12
Absolute Reference 00:04:43
Tables 00:04:39
Loan Calculations 00:04:34
Goal Seek 00:02:43
What-If Table 00:06:47
IF Formulas 00:10:10
VLOOKUP 00:10:48
Date & Time 00:11:28
Intersection 00:03:26
Coerce an Array 00:06:28
Sort & Filter
Learning objectives 00:00:40
Data Preparation 00:03:35
One-Click Sorting 00:03:10
Sort by Color 00:02:50
Sort by Weekday 00:03:04
Rearranging Columns 00:02:39
Sort with a Formula 00:05:25
Filter by Selection 00:04:11
Filtering 00:03:55
Remove Duplicates 00:05:13
