This listing has ended. The seller has relisted this item or one like this.

Posts to:
Posts to:

Details about  Microsoft Excel 2013 (Mastering Shortcuts) - Video Training DVD

Microsoft Excel 2013 (Mastering Shortcuts) - Video Training DVD See original listing
Item Ended
Item condition:
Brand New
16 Mar, 2014 03:02:40 AEDST
GBP 9.95
Approximately AU $17.90
GBP 4.95 (approx. AU $8.91) Royal Mail International Standard (Small Packets) | See details
Item location:
Sheffield, South Yorkshire, United Kingdom


eBay item number:
Seller assumes all responsibility for this listing.

Item specifics

Brand New: A brand-new, unused, unopened and undamaged item. See the seller's listing for full details. See all condition definitions- opens in a new window or tab





Office Software Suites

Distribution Media:



Linux, Mac, Windows

*** Microsoft Excel 2013 (Mastering Shortcuts) – Video Training DVD ***











·        Almost 3.5 hours of in-depth yet simple, easy to understand tutorials.

·        10 main categories with 64 professionally put together, fully narrated step by step video tutorials.

·        This is the most comprehensive and only tutorial you will ever need, covering every aspect of Mastering Shortcuts in Excel 2013.

·        Learn at your own pace and achieve personal satisfaction when you have perfected your task.

·        This DVD comes with ALL EXERCISE FILES enabling complete user interaction with the tutorials.

·        Supplied, on a fully printed, top quality Maxell DVD and complete with a plastic protection wallet – this item IS NOT boxed.

·        This DVD is only suitable for a PC/laptop/Mac; it WILL NOT play on a TV (VLC Media Player will need to be installed to enable use on a Mac).

·        See below for a full list of contents on this tutorial DVD.






Introduction 2m 1s

Welcome 59s  

What you should know before watching this course 25s  

Using the exercise files 37s  

1. Top Ten Shortcuts 32m 35s

Entering numbers with leading zeros 4m 15s  

Entering a data series using the fill handle 4m 40s  

Adding text to a number format 2m 57s  

Printing a sheet on a set number of pages 2m 51s  

Using an Excel table column as a named range 3m 17s  

Numbering rows in a range or table 2m 44s  

Creating hyperlinks to other resources 3m 37s  

Analyzing data using the Quick Analysis Lens 2m 55s  

Super-hiding worksheets 3m 39s  

Creating recommended PivotTables 1m 40s  

2. Controlling the Excel Program and Interface 16m 33s

Controlling the user interface using your keyboard 3m 26s  

Customizing the Ribbon 4m 57s  

Customizing the Quick Access Toolbar 3m 46s  

Finding commands not on the Ribbon 2m 16s  

Hiding sheet tabs and scrollbars 2m 8s  

3. Managing Workbooks and Worksheets 13m 48s

Moving among worksheets quickly 1m 57s  

Displaying a workbook's full path 2m 6s  

Setting the number of worksheets in a workbook 1m 59s  

Limiting a worksheet's scroll area 2m 26s  

Setting a print area 2m 32s  

Zooming in or out quickly 2m 48s  

4. Organizing Data 22m 59s

Creating a custom view 4m 16s  

Creating a table using Ctrl+L 2m 54s  

Applying a table style and replacing existing formatting 2m 48s  

Creating a linked picture of a range 3m 26s  

Finding a target value 3m 24s  

Creating substitute data sets using scenarios 6m 11s  

5. Entering and Formatting Data 24m 22s

Entering a line break in a cell 1m 54s  

Wrapping and shrinking cell text 2m 32s  

Entering data into every cell in a range 2m 39s  

Picking data from a list 1m 40s  

Entering data into cells across multiple sheets 2m 26s  

Entering data using an AutoCorrect value 3m 1s  

Creating a data entry form 3m 25s  

Finding a specific color using RGB values 2m 33s  

Basing conditional formats on a formula 4m 12s  

6. Managing a Data Series 13m 3s

Extending a date series 3m 47s  

Using a custom list with the fill handle 3m 37s  

Using Flash Fill to manage data 2m 5s  

Removing duplicate values 3m 34s  

7. Working with Dates and Times 13m 8s

Inserting the current date or time 2m 44s  

Displaying times that exceed twenty-four hours 2m 49s  

Calculating days between dates 2m 23s  

Calculating time to reach an investment goal 2m 38s  

Displaying thousandths of a second 2m 34s  

8. Creating Useful Formulas 21m 39s

Generating a list of unique random numbers 3m 48s  

Using INDEX and MATCH to look up data without using the left-most column 5m 47s  

Summarizing data on the status bar 2m 29s  

Rounding values 6m 30s  

Calculating remainders and whole units 3m 5s  

9. Managing Formulas 17m 37s

Calculating running totals 1m 55s  

Creating and selecting named ranges quickly 3m 27s  

Commenting within a formula 2m 28s  

Displaying a cell formula using FORMULATEXT 1m 54s  

Exiting a cell without saving changes 1m 28s  

Analyzing a formula for errors 3m 9s  

Watching a cell's value 3m 16s  

10. Summarizing Data Using Charts and PivotTables 18m 17s

Creating a chart by pressing one key (or two) 1m 34s  

Creating recommended charts 1m 37s  

Summarizing data using a sparkline 3m 44s  

Using a PivotTable value in a formula 3m 44s  

Delaying PivotTable updates 2m 28s  

Creating separate sheets from a PivotTable 3m 5s  

Drilling down into PivotTable data 2m 5s  

Conclusion 56s

Additional resources 56s  





Note to eBay:

This item DOES NOT infringe any trademark, copyright, or any other rights, nor does it infringe eBay's listing or spam policies. Everything contained on the advertised DVD is distributed freely & globally under the terms of the GNU Public License, or the GNU Lesser General Public License (L.G.P.L). I have a full & legal right to re-distribute this product.

This IS NOT a digital download; the item will be posted to the buyer on a ‘solid-state’ DVD.










Business seller information

SheffieldJoanna's Gems
25 Westfield Southway
South Yorkshire
S20 8EB
United Kingdom

Return policy

Item must be returned within
14 days after the buyer receives it
The buyer is responsible for return postage costs.
Return policy details
Please contact me using eBay messages if you require to return an item. Please DO NOT use the resolution centre!

Refunds by law: In Australia, consumers have a legal right to obtain a refund from a business for goods purchased if the goods are faulty, not fit for purpose or don't match description. More information at returns - opens in a new window or tab.

Questions and answers about this item

No questions or answers have been posted about this item.


Place bid

Time left:
Current bid:
(Approximately ##1##)
Import charges:
Your max bid:
Your max bid:
By clicking Confirm bid, you commit to buy this item from the seller if you are the winning bidder.
By clicking Confirm bid, you are committing to buy this item from the seller if you are the winning bidder and have read and agreed to the Global Shipping Program terms and conditions - opens in a new window or tab. Import charges previously quoted are subject to change if you increase you maximum bid amount.
Resume bidding, if the page does not update immediately.
Place bid
Review and confirm your bid
Bid confirmation
FREE postage
See item description
(Approximately ##1##)
(Enter ##1## or more)
(Enter more than ##1##)
Your max bid:
Increase max bid
Place bid
Confirm bid
Increase max bid
Change bid
, you've been outbid. Don't let it get away - bid again!
, you're the highest bidder on this item. Good luck
, you're the first bidder. Hope you win!
, you're currently the high bidder, but you're close to getting outbid.
, this auction is almost over and you're currently the high bidder.
, you're the high bidder, but the reserve price hasn't been met.
Please enter your bid again.
Please enter a valid number as the bid price.
Enter an amount that is equal or greater than the minimum bid required. This can be found under the bid entry box.
Maximum bids can't be lowered once they're submitted.
This seller requires the buyer to have a PayPal account to purchase this item. Get a PayPal account here .
Your bid is greater than or equal to the Buy It Now price. We recommend you purchase this item via Buy It Now. If you still wish to bid, you may do so below.
Time left:
Current bid:
(approximately ##1##)
Your maximum bid:
(approximately ##1##)
Increase your maximum bid:
By clicking 1 Click Bid, you commit to buy this item from the seller if you're the winning bidder. Learn moreabout 1-click bid - opens in a new window or tab
(approximately ##1##)
Winning bid:
Starting bid:
Congratulations! The auction has ended and you're the winner.
The auction has ended, but the reserve price was not met.
Sorry, the auction has ended and you were outbid.
Good news, you're the high bidder.
Sorry, you've been outbid.
You're the high bidder, but the reserve price is not met.
Please enter a higher amount than the current bid.
Maximum bids can't be lowered once submitted.
Please enter a valid number.

Additional site navigation