{"product_id":"9780789738257","title":"Power Excel 2007 with MrExcel (Video Training)","description":"\u003cp\u003ePower Excel 2007 with MrExcel\u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e\u003cp\u003eMastering the Smartest, Fastest Ways to Use Excel 2007\u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e\u003cp\u003eBill Jelen\u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e\u003cp\u003eFor anyone who wants to get more done in less time with Excel 2007—from entrepreneurs to financial analysts, marketers to office managers!\u003c\/p\u003e\u003cp\u003eBill 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!\u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e\u003cp\u003eYou’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. \u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e\u003cp\u003eBuilding 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! \u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e\u003cp\u003eThese 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!\u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e\u003cp\u003eLooking 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.\u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e\u003cp\u003e \u003c\/p\u003e\u003cul\u003e \u003cli\u003eLiveLessons is an eight-hour video course organized into bite-sized, self-contained sessions—you’ll learn key skills in as little as five minutes! \u003c\/li\u003e \u003cli\u003e Each session begins with well-defined learning objectives and ends with comprehensive summaries, which help you track your progress. \u003c\/li\u003e \u003cli\u003eFollow along as your instructor shows exactly how to get great results in your real-world environment.\u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003e\u003c\/p\u003e\u003cp\u003eBill 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 \u003c\/p\u003e\u003cp\u003e\u003ci\u003eThe Lab with Leo Laporte\u003c\/i\u003e. 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 \u003ci\u003eStrategic Finance\u003c\/i\u003e magazine.\u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e\u003cp\u003eMicrosoft Office Spreadsheets\/Desktop Applications\u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e\u003cp\u003e \u003cu\u003e \u003c\/u\u003e\u003c\/p\u003e\u003cp\u003eContents:\u003c\/p\u003e\u003cp\u003e  \u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e\u003cp\u003e \u003cb\u003ePart 1 Excel 2007 Interface\u003c\/b\u003e \u003c\/p\u003e\u003cp\u003eLesson 1 Introducing the Ribbon\u003c\/p\u003e\u003cp\u003eLesson 2 Quick Access Toolbar\u003c\/p\u003e\u003cp\u003eLesson 3 Finding Icons\u003c\/p\u003e\u003cp\u003eLesson 4 Keyboard Shortcuts\u003c\/p\u003e\u003cp\u003eLesson 5 Mini Toolbar and Live Preview\u003c\/p\u003e\u003cp\u003eLesson 6 Zoom Slider and Page Layout\u003c\/p\u003e\u003cp\u003eLesson 7 Recent Documents\u003c\/p\u003e\u003cp\u003eLesson 8 Save as PDF\u003c\/p\u003e\u003cp\u003eLesson 9 Excel Options\u003c\/p\u003e\u003cp\u003eLesson 10 Opening Templates, Closing Excel\u003c\/p\u003e\u003cp\u003e\u003cb\u003ePart 2 Excel 2007 New Features\u003c\/b\u003e \u003c\/p\u003e\u003cp\u003eLesson 11 Unlocking the Big Grid, File Formats\u003c\/p\u003e\u003cp\u003eLesson 12 Cell Styles and Themes\u003c\/p\u003e\u003cp\u003eLesson 13 Data Visualizations\u003c\/p\u003e\u003cp\u003eLesson 14 Tables and Table Formulas\u003c\/p\u003e\u003cp\u003eLesson 15 Sort and Filter by Color\u003c\/p\u003e\u003cp\u003eLesson 16 Duplicates\u003c\/p\u003e\u003cp\u003eLesson 17 Picture Tools and WordArt\u003c\/p\u003e\u003cp\u003eLesson 18 New Features\u003c\/p\u003e\u003cp\u003e\u003cb\u003ePart 3 Text\u003c\/b\u003e \u003c\/p\u003e\u003cp\u003eLesson 19 Drag the Fill Handle to Extend a Series\u003c\/p\u003e\u003cp\u003eLesson 20 Create Your Own Series\u003c\/p\u003e\u003cp\u003eLesson 21 Joining Text\u003c\/p\u003e\u003cp\u003eLesson 22 Rapid Formula Copy\u003c\/p\u003e\u003cp\u003eLesson 23 Convert to Proper Case\u003c\/p\u003e\u003cp\u003eLesson 24 Joining Dates\u003c\/p\u003e\u003cp\u003eLesson 25 Converting Formulas to Values\u003c\/p\u003e\u003cp\u003eLesson 26 Breaking Apart Text\u003c\/p\u003e\u003cp\u003eLesson 27 Parsing Fixed Width\u003c\/p\u003e\u003cp\u003e\u003cb\u003ePart 4 Excel Customizations\u003c\/b\u003e \u003c\/p\u003e\u003cp\u003eLesson 28 Data Entry Tricks\u003c\/p\u003e\u003cp\u003eLesson 29 Customize All Future Workbooks\u003c\/p\u003e\u003cp\u003eLesson 30 Copy Worksheets\u003c\/p\u003e\u003cp\u003eLesson 31 Change All Worksheets\u003c\/p\u003e\u003cp\u003eLesson 32 Arranging Windows\u003c\/p\u003e\u003cp\u003e\u003cb\u003ePart 5 Sorting and Subtotals\u003c\/b\u003e \u003c\/p\u003e\u003cp\u003eLesson 33 Data Preparation\u003c\/p\u003e\u003cp\u003eLesson 34 Sorting Basics\u003c\/p\u003e\u003cp\u003eLesson 35 Random Sort\u003c\/p\u003e\u003cp\u003eLesson 36 Sorting by Weekday\u003c\/p\u003e\u003cp\u003eLesson 37 Rearranging Columns\u003c\/p\u003e\u003cp\u003eLesson 38 Subtotals\u003c\/p\u003e\u003cp\u003eLesson 39 Collapsing Subtotals\u003c\/p\u003e\u003cp\u003eLesson 40 Copy Subtotals\u003c\/p\u003e\u003cp\u003eLesson 41 Formatting Subtotals\u003c\/p\u003e\u003cp\u003eLesson 42 Multiple Subtotals\u003c\/p\u003e\u003cp\u003eLesson 43 Filling In Data on Subtotal Rows\u003c\/p\u003e\u003cp\u003eLesson 44 Subtotal Tricks\u003c\/p\u003e\u003cp\u003e\u003cb\u003ePart 6 Pivot Tables\u003c\/b\u003e \u003c\/p\u003e\u003cp\u003eLesson 45 Creating a Pivot Table\u003c\/p\u003e\u003cp\u003eLesson 46 Changing a Pivot Table\u003c\/p\u003e\u003cp\u003eLesson 47 Pivot Gotchas\u003c\/p\u003e\u003cp\u003eLesson 48 Pivot Sorting\u003c\/p\u003e\u003cp\u003eLesson 49 Drill Down\u003c\/p\u003e\u003cp\u003eLesson 50 Summarizing Dates\u003c\/p\u003e\u003cp\u003eLesson 51 Top 10 Report\u003c\/p\u003e\u003cp\u003eLesson 52 Pivot Calculations\u003c\/p\u003e\u003cp\u003eLesson 53 Pivot Formatting\u003c\/p\u003e\u003cp\u003eLesson 54 Unique List\u003c\/p\u003e\u003cp\u003eLesson 55 Ad-Hoc Queries\u003c\/p\u003e\u003cp\u003eLesson 56 New Filtering Options\u003c\/p\u003e\u003cp\u003eLesson 57 50 Reports in 5 Seconds\u003c\/p\u003e\u003cp\u003eLesson 58 Pivot Compatibility\u003c\/p\u003e\u003cp\u003eLesson 59 Making Reports Pivotable\u003c\/p\u003e\u003cp\u003e\u003cb\u003ePart 7 Charting and SmartArt\u003c\/b\u003e \u003c\/p\u003e\u003cp\u003eLesson 60 Creating and Formatting a Chart\u003c\/p\u003e\u003cp\u003eLesson 61 Adding or Removing Chart Data\u003c\/p\u003e\u003cp\u003eLesson 62 Interactive Chart\u003c\/p\u003e\u003cp\u003eLesson 63 Charting Differing Orders of Magnitude\u003c\/p\u003e\u003cp\u003eLesson 64 Pie Chart Tricks, Histograms\u003c\/p\u003e\u003cp\u003eLesson 65 XY and Bubble Charts\u003c\/p\u003e\u003cp\u003eLesson 66 Saving Favorite Chart Settings\u003c\/p\u003e\u003cp\u003eLesson 67 Creating Smart Art\u003c\/p\u003e\u003cp\u003eLesson 68 Formulas in Smart Art\u003c\/p\u003e\u003cp\u003e\u003cb\u003ePart 8 Formulas\u003c\/b\u003e \u003c\/p\u003e\u003cp\u003eLesson 69 AutoSum Tricks\u003c\/p\u003e\u003cp\u003eLesson 70 Formula Auditing\u003c\/p\u003e\u003cp\u003eLesson 71 Three Ways of Entering Formulas\u003c\/p\u003e\u003cp\u003eLesson 72 Relative Versus Absolute Formulas\u003c\/p\u003e\u003cp\u003eLesson 73 Discovering Functions\u003c\/p\u003e\u003cp\u003eLesson 74 Goal Seek\u003c\/p\u003e\u003cp\u003eLesson 75 Unusual Functions\u003c\/p\u003e\u003cp\u003eLesson 76 IF Formulas\u003c\/p\u003e\u003cp\u003eLesson 77 VLOOKUP\u003c\/p\u003e\u003cp\u003eLesson 78 IFERROR\u003c\/p\u003e\u003cp\u003eLesson 79 SUMIFS\u003c\/p\u003e\u003cp\u003eLesson 80 Super Formulas\u003c\/p\u003e\u003cp\u003eLesson 81 Date and Time\u003c\/p\u003e\u003cp\u003e\u003cb\u003ePart 9 Macros\u003c\/b\u003e \u003c\/p\u003e\u003cp\u003eLesson 82 Recording a Macro\u003c\/p\u003e\u003cp\u003eLesson 83 Recording Navigation\u003c\/p\u003e\u003cp\u003eLesson 84 How Many Rows?\u003c\/p\u003e\u003cp\u003eLesson 85 Event Macros\u003c\/p\u003e\u003cp\u003e\u003cb\u003ePart 10 Tips and Tricks\u003c\/b\u003e \u003c\/p\u003e\u003cp\u003eLesson 86 Finding Records\u003c\/p\u003e\u003cp\u003eLesson 87 Web Queries\u003c\/p\u003e\u003cp\u003eLesson 88 Copying Column Widths\u003c\/p\u003e\u003cp\u003eLesson 89 Page Numbering\u003c\/p\u003e\u003cp\u003eLesson 90 Turn Data\u003c\/p\u003e\u003cp\u003eLesson 91 \u0026amp; in Header\u003c\/p\u003e\u003cp\u003eLesson 92 Choose from a List\u003c\/p\u003e\u003cp\u003eLesson 93 Tool Tips for a Cell\u003c\/p\u003e\u003cp\u003eLesson 94 Word Processing in Excel\u003c\/p\u003e\u003cp\u003eLesson 95 Have a Talk with Excel\u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e","brand":"Que","offers":[{"title":"Default Title","offer_id":47007516459248,"sku":"9780789738257","price":39.99,"currency_code":"USD","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0737\/7593\/9824\/files\/9780789738257_p0.jpg?v=1763806738","url":"https:\/\/shop-qa.barnesandnoble.com\/products\/9780789738257","provider":"Barnes \u0026 Noble (DEV)","version":"1.0","type":"link"}