Power Excel 2003 with MrExcel LiveLessons (Video Training)
Addison Wesley (Hersteller)
978-0-13-310397-7 (ISBN)
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
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.
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
| Erscheint lt. Verlag | 23.7.2012 |
|---|---|
| Reihe/Serie | LiveLessons |
| Verlagsort | Boston |
| Sprache | englisch |
| Maße | 10 x 10 mm |
| Gewicht | 86 g |
| Themenwelt | Informatik ► Office Programme ► Excel |
| ISBN-10 | 0-13-310397-8 / 0133103978 |
| ISBN-13 | 978-0-13-310397-7 / 9780133103977 |
| Zustand | Neuware |
| Haben Sie eine Frage zum Produkt? |
