Power Excel 2003 with MrExcel LiveLessons (Video Training)
- By Bill Jelen
- Published Apr 24, 2008 by Que. Part of the LiveLessons series.
DVD
- Sorry, this book is no longer in print.
Audio & Video
Video
Sample: Lesson 2, Creating a Chart With One Keystroke
You need to upgrade your Flash Player. You need version 9 or above to view this video. You may download it here. You may also see this message if you have JavaScript turned off. If this is the case, please enable JavaScript and reload the page.
Description
- Copyright 2008
- Edition: 1st
- DVD
- ISBN-10: 0-7897-3824-4
- ISBN-13: 978-0-7897-3824-0
<>Power Excel 2003 with MrExcel LiveLessons
Mastering the Smartest, Fastest Ways to Use Excel
Bill Jelen
DVD includes:
- 6+ hours of video instruction
- More than 80 tips and techniques
- Features that can be learned in less than Five minutes
Bill Jelen (“MrExcel”) presents focused, practical videos that teach you powerful new ways to chart, calculate, build PivotTables, automate workbooks, wrangle your data, and more! Click play to follow along as Jelen walks you through using Excel’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 85 quick video lessons, Bill Jelen (“MrExcel”) shows you all you need to maximize your productivity with Excel 2003, 2002 (XP), or 2000!
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 these powerful techniques at your own pace—and get specific answers and solutions immediately, whenever you need them!
These practical, easy-to-use videos cover charting, PivotTables, advanced calculations, worksheet management, macros, and a whole lot more—including tips and tricks 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.
For anyone who wants to get more done in less time with Excel 2003, 2002 (XP), or 2000—from entrepreneurs to financial analysts, marketers to office managers!
- 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
mylivelessons.com
informit.com/que
Contents:
Part 1 Charting
Lesson 1 Creating a Chart Using the Wizard
Lesson 2 Creating a Chart with One Keystroke
Lesson 3 Formatting a Chart
Lesson 4 Adding Chart Data
Sample Content
Table of Contents
Introduction
Part 1Charting
Lesson 1 Creating a Chart Using the Wizard
What You Will Learn
Related Lessons
Notes from the Lesson
Lesson 2 Creating a Chart with One Keystroke
What You Will Learn
Related Lessons
Notes from the Lesson
Lesson 3 Formatting a Chart
What You Will Learn
Related Lessons
Notes from the Lesson
Lesson 4 Adding Chart Data
What You Will Learn
Related Lessons
Notes from the Lesson
Lesson 5 Noncontiguous Data
What You Will Learn
Related Lessons
Notes from the Lesson
Lesson 6 Interactive Chart
What You Will Learn
Related Lessons
Notes from the Lesson
Lesson 7 When to Choose Which Chart Type
What You Will Learn
Notes from the Lesson
Lesson 8 Charting Differing Orders of Magnitude
What You Will Learn
Related Lessons
Notes from the Lesson
Lesson 9 Pie Chart Tricks
What You Will Learn
Related Lessons
Notes from the Lesson
Lesson 10 XY & Bubble Charts
What You Will Learn
Notes from the Lesson
Lesson 11 Histograms & Overlap Charts
What You Will Learn
Related Lessons
Notes from the Lesson
Lesson 12 Saving Favorite Chart Settings
What You Will Learn
Related Lessons
Notes from the Lesson
Lesson 13 Chart Lies
What You Will Learn
Notes from the Lesson
Part 2Text
Lesson 14 Drag the Fill Handle to Extend a Series
What You Will Learn
Related Lessons
Notes from the Lesson
Lesson 15 Create Your Own Series
What You Will Learn
Related Lessons
Notes from the Lesson
Lesson 16 Joining Text
What You Will Learn
Related Lessons
Notes from the Lesson
Lesson 17 Rapid Formula Copy
What You Will Learn
Related Lessons
Notes from the Lesson
Lesson 18 Convert to Proper Case
What You Will Learn
Notes from the Lesson
Lesson 19 Joining Dates
What You Will Learn
Related Lessons
Notes from the Lesson
More Information
Other Things You Might Like
