Try free for 30 days

  • Excel: Strategic Use of the Calc Spreadsheet in Business Environment, Data Analysis and Business Modeling

  • By: Francesco Iannello
  • Narrated by: C.J. McAllister
  • Length: 1 hr and 15 mins
  • 1.0 out of 5 stars (1 rating)

1 credit a month to use on any title, yours to keep (you’ll use your first credit on this title).
Stream or download thousands of included titles.
Access to exclusive deals and discounts.
$16.45 a month after 30 day trial. Cancel anytime.
Excel: Strategic Use of the Calc Spreadsheet in Business Environment, Data Analysis and Business Modeling cover art

Excel: Strategic Use of the Calc Spreadsheet in Business Environment, Data Analysis and Business Modeling

By: Francesco Iannello
Narrated by: C.J. McAllister
Try for $0.00

$16.45 per month after 30 days. Cancel anytime.

Buy Now for $9.68

Buy Now for $9.68

Pay using voucher balance (if applicable) then card ending in
By confirming your purchase, you agree to Audible's Conditions Of Use and Privacy Notice and authorise Audible to charge your designated credit card or another available credit card on file.

Publisher's Summary

  • Chapter 1: Data Validation Functioning
  • Chapter 2: Conditional Formulas
  • Chapter 3: Matrixal Functions
  • Chapter 4: Vertical Lookup/Horizontal Lookup
  • Chapter 5: Management of the Name Box
  • Chapter 6: Filters
  • Chapter 7: Pivot Tables
  • Chapter 8: Make the Most of Macros
  • Chapter 9: Modeling Management
  • Chapter 10: Power View

Spreadsheets and the programs that create them are as common in the business world as cubicles, and yet many people still don't know how to take full advantage of the software they use to create these ever-present files; despite the fact that it could ultimately save them time, headaches, even money in the long run. If you want to ensure you are getting the most out of your spreadsheet software, then Excel: Strategic Use of the Calc Spreadsheet in Business Environments, Data Analysis and Business Modeling is the book you have been waiting for.

This book is written for those who are already familiar with all of the basics that these programs have to offer and are looking to take their game to another level. It describes everything you need to know when it comes to time-saving things like making the most of Vertical or Horizontal Lookup features, productivity macros and the spreadsheet program's extensive filter function.

What's more, there is plenty of information on how to create data models using pivot tables, edit those data models using Power Pivot, and display them in the easiest to understand and use format possible with Power View. If you have ever wondered about a better way to complete common spreadsheet tasks, you can bet the answer to your problems can be found inside. Save yourself countless hours of frustration coupled with limited results.

Inside, you will find:

  • How to use phrases like if, and, or to create more malleable formulas, perfect for any occasion
  • The time-saving reasons you will want to start using named ranges and will never want to go back
  • The easiest way to create macros without any programing required
  • How to get Pivot Table slicers to work with any type of table

©2016 Francesco Iannello (P)2016 Francesco Iannello

What listeners say about Excel: Strategic Use of the Calc Spreadsheet in Business Environment, Data Analysis and Business Modeling

Average Customer Ratings
Overall
  • 1 out of 5 stars
  • 5 Stars
    0
  • 4 Stars
    0
  • 3 Stars
    0
  • 2 Stars
    0
  • 1 Stars
    1
Performance
  • 0 out of 5 stars
  • 5 Stars
    0
  • 4 Stars
    0
  • 3 Stars
    0
  • 2 Stars
    0
  • 1 Stars
    0
Story
  • 0 out of 5 stars
  • 5 Stars
    0
  • 4 Stars
    0
  • 3 Stars
    0
  • 2 Stars
    0
  • 1 Stars
    0

Reviews - Please select the tabs below to change the source of reviews.

In the spirit of reconciliation, Audible acknowledges the Traditional Custodians of country throughout Australia and their connections to land, sea and community. We pay our respect to their elders past and present and extend that respect to all Aboriginal and Torres Strait Islander peoples today.