25 Books to Read Before You Die
 
 

Recently Viewed clear list


Original Essays | Today, 11:30am

Julie Schumacher: IMG Dear Professor Fitger



Saint Paul, August 2014 Dear Professor Fitger, I've been asked to say a few words about you for Powells.com. Having dreamed you up with a ball-point... Continue »
  1. $16.07 Sale Hardcover add to wish list

    Dear Committee Members

    Julie Schumacher 9780385538138

spacer
Qualifying orders ship free.
$39.99
New Trade Paper
Ships in 1 to 3 days
Add to Wishlist
Qty Store Section
21 Local Warehouse Personal Computers- Desktop Applications- Spreadsheets
8 Remote Warehouse Personal Computers- Desktop Applications- Spreadsheets

This title in other editions

101 Ready-To-Use Excel Formulas

by

101 Ready-To-Use Excel Formulas Cover

 

Synopses & Reviews

Publisher Comments:

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.

Synopsis:

Save time, automate, and be more productive with Excel Formulas

Excel formulas can make your work easier and more productive, but it takes time to grasp the ins and outs of formulas. Do you need immediate help and don’t have time to research the right formula for the job at hand? 101 Ready-to-Use Excel Formulas arms you with the 101 most commonly used Excel formulas that will solve your problems now!

Learn to create and customize Excel Formulas through step-by-step instructions, tips, tricks, and detailed explanations. The book includes the downloadable working formulas so you can immediately implement and reuse them in multiple workbooks.

This book is sure to be your go-to reference as you quickly become an Excel Formulas expert!

Let Mr. Spreadsheet show you how to:

  • Analyze operational data with business and financial formulas
  • Leverage Excel’s powerful statistical functions
  • Complete data cleanup and transformation tasks faster
  • Work with dates and time-based data
  • Enhance conditional formatting with your own customized formulas

Synopsis:

Learn from the experts who are in the trenches! This book approaches the reader with the assumption that learning comes with accomplishing core tasks, or by doing. Instead of the same general overview of Excel Formula writing, this book provides 101 of the most commonly used real-world Excel formulas that can be repurposed and used for increased productivity. Each segment of the book outlines a common business or analysis problem that needs solved, and it then provides the actual Excel Formulas to solve the problem – along with detailed explanation of how the Formulas works.

The style of this book is in the format that offers a Recipe/Tips & Tricks approach, where each segment shows how to perform a common task via Excel Formulas. This allows the reader to use the book as a handy reference where a common problem can be found in the book, and it can then be solved by plugging in the given formula. The recipes in the book are independent from the rest of the book, focusing on a particular scenario, so they follow this learning construct:

  • The problem is presented
  • The formula solution is provided
  • How it works so it can be customized is explained

After reading each segment of this book the reader will be able to:

  • Implement the required Excel Formula
  • Understand how the given Formula works
  • Reuse and/or customize the given Formula in other workbooks or in conjunction with other Formulas
  • Find immediate satisfaction and success!

About the Author

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.

Product Details

ISBN:
9781118902684
Author:
Alexander, Michael
Publisher:
Wiley
Author:
Kusleika, Dick
Subject:
Spreadsheets - General
Subject:
Microsoft Excel
Subject:
101 Ready-to-Use Excel Forumlas; Michael Alexander; Dick Kusleika; understanding Excel formulas; guide to Excel formulas; targeted formulas for Excel; Excel formulas; functions of Excel; Excel formulas explained; explanation of Excel formulas; tricks to E
Subject:
101 Ready-to-Use Excel Forumlas; Michael Alexander; Dick Kusleika; understanding Excel formulas; guide to Excel formulas; targeted formulas for Excel; Excel formulas; functions of Excel; Excel formulas explained; explanation of Excel formulas; tricks to E
Subject:
101 Ready-to-Use Excel Forumlas; Michael Alexander; Dick Kusleika; understanding Excel formulas; guide to Excel formulas; targeted formulas for Excel; Excel formulas; functions of Excel; Excel formulas explained; explanation of Excel formulas; tricks to E
Subject:
101 Ready-to-Use Excel Forumlas; Michael Alexander; Dick Kusleika; understanding Excel formulas; guide to Excel formulas; targeted formulas for Excel; Excel formulas; functions of Excel; Excel formulas explained; explanation of Excel formulas; tricks to E
Subject:
101 Ready-to-Use Excel Forumlas; Michael Alexander; Dick Kusleika; understanding Excel formulas; guide to Excel formulas; targeted formulas for Excel; Excel formulas; functions of Excel; Excel formulas explained; explanation of Excel formulas; tricks to E
Subject:
Personal Computers-Desktop Applications-Spreadsheets
Subject:
101 Ready-to-Use Excel Forumlas; Michael Alexander; Dick Kusleika; understanding Excel formulas; guide to Excel formulas; targeted formulas for Excel; Excel formulas; functions of Excel; Excel formulas explained; explanation of Excel formulas; tricks to E
Subject:
101 Ready-to-Use Excel Forumlas; Michael Alexander; Dick Kusleika; understanding Excel formulas; guide to Excel formulas; targeted formulas for Excel; Excel formulas; functions of Excel; Excel formulas explained; explanation of Excel formulas; tricks to E
Subject:
101 Ready-to-Use Excel Forumlas; Michael Alexander; Dick Kusleika; understanding Excel formulas; guide to Excel formulas; targeted formulas for Excel; Excel formulas; functions of Excel; Excel formulas explained; explanation of Excel formulas; tricks to E
Subject:
101 Ready-to-Use Excel Forumlas; Michael Alexander; Dick Kusleika; understanding Excel formulas; guide to Excel formulas; targeted formulas for Excel; Excel formulas; functions of Excel; Excel formulas explained; explanation of Excel formulas; tricks to E
Subject:
101 Ready-to-Use Excel Forumlas; Michael Alexander; Dick Kusleika; understanding Excel formulas; guide to Excel formulas; targeted formulas for Excel; Excel formulas; functions of Excel; Excel formulas explained; explanation of Excel formulas; tricks to E
Subject:
101 Ready-to-Use Excel Forumlas; Michael Alexander; Dick Kusleika; understanding Excel formulas; guide to Excel formulas; targeted formulas for Excel; Excel formulas; functions of Excel; Excel formulas explained; explanation of Excel formulas; tricks to E
Subject:
101 Ready-to-Use Excel Forumlas; Michael Alexander; Dick Kusleika; understanding Excel formulas; guide to Excel formulas; targeted formulas for Excel; Excel formulas; functions of Excel; Excel formulas explained; explanation of Excel formulas; tricks to E
Subject:
101 Ready-to-Use Excel Forumlas; Michael Alexander; Dick Kusleika; understanding Excel formulas; guide to Excel formulas; targeted formulas for Excel; Excel formulas; functions of Excel; Excel formulas explained; explanation of Excel formulas; tricks to E
Subject:
101 Ready-to-Use Excel Forumlas; Michael Alexander; Dick Kusleika; understanding Excel formulas; guide to Excel formulas; targeted formulas for Excel; Excel formulas; functions of Excel; Excel formulas explained; explanation of Excel formulas; tricks to E
Subject:
101 Ready-to-Use Excel Forumlas; Michael Alexander; Dick Kusleika; understanding Excel formulas; guide to Excel formulas; targeted formulas for Excel; Excel formulas; functions of Excel; Excel formulas explained; explanation of Excel formulas; tricks to E
Subject:
101 Ready-to-Use Excel Forumlas; Michael Alexander; Dick Kusleika; understanding Excel formulas; guide to Excel formulas; targeted formulas for Excel; Excel formulas; functions of Excel; Excel formulas explained; explanation of Excel formulas; tricks to E
Subject:
101 Ready-to-Use Excel Forumlas; Michael Alexander; Dick Kusleika; understanding Excel formulas; guide to Excel formulas; targeted formulas for Excel; Excel formulas; functions of Excel; Excel formulas explained; explanation of Excel formulas; tricks to E
Subject:
101 Ready-to-Use Excel Forumlas; Michael Alexander; Dick Kusleika; understanding Excel formulas; guide to Excel formulas; targeted formulas for Excel; Excel formulas; functions of Excel; Excel formulas explained; explanation of Excel formulas; tricks to E
Subject:
101 Ready-to-Use Excel Forumlas; Michael Alexander; Dick Kusleika; understanding Excel formulas; guide to Excel formulas; targeted formulas for Excel; Excel formulas; functions of Excel; Excel formulas explained; explanation of Excel formulas; tricks to E
Subject:
101 Ready-to-Use Excel Forumlas; Michael Alexander; Dick Kusleika; understanding Excel formulas; guide to Excel formulas; targeted formulas for Excel; Excel formulas; functions of Excel; Excel formulas explained; explanation of Excel formulas; tricks to E
Subject:
101 Ready-to-Use Excel Forumlas; Michael Alexander; Dick Kusleika; understanding Excel formulas; guide to Excel formulas; targeted formulas for Excel; Excel formulas; functions of Excel; Excel formulas explained; explanation of Excel formulas; tricks to E
Subject:
101 Ready-to-Use Excel Forumlas; Michael Alexander; Dick Kusleika; understanding Excel formulas; guide to Excel formulas; targeted formulas for Excel; Excel formulas; functions of Excel; Excel formulas explained; explanation of Excel formulas; tricks to E
Subject:
101 Ready-to-Use Excel Forumlas; Michael Alexander; Dick Kusleika; understanding Excel formulas; guide to Excel formulas; targeted formulas for Excel; Excel formulas; functions of Excel; Excel formulas explained; explanation of Excel formulas; tricks to E
Subject:
101 Ready-to-Use Excel Forumlas; Michael Alexander; Dick Kusleika; understanding Excel formulas; guide to Excel formulas; targeted formulas for Excel; Excel formulas; functions of Excel; Excel formulas explained; explanation of Excel formulas; tricks to E
Subject:
101 Ready-to-Use Excel Forumlas; Michael Alexander; Dick Kusleika; understanding Excel formulas; guide to Excel formulas; targeted formulas for Excel; Excel formulas; functions of Excel; Excel formulas explained; explanation of Excel formulas; tricks to E
Subject:
101 Ready-to-Use Excel Forumlas; Michael Alexander; Dick Kusleika; understanding Excel formulas; guide to Excel formulas; targeted formulas for Excel; Excel formulas; functions of Excel; Excel formulas explained; explanation of Excel formulas; tricks to E
Subject:
101 Ready-to-Use Excel Forumlas; Michael Alexander; Dick Kusleika; understanding Excel formulas; guide to Excel formulas; targeted formulas for Excel; Excel formulas; functions of Excel; Excel formulas explained; explanation of Excel formulas; tricks to E
Subject:
101 Ready-to-Use Excel Forumlas; Michael Alexander; Dick Kusleika; understanding Excel formulas; guide to Excel formulas; targeted formulas for Excel; Excel formulas; functions of Excel; Excel formulas explained; explanation of Excel formulas; tricks to E
Subject:
101 Ready-to-Use Excel Forumlas; Michael Alexander; Dick Kusleika; understanding Excel formulas; guide to Excel formulas; targeted formulas for Excel; Excel formulas; functions of Excel; Excel formulas explained; explanation of Excel formulas; tricks to E
Subject:
101 Ready-to-Use Excel Forumlas; Michael Alexander; Dick Kusleika; understanding Excel formulas; guide to Excel formulas; targeted formulas for Excel; Excel formulas; functions of Excel; Excel formulas explained; explanation of Excel formulas; tricks to E
Copyright:
Publication Date:
20140616
Binding:
Electronic book text in proprietary or open standard format
Language:
English
Pages:
320

Related Subjects

Computers and Internet » Personal Computers » Desktop Applications » Spreadsheets

101 Ready-To-Use Excel Formulas New Trade Paper
0 stars - 0 reviews
$39.99 In Stock
Product details 320 pages John Wiley & Sons - English 9781118902684 Reviews:
"Synopsis" by , Save time, automate, and be more productive with Excel Formulas

Excel formulas can make your work easier and more productive, but it takes time to grasp the ins and outs of formulas. Do you need immediate help and don’t have time to research the right formula for the job at hand? 101 Ready-to-Use Excel Formulas arms you with the 101 most commonly used Excel formulas that will solve your problems now!

Learn to create and customize Excel Formulas through step-by-step instructions, tips, tricks, and detailed explanations. The book includes the downloadable working formulas so you can immediately implement and reuse them in multiple workbooks.

This book is sure to be your go-to reference as you quickly become an Excel Formulas expert!

Let Mr. Spreadsheet show you how to:

  • Analyze operational data with business and financial formulas
  • Leverage Excel’s powerful statistical functions
  • Complete data cleanup and transformation tasks faster
  • Work with dates and time-based data
  • Enhance conditional formatting with your own customized formulas

"Synopsis" by , Learn from the experts who are in the trenches! This book approaches the reader with the assumption that learning comes with accomplishing core tasks, or by doing. Instead of the same general overview of Excel Formula writing, this book provides 101 of the most commonly used real-world Excel formulas that can be repurposed and used for increased productivity. Each segment of the book outlines a common business or analysis problem that needs solved, and it then provides the actual Excel Formulas to solve the problem – along with detailed explanation of how the Formulas works.

The style of this book is in the format that offers a Recipe/Tips & Tricks approach, where each segment shows how to perform a common task via Excel Formulas. This allows the reader to use the book as a handy reference where a common problem can be found in the book, and it can then be solved by plugging in the given formula. The recipes in the book are independent from the rest of the book, focusing on a particular scenario, so they follow this learning construct:

  • The problem is presented
  • The formula solution is provided
  • How it works so it can be customized is explained

After reading each segment of this book the reader will be able to:

  • Implement the required Excel Formula
  • Understand how the given Formula works
  • Reuse and/or customize the given Formula in other workbooks or in conjunction with other Formulas
  • Find immediate satisfaction and success!

spacer
spacer
  • back to top
Follow us on...




Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.