Power Excel 2007 with MrExcel ─ Mastering the Smartest, Fastest Ways to Use Excel 2007

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 Finance magazine.

Microsoft Office Spreadsheets/Desktop Applications

Part 1 Excel 2007 Interface

Lesson 1 Introducing the Ribbon

Lesson 2 Quick Access Toolbar

Lesson 3 Finding Icons

Lesson 4 Keyboard Shortcuts

Lesson 5 Mini Toolbar and Live Preview

Lesson 6 Zoom Slider and Page Layout

Lesson 7 Recent Documents

Lesson 8 Save as PDF

Lesson 9 Excel Options

Lesson 10 Ope

Bill Jelen is the host of MrExcel.com and the author of 20 books on Microsoft Excel, including Special Edition Using Excel 2007, Pivot Table Data Crunching, and VBA & Macros for Microsoft Excel. He has made more than 75 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 Learn Excel podcast. 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.