Buy Lessons

DRM-Free Video Downloads. Purchase and immediately download individual lessons from this video. Make your lesson selections below and click on the Buy button.

Videos can be viewed on: Windows 8, Windows XP, Vista, 7, and all versions of Macintosh OS X including the iPad, and other platforms that support the industry standard h.264 video codec. Requires the free QuickTime Player software.

Lesson 1

Power Excel 2007: The User Interface, Downloadable Version

Excel 2007 offers a dramatically different interface. Microsoft removed the old menu and toolbars and replaced it with the Ribbon interface. These 10 lessons introduce the various components of the Excel 2007 interface including the Quick Access Toolbar, Keyboard Shortcuts, Mini Toolbar and Live Preview, Zoom Slider and Page Layout View, Recent Documents, Save as PDF, Excel Options, and Closing Excel.

Lesson 3

Power Excel 2007: Handling Text, Downloadable Version

While most people think of Excel as a program to deal with numbers, there is always some text to help frame the numbers in context. In these nine lessons, you will learn how to quickly enter text, join text, break apart text, or even create text from dates or numbers.

Lesson 6

Power Excel 2007: Pivot Tables, Downloadable Version

Pivot tables are the favorite feature in Excel. You can take 500,000 rows of data and reduce it to a useful summary in six clicks. These 15 lessons take you through everything you need to know to use pivot tables successfully.

Lesson 7

Power Excel 2007: Charting and SmartArt, Downloadable Version

After 15 years, the charting engine was redesigned in Excel 2007. You can now create great-looking charts in just a few clicks. Also new, create sharp-looking business diagrams with the SmartArt tools.

Lesson 8

Power Excel 2007: Formulas, Downloadable Version

Formulas are the miracle of Excel. Enter one formula and copy it to 50,000 rows. Change one number and all of the formulas recalculate. In these 13 lessons, you will learn fast ways to enter formulas, some arcane of formula references, how to instantly discover an answer. You will also learn about the powerful VLOOKUP and array formulas.

Lesson 9

Power Excel 2007: Macros, Downloadable Version

VBA macros allow you to automate any process in Excel. Microsoft provides the macro recorder to help create macros, but there are a myriad of undocumented rules that you must follow to have the macro recorder work successfully. In just four lessons, you will learn how to successfully record a macro that can deal with data sets of any size.

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.