Power Excel 2003 with MrExcel LiveLessons (Video Training)
Home > Computing and Information Technology > Business applications > Spreadsheet software > Power Excel 2003 with MrExcel LiveLessons (Video Training)
Power Excel 2003 with MrExcel LiveLessons (Video Training)

Power Excel 2003 with MrExcel LiveLessons (Video Training)

|
     0     
5
4
3
2
1




Out of Stock


Notify me when this book is in stock
About the Book

<>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  

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


Best Sellers


Product Details
  • ISBN-13: 9780789738240
  • Publisher: Pearson Education (US)
  • Publisher Imprint: Que Corporation,U.S.
  • Height: 191 mm
  • No of Pages: 128
  • Weight: 372 gr
  • ISBN-10: 0789738244
  • Publisher Date: 08 May 2008
  • Binding: SA
  • Language: English
  • Spine Width: 27 mm
  • Width: 233 mm


Similar Products

Add Photo
Add Photo

Customer Reviews

REVIEWS      0     
Click Here To Be The First to Review this Product
Power Excel 2003 with MrExcel LiveLessons (Video Training)
Pearson Education (US) -
Power Excel 2003 with MrExcel LiveLessons (Video Training)
Writing guidlines
We want to publish your review, so please:
  • keep your review on the product. Review's that defame author's character will be rejected.
  • Keep your review focused on the product.
  • Avoid writing about customer service. contact us instead if you have issue requiring immediate attention.
  • Refrain from mentioning competitors or the specific price you paid for the product.
  • Do not include any personally identifiable information, such as full names.

Power Excel 2003 with MrExcel LiveLessons (Video Training)

Required fields are marked with *

Review Title*
Review
    Add Photo Add up to 6 photos
    Would you recommend this product to a friend?
    Tag this Book Read more
    Does your review contain spoilers?
    What type of reader best describes you?
    I agree to the terms & conditions
    You may receive emails regarding this submission. Any emails will include the ability to opt-out of future communications.

    CUSTOMER RATINGS AND REVIEWS AND QUESTIONS AND ANSWERS TERMS OF USE

    These Terms of Use govern your conduct associated with the Customer Ratings and Reviews and/or Questions and Answers service offered by Bookswagon (the "CRR Service").


    By submitting any content to Bookswagon, you guarantee that:
    • You are the sole author and owner of the intellectual property rights in the content;
    • All "moral rights" that you may have in such content have been voluntarily waived by you;
    • All content that you post is accurate;
    • You are at least 13 years old;
    • Use of the content you supply does not violate these Terms of Use and will not cause injury to any person or entity.
    You further agree that you may not submit any content:
    • That is known by you to be false, inaccurate or misleading;
    • That infringes any third party's copyright, patent, trademark, trade secret or other proprietary rights or rights of publicity or privacy;
    • That violates any law, statute, ordinance or regulation (including, but not limited to, those governing, consumer protection, unfair competition, anti-discrimination or false advertising);
    • That is, or may reasonably be considered to be, defamatory, libelous, hateful, racially or religiously biased or offensive, unlawfully threatening or unlawfully harassing to any individual, partnership or corporation;
    • For which you were compensated or granted any consideration by any unapproved third party;
    • That includes any information that references other websites, addresses, email addresses, contact information or phone numbers;
    • That contains any computer viruses, worms or other potentially damaging computer programs or files.
    You agree to indemnify and hold Bookswagon (and its officers, directors, agents, subsidiaries, joint ventures, employees and third-party service providers, including but not limited to Bazaarvoice, Inc.), harmless from all claims, demands, and damages (actual and consequential) of every kind and nature, known and unknown including reasonable attorneys' fees, arising out of a breach of your representations and warranties set forth above, or your violation of any law or the rights of a third party.


    For any content that you submit, you grant Bookswagon a perpetual, irrevocable, royalty-free, transferable right and license to use, copy, modify, delete in its entirety, adapt, publish, translate, create derivative works from and/or sell, transfer, and/or distribute such content and/or incorporate such content into any form, medium or technology throughout the world without compensation to you. Additionally,  Bookswagon may transfer or share any personal information that you submit with its third-party service providers, including but not limited to Bazaarvoice, Inc. in accordance with  Privacy Policy


    All content that you submit may be used at Bookswagon's sole discretion. Bookswagon reserves the right to change, condense, withhold publication, remove or delete any content on Bookswagon's website that Bookswagon deems, in its sole discretion, to violate the content guidelines or any other provision of these Terms of Use.  Bookswagon does not guarantee that you will have any recourse through Bookswagon to edit or delete any content you have submitted. Ratings and written comments are generally posted within two to four business days. However, Bookswagon reserves the right to remove or to refuse to post any submission to the extent authorized by law. You acknowledge that you, not Bookswagon, are responsible for the contents of your submission. None of the content that you submit shall be subject to any obligation of confidence on the part of Bookswagon, its agents, subsidiaries, affiliates, partners or third party service providers (including but not limited to Bazaarvoice, Inc.)and their respective directors, officers and employees.

    Accept

    New Arrivals

    Inspired by your browsing history


    Your review has been submitted!

    You've already reviewed this product!