Power Excel 2007 with MrExcel
Mastering the Smartest, Fastest Ways to Use Excel 2007
Bill Jelen
For anyone who wants to get more done in less time with Excel 2007—from entrepreneurs to financial analysts, marketers to office managers!
Bill Jelen (“MrExcel”) presents focused, practical videos that teach you Excel 2007’s best new techniques: supercharged solutions for charting, calculating, formatting, data analysis, automation, and a …
Power Excel 2007 with MrExcel
Mastering the Smartest, Fastest Ways to Use Excel 2007
Bill Jelen
For anyone who wants to get more done in less time with Excel 2007—from entrepreneurs to financial analysts, marketers to office managers!
Bill Jelen (“MrExcel”) presents focused, practical videos that teach you Excel 2007’s best new techniques: supercharged solutions for charting, calculating, formatting, data analysis, automation, and a whole lot more! Click play to follow along as Jelen walks you through using Excel 2007’s most sophisticated features… all you need to do is watch!
You’ve got Microsoft Excel…now get the most out of it, faster and more easily than ever before! In more than 90 quick video lessons, Bill Jelen (“MrExcel”) shows you all you need to maximize your productivity with Excel 2007.
Building on the live course he’s taught to thousands of financial professionals, Jelen walks you through Excel’s most powerful features and techniques. Just watch: You’ll master Excel 2007’s new Ribbon interface and most powerful techniques at your own pace—and get specific answers and solutions immediately, whenever you need them!
These practical, easy-to-use videos cover Excel 2007’s hottest new features: everything from charting improvements to conditional formatting, filtering to SmartArt. You’ll find up-to-the-minute tips and tricks for using PivotTables, managing and automating worksheets, and a whole lot more—great new solutions that could save you hours every single week!
Looking for a better way to master today’s rapidly changing technologies? Want expert help but don’t have the time or energy to read a book? Can’t find classroom training worth the money? Discover LiveLessons: self-paced, personal video instruction from the world’s leading experts.
LiveLessons is an eight-hour video course organized into bite-sized, self-contained sessions—you’ll learn key skills in as little as five minutes!
Each session begins with well-defined learning objectives and ends with comprehensive summaries, which help you track your progress.
Follow along as your instructor shows exactly how to get great results in your real-world environment.
Bill Jelen is known worldwide as MrExcel. He presents live Excel seminars to accountants throughout the U.S. and has logged more than 60 appearances on The Lab with Leo Laporte. Honored as a Microsoft MVP for Excel, he has produced 500 episodes of his “Learn Excel from MrExcel” video podcast. He writes the monthly Excel column for Strategic Financemagazine.
Microsoft Office Spreadsheets/Desktop Applications
Introduction
Introduction 00:02:04
Excel 2007 Interface
Learning Objectives 00:01:40
1: Introducing the Ribbon 00:09:24
2: Quick Access Toolbar 00:05:42
3: Finding Icons 00:06:41
4: Keyboard Shortcuts 00:07:16
5: Mini Toolbar & Live Preview 00:06:16
6: Zoom Slider & Page Layout 00:05:41
7: Recent Documents 00:05:05
8: Save as PDF 00:06:33
9: Excel Options 00:12:18
10: Opening Templates, Closing Workbooks 00:04:19
Excel 2007 New Features
Learning Objectives 00:01:42
11: Unlocking the Big Grid, File Formats 00:10:12
12: Cell Styles & Themes 00:08:49
13: Data Visualizations 00:09:16
14: Tables & Table Formulas 00:08:36
15: Sort by Color, Filter by Color 00:05:41
16: Remove Duplicates, Mark Duplicates 00:07:45
17: Picture Tools & WordArt 00:08:18
18: Other New Features (Formula Bar, Translations) 00:04:03
Text
Learning Objectives 00:01:28
19: Drag the Fill Handle to Extend a Series 00:05:04
20: Create Your Own Series 00:05:13
21: Joining Text 00:03:53
22: Rapid Formula Copy 00:06:08
23: Convert to Proper Case 00:03:37
24: Joining Dates 00:04:50
25: Converting Formulas to Values 00:06:08
26: Breaking Apart Text 00:06:20
27: Parsing Fixed Width 00:04:23
Excel Customizations
Learning Objectives 00:01:27
28: Data Entry Tricks 00:06:28
29: Customize All Future Workbooks 00:09:18
30: Copy Worksheets 00:03:19
31: Change All Worksheets 00:05:50
32: Arranging Windows 00:07:06
Sorting and Subtotals
Learning Objectives 00:01:43
33: Data Preparation 00:05:44
34: Sorting Basics 00:05:52
35: Random Sort 00:03:57
36: Sorting by Weekday 00:04:05
37: Rearranging Columns 00:04:14
38: Subtotals 00:05:02
39: Collaspsing Subtotals 00:03:38
40: Copy Subtotals 00:04:41
41: Formatting Subtotals 00:03:21
42: Multiple Subtotals 00:07:53
43: Filling in Data on Subtotal Rows 00:04:50
44: Subtotal Tricks 00:09:19
Pivot Tables
Learning Objectives 00:01:50
45: Creating a Pivot Table 00:04:04
46: Changing a Pivot Table 00:03:07
47: Pivot Gotchas 00:06:27
48: Pivot Sorting 00:04:18
49: Drill Down 00:04:26
50: Summarizing Dates 00:09:00
51: Top 10 Reports 00:08:39
52: Pivot Calculations 00:10:29
53: Pivot Formatting 00:08:12
54: Unique List 00:04:28
55: Ad-Hoc Queries 00:04:00
56: New Pivot Filtering Options 00:05:42
57: 50 Reports in 5 Seconds 00:04:53
58: Pivot Compatibility with 2003 00:06:58
59: Making Reports Pivotable 00:11:14
Charting & SmartArt
Learning Objectives 00:01:46
60: Creating & Formatting a Chart 00:10:54
61: Adding or Removing Chart Data 00:04:58
62: Interactive Chart 00:04:04
63: Charting Differing Orders of Magnitude 00:05:32
64: Pie Chart Tricks, Histograms 00:06:23
65: XY & Bubble Charts 00:10:28
66: Saving Favorite Chart Settings 00:04:00
67: Creating SmartArt 00:08:31
68: Formulas in SmartArt 00:06:21
Formulas
Learning Objectives 00:01:48
69: Autosum Tricks 00:04:03
70: Formula Auditing 00:07:44
71: 3 Ways of Entering Formulas 00:03:03
72: Relative vs Absolute Formulas 00:03:36
73: Discovering Functions 00:05:01
74: Goal Seek 00:03:12
75: Unusual Functions 00:06:43
76: IF Formulas 00:08:20
77: VLOOKUP 00:11:34
78: New Fiunctions - IFERROR 00:05:10
79: New Functions - SUMIFS 00:05:37
80: Super Formulas 00:05:38
81: Date & Time 00:11:59
Macros
Learning Objectives 00:01:39
82: Recording a Macro 00:08:55
83: Recording a Navigation 00:05:38
84: How Many Rows 00:08:48
85: Event Macros 00:07:51
Tips & Tricks
Learning Objectives 00:01:49
86: Finding Records with Filter 00:04:14
87: Web Queries 00:05:09
88: Copying Column Widths 00:03:46
89: Page Numbering 00:03:24
90: Turn Data 00:03:37
91: Amerpersand in Header 00:04:58
92: Choose From a List 00:04:58
93: Tool Tips for A Cell 00:05:07
94: Word Processing in Excel 00:04:26
95: Have a Talk with Excel 00:04:42