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
Full Product Details
Author: Bill Jelen
Publisher: Pearson Education (US)
Imprint: Addison Wesley
Dimensions:
Width: 1.00cm
, Height: 1.00cm
, Length: 1.00cm
Weight: 0.086kg
ISBN: 9780133103977
ISBN 10: 0133103978
Publication Date: 23 July 2012
Audience:
College/higher education
,
Tertiary & Higher Education
Format: DVD-ROM
Publisher's Status: Active
Availability: Temporarily unavailable
The supplier advises that this item is temporarily unavailable. It will be ordered for you and placed on backorder. Once it does come back in stock, we will ship it out to you.
Author Information
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.
