101 Ready-to-Use Excel Formulas

Michael Alexander (McKinney, TX), Richard Kusleika

$65.95

Paperback

Not in-store but you can order this
How long will it take?

Availability Information

We source books from suppliers in Australia and overseas. For books we don't currently have in stock, the time it takes to get them from our suppliers can vary widely - from a few days to a few months - so we check each book with each supplier to determine the expected time it will take to be supplied to us.

We then advise you accordingly. If the time taken to get any book is too long for you, you can let us know and we will cancel or adjust your order, and refund as required.

To find out the anticipated arrival time for specific items prior to ordering, please contact us by phone or email:

Phone +61 2 9264 3111, or 1800 4 BOOKS (1800 4 26657) if outside Sydney:
option 1 Abbey's Bookshop (Crime, History, Science, Kids & more) • info@abbeys.com.au
option 2 Language Book Centre (ESL & Foreign Languages) • language@abbeys.com.au
option 3 Galaxy Bookshop (Sci-fi, Fantasy, Romance, Graphic Novels) • sf@galaxybooks.com.au

QTY:

English

John Wiley & Sons Inc
04 August 2014

Excel

Mr. Spreadsheet has done it again with 101 easy-to-apply Excel formulas

101 Ready-to-Use Excel Formulas is filled with the most commonly-used, real-world Excel formulas that can be repurposed and put into action, saving you time and increasing your productivity. Each segment of this book outlines a common business or analysis problem that needs to be solved and provides the actual Excel formulas to solve the problem—along with detailed explanation of how the formulas work.

Written in a user-friendly style that relies on a tips and tricks approach, the book details how to perform everyday Excel tasks with confidence. 101 Ready-to-Use Excel Formulas is sure to become your well-thumbed reference to solve your workplace problems. The recipes in the book are structured to first present the problem, then provide the formula solution, and finally show how it works so that it can be customized to fit your needs. The companion website to the book allows readers to easily test the formulas and provides visual confirmation of the concepts presented.

Teaches you how to implement the required Excel formula Explains and details how the formulas work Lets you reuse or customize the given formula to address your particular needs Helps you make the formulas a regular part of your new, more efficient workflow

Specific real-world scenarios are used to demonstrate how to most effectively apply Excel and its powerful formulas to complete tasks faster and with greater accuracy than ever before. Now you can save time, automate, and be more efficient and productive with 101 Ready-to-Use Excel Formulas.

By: Michael Alexander (McKinney TX), Richard Kusleika
Imprint: John Wiley & Sons Inc
Country of Publication: United States
Dimensions: Height: 236mm, Width: 188mm, Spine: 13mm
Weight: 322g
ISBN: 9781118902684
ISBN 10: 1118902688
Pages: 240
Publication Date: 04 August 2014
Audience: Professional and scholarly , Undergraduate
Format: Paperback
Publisher's Status: Active

Introduction 1 Chapter 1: Introducing Excel Formulas 5 Chapter 2: Common Mathematical Operations 21 Chapter 3: Manipulating Text with Formulas 37 Chapter 4: Working with Dates and Times 53 Chapter 5: Performing Conditional Analysis 79 Chapter 6: Using Lookup Formulas 103 Chapter 7: Common Business and Financial Formulas 127 Chapter 8: Common Statistical Analyses 157 Chapter 9: Using Formulas with Conditional Formatting 183 Index 205

Michael Alexander is a Microsoft Excel MVP who has written several books on advanced business analysis with Microsoft Access and Excel. Visit him at DataPigTechnologies.com. Dick Kusleika is 12-year Microsoft Excel MVP and the principal contributor at the Daily Dose of Excel blog (www.dailydoseofexcel.com). John Walkenbach is arguably the foremost authority on Excel. He has written more than 30 books, hundreds of articles on Excel, and he created the award-winning Power Utility Pak.

PERHAPS A GIFT VOUCHER FOR MUM?: MOTHER'S DAY

101 Ready-to-Use Excel Formulas

Michael Alexander (McKinney, TX), Richard Kusleika

$65.95

Paperback

See Also

Contact Abbeys

Contact Galaxy

Contact Language

Contact Us

About ABBEY'S