Power Excel 2010 with MrExcel LiveLessons (Video Training)

Power Excel 2010 with MrExcel LiveLessons (Video Training)

5 (2 ratings by Goodreads)
By (author) 

List price: US$28.99

Currently unavailable

We can notify you when this item is back in stock

Add to wishlist

AbeBooks may have this title (opens in new window).

Try AbeBooks

Description

7+ Hours of Video Instruction You've got Microsoft Excel 2010...now get the most out of it, faster and more easily than ever before! In 90 quick video lessons, Power Excel 2010 with MrExcel shows how to maximize your productivity with Microsoft Excel 2010's best tools and shortcuts. Expert Bill Jelen simplifies powerful features including PivotTables, PowerPivot, Sparklines, Goal Seek, Cell Styles, Color Scales, Icon Sets, Data Bars, Web Queries, Backstage View, and more! Get more done faster with customized workbooks, the Quick Access Toolbar, and keyboard shortcuts...control and analyze data more effectively...communicate more visually with new charting tools and SmartArt...and plenty more! Just watch: You'll master high-powered Microsoft Excel 2010 skills at your own pace-and get specific answers and solutions immediately, whenever you need them! For anyone who wants to master Microsoft Excel 2010 fast-from novices to experienced power users. Bill Jelen is MrExcel, as well as an Excel MVP. He is an accomplished Excel author and the principal behind the leading Excel website, MrExcel.com. As an Excel consultant, he has written Excel VBA solutions for hundreds of clients around the English-speaking world. His website hosts more than 12 million page views annually. Jelen is author of the five-star reviewed Guerilla Data Analysis Using Microsoft Excel, co-author of VBA and Macros for Microsoft Excel, co-author of Pivot Table Data Crunching, and author of Learn Excel From Mr. Excel. Part 1 Excel Interface1 - Ribbon, QAT, Mini Toolbar, Live Preview 2 - Finding Icons 3 - Customizing the Ribbon 4 - Backstage View 5 - Recent Documents 6 - Keyboard Shortcuts 7 - Zoom Slider and Page Layout 8 - Unlocking the Big Grid 9 - Data Entry Tricks 10 - Customize All Future Workbooks 11 - Copy Worksheets 12 - Change All Worksheets 13 - Arranging Windows 14 - Saving Workbook to PDF 15 - Saving Workbook to Excel Web App Part 2 Text Formulas16 - Drag the Fill Handle17 - Create Your Own Series18 - Joining Text19 - Rapid Formula Copy20 - Convert to Proper Case21 - Joining Dates22 - Formulas to Values23 - Breaking Apart Text24 - Parsing Fixed Width Part 3 Formulas25 - AutoSum Tricks26 - Formula Auditing27 - Three Ways of Entering Formulas28 - Relative Versus Absolute Formulas29 - Tables and Table Formulas30 - Discovering Functions31 - Goal Seek32 - IF Formulas33 - VLOOKUP34 - Date and Time Part 4 Sorting & Filtering35 - Data Preparation36 - One-Click Sorting37 - Sorting by Color38 - Sorting by Weekday39 - Rearranging Columns40 - Filter by Selection41 - Other ways to Filter42 - Remove Duplicates Part 5 Subtotals43 - Subtotals44 - Collapsing Subtotals45 - Copy Subtotals46 - Formatting Subtotals47 - Sorting Subtotals48 - Changing Sum to Count in 1 column49 - Data Consolidate50 - Easy-XL Part 6 Pivot Tables51 - Creating a Pivot Table52 - Changing a Pivot Table53 - Pivot Gotchas54 - Pivot Formatting55 - Drill Down56 - Pivot Calculations57 - Summarizing Dates58 - Pivot Sorting59 - Filtering Row Fields 60 - Top 10 Report61 - Filtering a Pivot Table with Slicers62 - Slicers on Two Pivot Tables63 - 50 Reports in 5 Seconds64 - Using GetPivotData Part 7 PowerPivot65 - Getting Data into PowerPivot66 - Adding Calculations in PowerPivot67 - Linking Tables in PowerPivot68 - Creating Pivot Table in PowerPivot69 - Sorting in PowerPivot Part 8 Charting and SmartArt70 - Creating and Formatting a Chart71 - Adding or Removing Chart Data72 - Saving Favorite Chart Settings73 - Charting Differing Orders of Magnitude74 - Pie Chart Tricks75 - Sparklines76 - Labeling Sparklines77 - Creating SmartArt78 - Smart Art Formulas Part 9 Visual Impact79 - Cell Styles and Document Themes80 - Color Scales, Icon Sets, Data Bars81 - Icons for Only a Subset82 - Paired Bar Charts with Negative Data Bars83 - Picture Tools and WordArt84 - Picture Background Removal85 - Insert Screen Clipping86 - Equation Editor Part 10 Tips & Tricks87 - Web Queries88 - Turn Data89 - Choose from a List90 - ToolTips for a Cell91 - Word Processing in Excel92 - Have a Talk with Excel LiveLessons Video Training series publishes hundreds of hands-on, expert-led video tutorials covering a wide selection of technology topics designed to teach you the skills you need to succeed. This professional and personal technology video series features world-leading author instructors published by your trusted technology brands: Addison-Wesley, Cisco Press, IBM Press, Pearson IT Certification, Prentice Hall, Sams, and Que. Topics include: IT Certification, Programming, Web Development, Mobile Development, Home & Office Technologies, Business & Management, and more. View All LiveLessons http://www.quepublishing.com/imprint/series_detail.aspx?st=87397
show more

Product details

  • DVD video
  • 139.7 x 195.58 x 33.02mm | 136.08g
  • Que Corporation,U.S.
  • United States
  • English
  • 0789743930
  • 9780789743930
  • 1,310,879

Back cover copy

For anyone who wants to master Microsoft Excel 2010 fast-from novices to experienced power users!Power Excel 2010 with MrExcel teaches the most sophisticated features and techniques visually: Just watch! You'll master high-powered Microsoft Excel 2010 skills at your own pace-and get specific answers and solutions immediately, whenever you need them!These practical videos simplify powerful features including Pivot Tables, Subtotals, Charting, Formulas, Data Visualizations, Consolidations, PowerPivot, Goal Seek, and Web Queries! Get more done faster with customized workbooks and keyboard shortcuts...control and analyze data more effectively... communicate visually with new charting tools and SmartArt...and plenty more!Bill Jelen, Excel MVP and host of MrExcel.com, has been using spreadsheets since 1985. A long-time regular guest on Call for Help with Leo Laporte, he has produced more than 1,200 episodes of his daily video podcast, "Learn Excel from MrExcel." His 30 books include Microsoft Excel 2010 In Depth, Charts and Graphs: Microsoft Excel 2010, and PowerPivot for the Data Analyst: Microsoft Excel 2010. He writes the monthly Excel column for Strategic Finance magazine, and leads half-day Power Excel seminars nationwide. 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 are DVD video courses organized into bite-sized, self-contained sessions-you'll learn key skills in as little as five minutes!
show more

Table of contents

Part 1 Excel Interface 1 - Ribbon, QAT, Mini Toolbar, Live Preview 2 - Finding Icons 3 - Customizing the Ribbon 4 - Backstage View 5 - Recent Documents 6 - Keyboard Shortcuts 7 - Zoom Slider and Page Layout 8 - Unlocking the Big Grid 9 - Data Entry Tricks 10 - Customize All Future Workbooks 11 - Copy Worksheets 12 - Change All Worksheets 13 - Arranging Windows 14 - Saving Workbook to PDF 15 - Saving Workbook to Excel Web App Part 2 Text Formulas 16 - Drag the Fill Handle 17 - Create Your Own Series 18 - Joining Text 19 - Rapid Formula Copy 20 - Convert to Proper Case 21 - Joining Dates 22 - Formulas to Values 23 - Breaking Apart Text 24 - Parsing Fixed Width Part 3 Formulas 25 - AutoSum Tricks 26 - Formula Auditing 27 - Three Ways of Entering Formulas 28 - Relative Versus Absolute Formulas 29 - Tables and Table Formulas 30 - Discovering Functions 31 - Goal Seek 32 - IF Formulas 33 - VLOOKUP 34 - Date and Time Part 4 Sorting & Filtering 35 - Data Preparation 36 - One-Click Sorting 37 - Sorting by Color 38 - Sorting by Weekday 39 - Rearranging Columns 40 - Filter by Selection 41 - Other ways to Filter 42 - Remove Duplicates Part 5 Subtotals 43 - Subtotals 44 - Collapsing Subtotals 45 - Copy Subtotals 46 - Formatting Subtotals 47 - Sorting Subtotals 48 - Changing Sum to Count in 1 column 49 - Data Consolidate 50 - Easy-XL Part 6 Pivot Tables 51 - Creating a Pivot Table 52 - Changing a Pivot Table 53 - Pivot Gotchas 54 - Pivot Formatting 55 - Drill Down 56 - Pivot Calculations 57 - Summarizing Dates 58 - Pivot Sorting 59 - Filtering Row Fields 60 - Top 10 Report 61 - Filtering a Pivot Table with Slicers 62 - Slicers on Two Pivot Tables 63 - 50 Reports in 5 Seconds 64 - Using GetPivotData Part 7 PowerPivot 65 - Getting Data into PowerPivot 66 - Adding Calculations in PowerPivot 67 - Linking Tables in PowerPivot 68 - Creating Pivot Table in PowerPivot 69 - Sorting in PowerPivot Part 8 Charting and SmartArt 70 - Creating and Formatting a Chart 71 - Adding or Removing Chart Data 72 - Saving Favorite Chart Settings 73 - Charting Differing Orders of Magnitude 74 - Pie Chart Tricks 75 - Sparklines 76 - Labeling Sparklines 77 - Creating SmartArt 78 - Smart Art Formulas Part 9 Visual Impact 79 - Cell Styles and Document Themes 80 - Color Scales, Icon Sets, Data Bars 81 - Icons for Only a Subset 82 - Paired Bar Charts with Negative Data Bars 83 - Picture Tools and WordArt 84 - Picture Background Removal 85 - Insert Screen Clipping 86 - Equation Editor Part 10 Tips & Tricks 87 - Web Queries 88 - Turn Data 89 - Choose from a List 90 - ToolTips for a Cell 91 - Word Processing in Excel 92 - Have a Talk with Excel
show more

About Bill Jelen

Bill Jelen is MrExcel, as well as an Excel MVP. He is an accomplished Excel author and the principal behind the leading Excel website, MrExcel.com. As an Excel consultant, he has written Excel VBA solutions for hundreds of clients around the English-speaking world. His website hosts more than 12 million page views annually. Jelen is author of the five-star reviewed Guerilla Data Analysis Using Microsoft Excel, co-author of VBA and Macros for Microsoft Excel, co-author of Pivot Table Data Crunching, and author of Learn Excel From Mr. Excel.
show more

Rating details

2 ratings
5 out of 5 stars
5 100% (2)
4 0% (0)
3 0% (0)
2 0% (0)
1 0% (0)
Book ratings by Goodreads
Goodreads is the world's largest site for readers with over 50 million reviews. We're featuring millions of their reader ratings on our book pages to help you find your new favourite book. Close X