Picture 1 of 1
Picture 1 of 1
Power Excel 2010 with MrExcel(LiveLe
US $21.48
Condition:
Shipping:
Located in: Montgomery, Illinois, United States
Delivery:
Estimated between Tue, Jun 18 and Mon, Jun 24 to 43230
Returns:
Payments:
Special financing available. See terms and apply now- for PayPal Credit, opens in a new window or tab
Earn up to 5x points when you use your eBay Mastercard®. Learn moreabout earning points with eBay Mastercard
Shop with confidence
Seller assumes all responsibility for this listing.
eBay item number:276415950694
Item specifics
- Condition
- Brand
- Unbranded
- Book Title
- Power Excel 2010 with MrExcel(LiveLessons)
- MPN
- Does not apply
- ISBN
- 9780789743930
- Subject Area
- Computers
- Publication Name
- Power Excel 2010 with Mrexcel
- Item Length
- 7.7 in
- Publisher
- Pearson Education
- Subject
- Desktop Applications / Suites, Desktop Applications / Spreadsheets, Enterprise Applications / General
- Series
- Livelessons Ser.
- Publication Year
- 2010
- Type
- Textbook
- Format
- Video, 8 mm
- Language
- English
- Item Height
- 1.4 in
- Item Width
- 5.6 in
- Item Weight
- 3.1 Oz
About this product
Product Information
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 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 -
Product Identifiers
Publisher
Pearson Education
ISBN-10
0789743930
ISBN-13
9780789743930
eBay Product ID (ePID)
102984374
Product Key Features
Publication Name
Power Excel 2010 with Mrexcel
Format
Video, 8 mm
Language
English
Subject
Desktop Applications / Suites, Desktop Applications / Spreadsheets, Enterprise Applications / General
Series
Livelessons Ser.
Publication Year
2010
Type
Textbook
Subject Area
Computers
Dimensions
Item Length
7.7 in
Item Height
1.4 in
Item Width
5.6 in
Item Weight
3.1 Oz
Additional Product Features
Table of Content
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
Copyright Date
2011
Target Audience
Trade
Item description from the seller
Seller assumes all responsibility for this listing.
eBay item number:276415950694
Shipping and handling
Item location:
Montgomery, Illinois, United States
Ships to:
Canada, Mexico, United States
Excludes:
Africa, Asia, Barbados, Bermuda, Central America and Caribbean, Europe, French Guiana, French Polynesia, Greenland, Guadeloupe, Libya, Martinique, Middle East, New Caledonia, Oceania, Reunion, Russian Federation, Saint Pierre and Miquelon, South America, Southeast Asia, Ukraine, Venezuela
| Shipping and handling | To | Service | Delivery*See Delivery notes |
|---|---|---|---|
| Free shipping | United States | Economy Shipping (USPS Media MailTM) | Estimated between Tue, Jun 18 and Mon, Jun 24 to 43230 |
| US $4.95 | United States | Standard Shipping (DGM SmartMail Expedited) | Estimated between Mon, Jun 17 and Tue, Jun 18 to 43230 |
| US $10.95 | United States | Expedited Shipping (FedEx 2Day®) | Estimated between Fri, Jun 14 and Sat, Jun 15 to 43230 |
| Handling time |
|---|
| Will usually ship within 1 business day of receiving cleared payment. |
| Taxes |
|---|
| Taxes may be applicable at checkout. Learn moreLearn more about paying tax on eBay purchases. |
Return policy
| After receiving the item, contact seller within | Refund will be given as | Return shipping |
|---|---|---|
| 30 days | Money Back | Seller pays for return shipping |
Refer to eBay Return policyopens in a new tab or window for more details. You are covered by the eBay Money Back Guaranteeopens in a new tab or window if you receive an item that is not as described in the listing.
Payment details
Payment methods
Popular categories from this store
Seller feedback (5,976,617)
a***a (171)- Feedback left by buyer.
Past month
Verified purchase
This is an outstanding seller to deal with. Fair prices that are more than reasonable in this economy. The product is in better condition than described, a true value for my money. Packaged and shipped well shows seller has concern for the products he sells to arrive in excellent condition. The seller is friendly and communicates timely with his customers. I highly recommend this seller and would do business again anytime. Thank you.
5***u (3403)- Feedback left by buyer.
Past month
Verified purchase
🏆 SUPER STAR 🤩 AMAZING PHOTOS 🎯 ACCURATE DESCRIPTION ✏️ GENUINE PRODUCTS 💎 HIGH QUALITY 🍯 SUPER PRICES 💰 EASY TO WORK WITH 🍰 ECONOMY HANDLING ⏱️ FAST SHIPPING 🚀 BUBBLE PACKAGE 📦 ARRIVED WITHIN DAYS 🌎 EXCEPTIONAL COMMUNICATION 🎙️ OUTSTANDING CUSTOMER SERVICE 🛎️ GREAT SENSE OF HUMOR 🍿 TOTAL ASSET TO THE EBAY-ECO SYSTEM 🥇 SAVED SELLER 🎱 PROMT REPLY FOR RETURNS 🎯 WOULD BUY FROM AGAIN 🧲 UNDER PROMISES OVER DELIVERS ⛳️ MADE ME VERY HAPPY 🌈 LEFT POSITIVE FEEDBACK 🌼 THANK YOU! 😇 A+++
z***z (602)- Feedback left by buyer.
Past 6 months
Verified purchase
🏆 SUPER STAR 🤩 AMAZING PHOTOS 🎯 ACCURATE DESCRIPTION ✏️ GENUINE PRODUCTS 💎 HIGH QUALITY 🍯 SUPER PRICES 💰 EASY TO WORK WITH 🍰 ECONOMY HANDLING ⏱️ FAST SHIPPING 🚀 BUBBLE PACKAGE 📦 ARRIVED WITHIN DAYS 🌎 EXCEPTIONAL COMMUNICATION 🎙️ OUTSTANDING CUSTOMER SERVICE 🛎️ GREAT SENSE OF HUMOR 🍿 TOTAL ASSET TO THE EBAY-ECO SYSTEM 🥇 SAVED SELLER 🎱 PROMT REPLY FOR RETURNS 🎯 WOULD BUY FROM AGAIN 🧲 UNDER PROMISES OVER DELIVERS ⛳️ MADE ME VERY HAPPY 🌈 LEFT POSITIVE FEEDBACK 🌼 THANK YOU! 😇 A+++
Product ratings and reviews
More to explore :
- CD-ROM Fiction & Books,
- 2010-Now Publication Year Study CD-ROMs Prep,
- 2010-Now Publication Year CD-ROM Language Courses,
- CD-ROM Textbooks,
- CD-ROM Language Courses,
- Fiction CD-ROM Fiction & Books,
- CD-ROM Language Courses in English,
- Workbook CD-ROM Language Courses,
- Science Study CD-ROMs Prep,
- English Study CD-ROMs Prep