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

by John Walkenbach (Author) Format: Kindle Edition

30 ratings

Flip to back Flip to front

Audible Sample Playing... Paused You are listening to a sample of the Audible narration for this Kindle book.
Learn more

ISBN-13: 978-1118642184

ISBN-10: 111864218X

Why is ISBN important?

Share <Embed>

Other Sellers

from

Other Sellers

See all 2 versions

Buy

$21.00

eBook features:

Highlight, take notes, and search in the book
In this edition, page numbers are just like the physical edition
Length: 363 pages
Enhanced Typesetting: Enabled
Page Flip: Enabled
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

Sold by: JOHN WILEY AND SONS INC

Price set by seller.

Enter a promotion code or Gift Card

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!

Michael Alexander
199
Kindle Edition
1 offer from $24.00
John Walkenbach
407
Kindle Edition
1 offer from $30.00
Barbara Oakley
3,790
Kindle Edition
1 offer from $13.99
John Walkenbach
107
Kindle Edition
1 offer from $30.00
Michael Alexander
211
Kindle Edition
1 offer from $33.00
Michael Alexander
1,117
Kindle Edition
1 offer from $33.00

Editorial Reviews

From the Inside Flap

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.

From the Back Cover

Unlock new levels of Excel functionality

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.

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,121,233 in Kindle Store (See Top 100 in Kindle Store)
- #633 in Spreadsheets (Kindle Store)
- #1,115 in Microsoft Excel Guides
- #1,357 in Microsoft Office Guides

Customer Reviews:
30 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		44%
4 star		33%
3 star		18%
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!

Helpful

Amazon Customer

Worth it.

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