Home > Computing and Information Technology > Business applications > Spreadsheet software > Power Excel 2007 with MrExcel (Video Training): (LiveLessons)
29%
Power Excel 2007 with MrExcel (Video Training): (LiveLessons)

Power Excel 2007 with MrExcel (Video Training): (LiveLessons)

          
5
4
3
2
1

Out of Stock


Premium quality
Premium quality
Bookswagon upholds the quality by delivering untarnished books. Quality, services and satisfaction are everything for us!
Easy Return
Easy return
Not satisfied with this product! Keep it in original condition and packaging to avail easy return policy.
Certified product
Certified product
First impression is the last impression! Address the book’s certification page, ISBN, publisher’s name, copyright page and print quality.
Secure Checkout
Secure checkout
Security at its finest! Login, browse, purchase and pay, every step is safe and secured.
Money back guarantee
Money-back guarantee:
It’s all about customers! For any kind of bad experience with the product, get your actual amount back after returning the product.
On time delivery
On-time delivery
At your doorstep on time! Get this book delivered without any delay.
Notify me when this book is in stock
Add to Wishlist

About the Book

Power Excel 2007 with MrExcel   Mastering the Smartest, Fastest Ways to Use Excel 2007   Bill Jelen   For anyone who wants to get more done in less time with Excel 2007—from entrepreneurs to financial analysts, marketers to office managers!   Bill Jelen (“MrExcel”) presents focused, practical videos that teach you Excel 2007’s best new techniques: supercharged solutions for charting, calculating, formatting, data analysis, automation, and a whole lot more! Click play to follow along as Jelen walks you through using Excel 2007’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 more than 90 quick video lessons, Bill Jelen (“MrExcel”) shows you all you need to maximize your productivity with Excel 2007.   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 Excel 2007’s new Ribbon interface and most powerful techniques at your own pace—and get  specific answers and solutions immediately, whenever you need them!   These practical, easy-to-use videos cover Excel 2007’s hottest new features: everything from charting improvements to conditional formatting, filtering to SmartArt. You’ll find up-to-the-minute tips and tricks for using PivotTables, managing and automating worksheets, and a whole lot more—great new solutions 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.   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   Contents:   Part 1 Excel 2007 Interface Lesson 1 Introducing the Ribbon Lesson 2 Quick Access Toolbar Lesson 3 Finding Icons Lesson 4 Keyboard Shortcuts Lesson 5 Mini Toolbar and Live Preview Lesson 6 Zoom Slider and Page Layout Lesson 7 Recent Documents Lesson 8 Save as PDF Lesson 9 Excel Options Lesson 10 Opening Templates, Closing Excel Part 2 Excel 2007 New Features Lesson 11 Unlocking the Big Grid, File Formats Lesson 12 Cell Styles and Themes Lesson 13 Data Visualizations Lesson 14 Tables and Table Formulas Lesson 15 Sort and Filter by Color Lesson 16 Duplicates Lesson 17 Picture Tools and WordArt Lesson 18 New Features Part 3 Text Lesson 19 Drag the Fill Handle to Extend a Series Lesson 20 Create Your Own Series Lesson 21 Joining Text Lesson 22 Rapid Formula Copy Lesson 23 Convert to Proper Case Lesson 24 Joining Dates Lesson 25 Converting Formulas to Values Lesson 26 Breaking Apart Text Lesson 27 Parsing Fixed Width Part 4 Excel Customizations Lesson 28 Data Entry Tricks Lesson 29 Customize All Future Workbooks Lesson 30 Copy Worksheets Lesson 31 Change All Worksheets Lesson 32 Arranging Windows Part 5 Sorting and Subtotals Lesson 33 Data Preparation Lesson 34 Sorting Basics Lesson 35 Random Sort Lesson 36 Sorting by Weekday Lesson 37 Rearranging Columns Lesson 38 Subtotals Lesson 39 Collapsing Subtotals Lesson 40 Copy Subtotals Lesson 41 Formatting Subtotals Lesson 42 Multiple Subtotals Lesson 43 Filling In Data on Subtotal Rows Lesson 44 Subtotal Tricks Part 6 Pivot Tables Lesson 45 Creating a Pivot Table Lesson 46 Changing a Pivot Table Lesson 47 Pivot Gotchas Lesson 48 Pivot Sorting Lesson 49 Drill Down Lesson 50 Summarizing Dates Lesson 51 Top 10 Report Lesson 52 Pivot Calculations Lesson 53 Pivot Formatting Lesson 54 Unique List Lesson 55 Ad-Hoc Queries Lesson 56 New Filtering Options Lesson 57 50 Reports in 5 Seconds Lesson 58 Pivot Compatibility Lesson 59 Making Reports Pivotable Part 7 Charting and SmartArt Lesson 60 Creating and Formatting a Chart Lesson 61 Adding or Removing Chart Data Lesson 62 Interactive Chart Lesson 63 Charting Differing Orders of Magnitude Lesson 64 Pie Chart Tricks, Histograms Lesson 65 XY and Bubble Charts Lesson 66 Saving Favorite Chart Settings Lesson 67 Creating Smart Art Lesson 68 Formulas in Smart Art Part 8 Formulas Lesson 69 AutoSum Tricks Lesson 70 Formula Auditing Lesson 71 Three Ways of Entering Formulas Lesson 72 Relative Versus Absolute Formulas Lesson 73 Discovering Functions Lesson 74 Goal Seek Lesson 75 Unusual Functions Lesson 76 IF Formulas Lesson 77 VLOOKUP Lesson 78 IFERROR Lesson 79 SUMIFS Lesson 80 Super Formulas Lesson 81 Date and Time Part 9 Macros Lesson 82 Recording a Macro Lesson 83 Recording Navigation Lesson 84 How Many Rows? Lesson 85 Event Macros Part 10 Tips and Tricks Lesson 86 Finding Records Lesson 87 Web Queries Lesson 88 Copying Column Widths Lesson 89 Page Numbering Lesson 90 Turn Data Lesson 91 & in Header Lesson 92 Choose from a List Lesson 93 Tool Tips for a Cell Lesson 94 Word Processing in Excel Lesson 95 Have a Talk with Excel  

Table of Contents:
Introduction Part 1 Excel 2007 Interface Lesson 1 Introducing the Ribbon What You Will Learn Related Lessons Notes from the Lesson Lesson 2 Quick Access Toolbar What You Will Learn More Details Notes from the Lesson Lesson 3 Finding Icons What You Will Learn Related Lessons Notes from the Lesson Lesson 4 Keyboard Shortcuts What You Will Learn Related Lessons Notes from the Lesson Lesson 5 Mini Toolbar and Live Preview What You Will Learn Related Lessons Notes from the Lesson Lesson 6 Zoom Slider and Page Layout What You Will Learn Notes from the Lesson Lesson 7 Recent Documents What You Will Learn Related Lessons Notes from the Lesson Lesson 8 Save as PDF What You Will Learn Notes from the Lesson Lesson 9 Excel Options What You Will Learn Related Lessons Notes from the Lesson Lesson 10 Opening Templates, Closing Excel What You Will Learn Related Lessons Notes from the Lesson Part 2 Excel 2007 New Features Lesson 11 Unlocking the Big Grid, File Formats What You Will Learn Notes from the Lesson Lesson 12 Cell Styles and Themes What You Will Learn Notes from the Lesson Lesson 13 Data Visualizations What You Will Learn Notes from the Lesson Lesson 14 Tables and Table Formulas What You Will Learn Related Lessons Notes from the Lesson Lesson 15 Sort and Filter by Color What You Will Learn Related Lessons Notes from the Lesson Lesson 16 Duplicates What You Will Learn Related Lessons Notes from the Lesson Lesson 17 Picture Tools and WordArt What You Will Learn Notes from the Lesson Lesson 18 New Features What You Will Learn Related Lessons Notes from the Lesson Part 3 Text Lesson 19 Drag the Fill Handle to Extend a Series What You Will Learn Related Lessons Notes from the Lesson Lesson 20 Create Your Own Series What You Will Learn Related Lessons Notes from the Lesson Lesson 21 Joining Text What You Will Learn Related Lessons Notes from the Lesson Lesson 22 Rapid Formula Copy What You Will Learn Related Lessons Notes from the Lesson Lesson 23 Convert to Proper Case What You Will Learn Notes from the Lesson Lesson 24 Joining Dates What You Will Learn Related Lessons Notes from the Lesson Lesson 25 Converting Formulas to Values What You Will Learn Notes from the Lesson Lesson 26 Breaking Apart Text What You Will Learn Related Lessons Notes from the Lesson Lesson 27 Parsing Fixed Width What You Will Learn Related Lessons Notes from the Lesson Part 4 Excel Customizations Lesson 28 Data Entry Tricks What You Will Learn Notes from the Lesson Lesson 29 Customize All Future Workbooks What You Will Learn Related Lessons Notes from the Lesson Lesson 30 Copy Worksheets What You Will Learn Notes from the Lesson Lesson 31 Change All Worksheets What You Will Learn Related Lessons Notes from the Lesson Lesson 32 Arranging Windows What You Will Learn Notes from the Lesson Part 5 Sorting and Subtotals Lesson 33 Data Preparation What You Will Learn Notes from the Lesson Lesson 34 Sorting Basics What You Will Learn Related Lessons Notes from the Lesson Lesson 35 Random Sort What You Will Learn Related Lessons Notes from the Lesson Lesson 36 Sorting by Weekday What You Will Learn Related Lessons Notes from the Lesson Lesson 37 Rearranging Columns What You Will Learn Related Lessons Notes from the Lesson Lesson 38 Subtotals What You Will Learn Related Lessons Notes from the Lesson Lesson 39 Collapsing Subtotals What You Will Learn Related Lessons Notes from the Lesson Lesson 40 Copy Subtotals What You Will Learn Related Lessons Notes from the Lesson Lesson 41 Formatting Subtotals What You Will Learn Related Lessons Notes from the Lesson Lesson 42 Multiple Subtotals What You Will Learn More Details Notes from the Lesson Lesson 43 Filling In Data on Subtotal Rows What You Will Learn Related Lessons Notes from the Lesson Lesson 44 Subtotal Tricks What You Will Learn Notes from the Lesson Part 6 Pivot Tables Lesson 45 Creating a Pivot Table What You Will Learn Related Lessons Notes from the Lesson Lesson 46 Changing a Pivot Table What You Will Learn Related Lessons Notes from the Lesson Lesson 47 Pivot Gotchas What You Will Learn Notes from the Lesson Lesson 48 Pivot Sorting What You Will Learn Notes from the Lesson Lesson 49 Drill Down What You Will Learn Notes from the Lesson Lesson 50 Summarizing Dates What You Will Learn Related Lessons Notes from the Lesson Lesson 51 Top 10 Report What You Will Learn Related Lessons Notes from the Lesson Lesson 52 Pivot Calculations What You Will Learn Notes from the Lesson Lesson 53 Pivot Formatting What You Will Learn Related Lessons Notes from the Lesson Lesson 54 Unique List What You Will Learn Related Lessons Notes from the Lesson Lesson 55 Ad-Hoc Queries What You Will Learn Related Lessons Notes from the Lesson Lesson 56 New Filtering Options 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 Pivot Compatibility What You Will Learn Notes from the Lesson Lesson 59 Making Reports Pivotable What You Will Learn Notes from the Lesson Part 7 Charting and SmartArt Lesson 60 Creating and Formatting a Chart What You Will Learn Related Lessons Notes from the Lesson Lesson 61 Adding or Removing Chart Data What You Will Learn Notes from the Lesson Lesson 62 Interactive Chart What You Will Learn Related Lessons Notes from the Lesson Lesson 63 Charting Differing Orders of Magnitude What You Will Learn Notes from the Lesson Lesson 64 Pie Chart Tricks, Histograms What You Will Learn Notes from the Lesson Lesson 65 XY and Bubble Charts What You Will Learn Notes from the Lesson Lesson 66 Saving Favorite Chart Settings What You Will Learn Related Lessons Notes from the Lesson Lesson 67 Creating Smart Art What You Will Learn Related Lessons Notes from the Lesson Lesson 68 Formulas in Smart Art What You Will Learn Related Lessons Notes from the Lesson Part 8 Formulas Lesson 69 AutoSum Tricks What You Will Learn Notes from the Lesson Lesson 70 Formula Auditing What You Will Learn Notes from the Lesson Lesson 71 Three Ways of Entering Formulas What You Will Learn Related Lessons Notes from the Lesson Lesson 72 Relative Versus Absolute Formulas What You Will Learn Notes from the Lesson Lesson 73 Discovering Functions What You Will Learn Notes from the Lesson Lesson 74 Goal Seek What You Will Learn Notes from the Lesson Lesson 75 Unusual Functions What You Will Learn Related Lessons Notes from the Lesson Lesson 76 IF Formulas What You Will Learn Related Lessons Notes from the Lesson Lesson 77 VLOOKUP What You Will Learn Notes from the Lesson Lesson 78 IFERROR What You Will Learn Notes from the Lesson Lesson 79 SUMIFS What You Will Learn Related Lessons Notes from the Lesson Lesson 80 Super Formulas What You Will Learn Notes from the Lesson Lesson 81 Date and Time What You Will Learn Notes from the Lesson Part 9 Macros Lesson 82 Recording a Macro What You Will Learn Related Lessons Notes from the Lesson Lesson 83 Recording Navigation What You Will Learn Related Lessons Notes from the Lesson Lesson 84 How Many Rows? What You Will Learn Related Lessons Notes from the Lesson Lesson 85 Event Macros What You Will Learn Related Lessons Notes from the Lesson Part 10 Tips and Tricks Lesson 86 Finding Records What You Will Learn Related Lessons Notes from the Lesson Lesson 87 Web Queries What You Will Learn Notes from the Lesson Lesson 88 Copying Column Widths What You Will Learn Notes from the Lesson Lesson 89 Page Numbering What You Will Learn Related Lessons Notes from the Lesson Lesson 90 Turn Data What You Will Learn Notes from the Lesson Lesson 91 & in Header What You Will Learn Notes from the Lesson Lesson 92 Choose from a List What You Will Learn Notes from the Lesson Lesson 93 Tool Tips for a Cell What You Will Learn Notes from the Lesson Lesson 94 Word Processing in Excel What You Will Learn Notes from the Lesson Lesson 95 Have a Talk with Excel What You Will Learn Notes from the Lesson Afterword     0789738252   TOC   3/21/2008


Best Sellers


Product Details
  • ISBN-13: 9780789738257
  • Publisher: Pearson Education (US)
  • Publisher Imprint: Que Corporation,U.S.
  • Depth: 25
  • Height: 234 mm
  • No of Pages: 128
  • Series Title: LiveLessons
  • Sub Title: Mastering the Smartest, Fastest Ways to Use Excel 2007
  • Width: 189 mm
  • ISBN-10: 0789738252
  • Publisher Date: 15 May 2008
  • Binding: SF
  • Edition: 1 PAP/DVD
  • Language: English
  • Returnable: N
  • Spine Width: 27 mm
  • Weight: 378 gr


Similar Products

How would you rate your experience shopping for books on Bookswagon?

Add Photo
Add Photo

Customer Reviews

REVIEWS           
Click Here To Be The First to Review this Product
Power Excel 2007 with MrExcel (Video Training): (LiveLessons)
Pearson Education (US) -
Power Excel 2007 with MrExcel (Video Training): (LiveLessons)
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 2007 with MrExcel (Video Training): (LiveLessons)

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!
    ASK VIDYA