Buying Options

Kindle Price:	$21.00
Sold by:	JOHN WILEY AND SONS INC Price set by seller.

Promotions apply when you purchase

eBook features:

Highlight, take notes, and search in the book
In this edition, page numbers are just like the physical edition

Deliver to your Kindle or other device

You've subscribed to ! We will preorder your items within 24 hours of when they become available. When new books are released, we'll charge your default payment method for the lowest price available during the pre-order period.

Update your device or payment method, cancel individual pre-orders or your subscription at
Your Memberships & Subscriptions

There was an error. We were unable to process your subscription due to an error. Please refresh and try again.

Enter a promotion code or Gift Card

Share <Embed>

101 Excel 2013 Tips, Tricks and Timesavers by [John Walkenbach]

Follow the Author

John Walkenbach

101 Excel 2013 Tips, Tricks and Timesavers 1st Edition, Kindle Edition

by John Walkenbach (Author) Format: Kindle Edition

31 ratings

See all formats and editions

Price

New from

Used from

Kindle

"Please retry"

$21.00

—

Paperback

"Please retry"

$26.33

$20.52

$6.29

Get the most out of Excel 2013 with this exceptional advice from Mr. Spreadsheet himself!

Excel 2013 is excellent, but there's lots to learn to truly excel at Excel! In this latest addition to his popular Mr. Spreadsheet's Bookshelf series, John Walkenbach, aka "Mr. Spreadsheet," shares new and exciting ways to accomplish and master all of your spreadsheet tasks. From taming the Ribbon bar to testing and tables, creating custom functions, and overcoming "impossible" charts, mixing nesting limits, and more, 101 Excel 2013 Tips, Tricks, & Timesavers will save you time and help you avoid common spreadsheet stumbling blocks.

Reveals ways to maximize the power of Excel to create robust applications
Draws on John Walkenbach's years of experience using Excel and writing more than 50 books
Shares tips and tricks for dealing with function arguments, creating add-ins, using UserForms, working with dynamic chart data, and changing data entry orientation
Provides shortcuts and helpful techniques for sorting more than three columns, entering fake data for testing purposes, and setting up powerful pivot tables

101 Excel 2013 Tips, Tricks, & Timesavers is packed with information that you need to know in order to confidently and seamlessly master the challenges that come with using Excel!

ISBN-13

978-1118642184
Edition

1st
Publisher

Wiley
Publication date

June 10, 2013
Language

English
File size

19968 KB
See all details

Due to its large file size, this book may take longer to download

Read with the free Kindle apps (available on iOS, Android, PC & Mac), Kindle E-readers and on Fire Tablet devices. See all supported devices

John Walkenbach
108
Kindle Edition
1 offer from $30.00
John Michaloudis
862
Kindle Edition
1 offer from $9.99
Michael Alexander
203
Kindle Edition
1 offer from $24.00
John Walkenbach
316
Kindle Edition
1 offer from $30.00
Michael Alexander
49
Kindle Edition
1 offer from $30.00
Greg Harvey
417
Kindle Edition
1 offer from $21.00

Editorial Reviews

About the Author

John Walkenbach, arguably the foremost authority on Excel, has written 50+ books, including the bestselling Excel Bible, Excel Formulas, and Excel Power Programming with VBA, as well as more than 300 articles for publications such as PC World, InfoWorld, and Windows. He created the award-winning Power Utility Pak, and provides Excel information and insight at www.spreadsheetpage.com.

--This text refers to the paperback edition.

From the Back Cover

Unlock new levels of Excel functionality

Nobody knows Excel like John Walkenbach. This hand-picked collection of tips and tricks helps you squeeze more functionality from this complex program and take your Excel skills to the next level. Learn to use a workbook in your browser, fine-tune formatting, send personalized e-mail from Excel, hide and lock your formulas, use pivot table slicers and timelines, and so much more.

If you're already using Excel on a regular basis but know it has capabilities you haven't tapped, open this book and let Mr. Spreadsheet open the door to a new range of Excel 2013 possibilities.

Let Mr. Spreadsheet show you how to:

Generate a list of filenames or sheet names
Avoid font substitution for small point sizes
Edit formulas in dialog boxes
Use Flash Fill to extract or combine data
Save shapes, charts, and ranges as images

--This text refers to the paperback edition.

Product details

ASIN ‏ : ‎ B00DF15W9K
Publisher ‏ : ‎ Wiley; 1st edition (June 10, 2013)
Publication date ‏ : ‎ June 10, 2013
Language ‏ : ‎ English
File size ‏ : ‎ 19968 KB
Text-to-Speech ‏ : ‎ Enabled
Screen Reader ‏ : ‎ Supported
Enhanced typesetting ‏ : ‎ Enabled
X-Ray ‏ : ‎ Not Enabled
Word Wise ‏ : ‎ Not Enabled
Print length ‏ : ‎ 363 pages
Page numbers source ISBN ‏ : ‎ 111864218X
Lending ‏ : ‎ Enabled

Best Sellers Rank: #2,202,074 in Kindle Store (See Top 100 in Kindle Store)
- #634 in Spreadsheets (Kindle Store)
- #1,151 in Microsoft Excel Guides
- #1,397 in Microsoft Office Guides

Customer Reviews:
31 ratings

About the author

Follow authors to get new release updates, plus improved recommendations.

John Walkenbach

Brief content visible, double tap to read full content.

Full content visible, double tap to read brief content.

John Walkenbach, author of many Excel books, retired from Excel in 2019. He currently lives in Tucson, Arizona.

Customer reviews

5 star		47%
4 star		31%
3 star		17%
2 star		5%
1 star 0% (0%)		0%

How customer reviews and ratings work

Top reviews from the United States

There was a problem filtering reviews right now. Please try again later.

R. Taff

Contains material you would not find elsewhere

Reviewed in the United States on July 27, 2020

Verified Purchase

I've found this book extra-helpful and easy to understand.

Helpful

Mark Mcardle

As always Walkenbach is an excellent Excel teacher

Reviewed in the United States on August 8, 2015

Verified Purchase

As always Walkenbach is an excellent Excel teacher. I have just installed Excel 2013 on one of my laptops and I am finding his gems very useful!

Reviewed in the United States on November 4, 2019

Verified Purchase

Explain clearly.Get more knowledge.

Helpful

Guyr8s

Walkenbach is great for experienced Excel users

Reviewed in the United States on September 5, 2015

Verified Purchase

Whats not to like? Walkenbach is great for experienced Excel users. Not the best for beginners.

Helpful

Bill Phillips

Useful for all Excel users.

Reviewed in the United States on July 11, 2015

Verified Purchase

A lot of productivity in one book. Useful for all Excel users.

Helpful

Josie Emma Seppala

Great Tips, Tricks, and Timesavers

Reviewed in the United States on December 3, 2013

Verified Purchase

Easy to get quick tips, glossary and index!
I use it for work and home and have one of his other books for VBA coding, use them both.

One person found this helpful

Helpful

Kindle Customer

Five Stars

Reviewed in the United States on July 27, 2014

Verified Purchase

Easy to use and understand. Learned a few new things!

One person found this helpful

Helpful

Honolulu Bill

The author does a good job organizing the book as a reference tool for ...

Reviewed in the United States on January 2, 2015

Verified Purchase

The author does a good job organizing the book as a reference tool for Excel. Workbook downloads covering both the book content and 30 additional tips allow an easy path to understanding the underlying basics.

Helpful

Top reviews from other countries

SuffoxAzon

Useful tips for advanced Excel users

Reviewed in the United Kingdom on December 28, 2014

Verified Purchase

Useful tips for advanced Excel users, but is much the same as release under the same name for previous Excel versions

Mr. S. Allen

Expert advice as usual from John

Reviewed in the United Kingdom on January 27, 2014

Verified Purchase

What more can I say? John Walkenbach has such a vast knowledge of Excel and this book covers it all.
Once again thanks for the tips, tricks and more in this book.

Liz

Four Stars

Reviewed in the United Kingdom on September 1, 2014

Verified Purchase

Bought for work

See all reviews