Power Excel 2003 with MrExcel: Mastering the Smartest, Fastes Ways to Use Excel

Overview

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

...

See more details below
(Book & DVD)
$35.99
BN.com price
(Save 10%)$39.99 List Price
Other sellers (Other Format)
  • All (2) from $7.61   
  • Used (2) from $7.61   
Sending request ...

Overview

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

Lesson 5 Noncontiguous Data

Lesson 6 Interactive Chart

Lesson 7 When to Choose Which Chart Type

Lesson 8 Charting Differing Orders of Magnitude

Lesson 9 Pie Chart Tricks

Lesson 10 XY & Bubble Charts

Lesson 11 Histograms & Overlap Charts

Lesson 12 Saving Favorite Chart Settings

Lesson 13 Chart Lies

Part 2 Text

Lesson 14 Drag the Fill Handle to Extend a Series

Lesson 15 Create Your Own Series

Lesson 16 Joining Text

Lesson 17 Rapid Formula Copy

Lesson 18 Convert to Proper Case

Lesson 19 Joining Dates

Lesson 20 Converting Formulas to Values

Lesson 21 Breaking Apart Text

Lesson 22 Parsing Fixed Width

Part 3 Excel Customizations

Lesson 23 Full Menus

Lesson 24 Toolbar Customization

Lesson 25 Resetting Toolbars

Lesson 26 Steve-O Toolbar

Lesson 27 Close All Workbooks

Lesson 28 Recently Used File List

Lesson 29 Data Entry Tricks

Lesson 30 Customize All Future Workbooks

Lesson 31 Copy Worksheets

Lesson 32 Change All Worksheets

Lesson 33 Arranging Windows

Part 4 Sorting & Subtotals

Lesson 34 Data Preparation

Lesson 35 Sorting Basics

Lesson 36 Random Sort

Lesson 37 Sorting by Weekday

Lesson 38 Rearranging Columns

Lesson 39 Subtotals

Lesson 40 Collapsing Subtotals

Lesson 41 Copy Subtotals

Lesson 42 Formatting Subtotals

Lesson 43 Multiple Subtotals

Lesson 44 Filling in Data on Subtotal Rows

Lesson 45 Subtotal Tricks

Part 5 Pivot Tables

Lesson 46 Creating a Pivot Table

Lesson 47 Changing a Pivot Table

Lesson 48 Pivot Gotchas

Lesson 49 Pivot Sorting

Lesson 50 Drill Down

Lesson 51 Summarizing Dates

Lesson 52 Top 10 Report

Lesson 53 Pivot Calculations

Lesson 54 Pivot Formatting

Lesson 55 Unique List

Lesson 56 Ad-Hoc Queries

Lesson 57 50 Reports in 5 Seconds

Lesson 58 Making Reports Pivotable

Part 6 Formulas

Lesson 59 AutoSum Tricks

Lesson 60 Formula Auditing

Lesson 61 Three Ways of Entering Formulas

Lesson 62 Relative Versus Absolute Formulas

Lesson 63 Discovering Functions

Lesson 64 Goal Seek

Lesson 65 Unusual Functions

Lesson 66 IF Formulas

Lesson 67 VLOOKUP

Lesson 68 Super Formulas

Lesson 69 Date & Time

Part 7 Macros

Lesson 70 Recording a Macro

Lesson 71 Recording Navigation

Lesson 72 How Many Rows?

Lesson 73 Event Macros

Part 8 Tips & Tricks

Lesson 74 Finding Records

Lesson 75 Web Queries

Lesson 76 Copying Column Widths

Lesson 77Floating Palettes

Lesson 78 Page Numbering

Lesson 79 Turn Data

Lesson 80 & in Header

Lesson 81 Choose from a List

Lesson 82 Tool Tips for a Cell

Lesson 83 Word Processing in Excel

Lesson 84 Mapping Data

Lesson 85 Have a Talk with Excel

Read More Show Less

Product Details

  • ISBN-13: 9780789738240
  • Publisher: Que
  • Publication date: 5/12/2008
  • Series: LiveLessons Series
  • Edition description: Book & DVD
  • Pages: 110
  • Product dimensions: 7.50 (w) x 9.10 (h) x 1.20 (d)

Meet the Author

Bill Jelenis the host of MrExcel.com and the author of 18 books on Microsoft Excel, including Special Edition Using Excel 2007, Pivot Table Data Crunching, VBA & Macros for Microsoft Excel, Excel for Marketing Managers, and Guerilla Data Analysis Using Microsoft Excel. He has made more than 60 guest appearances on TechTVwith Leo Laporte and was voted guest of the year on the Computer Americaradio show. He has produced more than 600 episodes of his daily video podcast “Learn Excel from MrExcel.” 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. Jelen joins us from Akron, Ohio.

Read More Show Less

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

Lesson 20 Converting Formulas to Values

What You Will Learn

Notes from the Lesson

Lesson 21 Breaking Apart Text

What You Will Learn

Related Lessons

Notes from the Lesson

Lesson 22 Parsing Fixed Width

What You Will Learn

Related Lessons

Notes from the Lesson

Part 3Excel Customizations

Lesson 23 Full Menus

What You Will Learn

Related Lessons

Notes from the Lesson

Lesson 24 Toolbar Customization

What You Will Learn

Related Lessons

More Details

Notes from the Lesson

Lesson 25 Resetting Toolbars

What You Will Learn

Related Lessons

Notes from the Lesson

Lesson 26 Steve-O Toolbar

What You Will Learn

Related Lessons

Notes from the Lesson

Lesson 27 Close All Workbooks

What You Will Learn

Notes from the Lesson

Lesson 28 Recently Used File List

What You Will Learn

Notes from the Lesson

Lesson 29 Data Entry Tricks

What You Will Learn

Notes from the Lesson

Lesson 30 Customize All Future Workbooks

What You Will Learn

Related Lessons

Notes from the Lesson

Lesson 31 Copy Worksheets

What You Will Learn

Notes from the Lesson

Lesson 32 Change All Worksheets

What You Will Learn

Related Lessons

Notes from the Lesson

Lesson 33 Arranging Windows

What You Will Learn

Notes from the Lesson

Part 4Sorting & Subtotals

Lesson 34 Data Preparation

What You Will Learn

Notes from the Lesson

Lesson 35 Sorting Basics

What You Will Learn

Related Lessons

Notes from the Lesson

Lesson 36 Random Sort

What You Will Learn

Related Lessons

Notes from the Lesson

Lesson 37 Sorting by Weekday

What You Will Learn

Related Lessons

Notes from the Lesson

Lesson 38 Rearranging Columns

What You Will Learn

Related Lessons

Notes from the Lesson

Lesson 39 Subtotals

What You Will Learn

Related Lessons

Notes from the Lesson

Lesson 40 Collapsing Subtotals

What You Will Learn

Related Lessons

Notes from the Lesson

Lesson 41 Copy Subtotals

What You Will Learn

Related Lessons

Notes from the Lesson

Lesson 42 Formatting Subtotals

What You Will Learn

Related Lessons

Notes from the Lesson

Lesson 43 Multiple Subtotals

What You Will Learn

More Details

Notes from the Lesson

Lesson 44 Filling in Data on Subtotal Rows

What You Will Learn

Related Lessons

Notes from the Lesson

Lesson 45 Subtotal Tricks

What You Will Learn

Notes from the Lesson

Part 5Pivot Tables

Lesson 46 Creating a Pivot Table

What You Will Learn

Related Lessons

Notes from the Lesson

Lesson 47 Changing a Pivot Table

What You Will Learn

Related Lessons

Notes from the Lesson

Lesson 48 Pivot Gotchas

What You Will Learn

Notes from the Lesson

Lesson 49 Pivot Sorting

What You Will Learn

Related Lessons

Notes from the Lesson

Lesson 50 Drill Down

What You Will Learn

Notes from the Lesson

Lesson 51 Summarizing Dates

What You Will Learn

Related Lessons

Notes from the Lesson

Lesson 52 Top 10 Report

What You Will Learn

Related Lessons

Notes from the Lesson

Lesson 53 Pivot Calculations

What You Will Learn

Notes from the Lesson

Lesson 54 Pivot Formatting

What You Will Learn

Notes from the Lesson

Lesson 55 Unique List

What You Will Learn

Related Lessons

Notes from the Lesson

Lesson 56 Ad-Hoc Queries

What You Will Learn

Related Lessons

Notes from the Lesson

Lesson 57 50 Reports in 5 Seconds

What You Will Learn

Related Lessons

Notes from the Lesson

Lesson 58 Making Reports Pivotable

What You Will Learn

Notes from the Lesson

Part 6Formulas

Lesson 59 AutoSum Tricks

What You Will Learn

Notes from the Lesson

Lesson 60 Formula Auditing

What You Will Learn

Notes from the Lesson

Lesson 61 Three Ways of Entering Formulas

What You Will Learn

Related Lessons

Notes from the Lesson

Lesson 62 Relative Versus Absolute Formulas

What You Will Learn

Notes from the Lesson

Lesson 63 Discovering Functions

What You Will Learn

Notes from the Lesson

Lesson 64 Goal Seek

What You Will Learn

Notes from the Lesson

Lesson 65 Unusual Functions

What You Will Learn

Related Lessons

Notes from the Lesson

Lesson 66 IF Formulas

What You Will Learn

Related Lessons

Notes from the Lesson

Lesson 67 VLOOKUP

What You Will Learn

Notes from the Lesson

Lesson 68 Super Formulas

What You Will Learn

Notes from the Lesson

Lesson 69 Date & Time

What You Will Learn

Notes from the Lesson

Part 7Macros

Lesson 70 Recording a Macro

What You Will Learn

Related Lessons

Notes from the Lesson

Lesson 71 Recording Navigation

What You Will Learn

Related Lessons

Notes from the Lesson

Lesson 72 How Many Rows?

What You Will Learn

Related Lessons

Notes from the Lesson

Lesson 73 Event Macros

What You Will Learn

Related Lessons

Notes from the Lesson

Part 8Tips & Tricks

Lesson 74 Finding Records

What You Will Learn

Related Lessons

Notes from the Lesson

Lesson 75 Web Queries

What You Will Learn

Notes from the Lesson

Lesson 76 Copying Column Widths

What You Will Learn

Notes from the Lesson

Lesson 77Floating Palettes

What You Will Learn

Notes from the Lesson

Lesson 78 Page Numbering

What You Will Learn

Related Lessons

Notes from the Lesson

Lesson 79 Turn Data

What You Will Learn

Notes from the Lesson

Lesson 80 & in Header

What You Will Learn

Related Lessons

Notes from the Lesson

Lesson 81 Choose from a List

What You Will Learn

Notes from the Lesson

Lesson 82 Tool Tips for a Cell

What You Will Learn

Notes from the Lesson

Lesson 83 Word Processing in Excel

What You Will Learn

Notes from the Lesson

Lesson 84 Mapping Data

What You Will Learn

Notes from the Lesson

Lesson 85 Have a Talk with Excel

What You Will Learn

Notes from the Lesson

Afterword

Index to Lessons

0789738244 TOC 3/12/2008

Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)