Get Free Shipping on orders over $79
Microsoft Excel 2019 Formulas and Functions : Business Skills - Paul McFedries

Microsoft Excel 2019 Formulas and Functions

By: Paul McFedries

Paperback | 25 April 2019 | Edition Number 1

At a Glance
New Edition

Paperback


RRP $60.95

$54.75

10%OFF

or 4 interest-free payments of $13.69 with

 or 

Ships in 5 to 7 business days

Master core Excel tools for building powerful, reliable spreadsheets with Excel 2019 Formulas and Functions. Excel expert Paul McFedries shows how to use Excel core features to solve problems and get the answers you need. Using real-world examples, McFedries helps you get the absolute most out of features and improvements ranging from AutoFill to Excel’s newest functions. Along the way, you discover the fastest, best ways to handle essential day-to-day tasks ranging from generating account numbers to projecting the impact of inflation.

Becoming an Excel expert has never been easier! You’ll find crystal-clear instructions; insider insights; even complete step-by-step projects for building timesheets, projecting cash flow, aging receivables, analysing defects, and more.

  • Quickly create powerful spreadsheets with range names and array formulas
  • Use conditional formatting to instantly reveal anomalies, problems, or opportunities
  • Analyse your data with standard tables and PivotTables
  • Use complex criteria to filter data in lists
  • Understand correlations between data
  • Perform sophisticated what-if analyses
  • Use regression to track trends and make forecasts
  • Build loan, investment, and discount formulas
  • Validate data, troubleshoot problems, and build more accurate, trustworthy spreadsheets

More in Business Applications

Microsoft 365 in easy steps : In Easy Steps - Nick Vandome

RRP $39.99

$33.75

16%
OFF
Statistics and Data Handling for Biologists : A Student's Guide - Neil Millar
SPSS Statistics : 5th Edition - A Practical Guide - Kellie Bennett

RRP $104.95

$89.75

14%
OFF
Microsoft 365 Excel All-in-One For Dummies : Excel for Dummies - David H. Ringstrom
MYOB For Dummies : 9th Edition - Sonya Prosper

RRP $45.00

$35.75

21%
OFF
Discovering Statistics Using JASP - Andy Field
Microsoft Teams For Dummies : For Dummies (Computer/Tech) - Rosemarie Withee
Building Microservices : Designing Fine-Grained Systems 2nd Edition - Sam Newman
Statistics Using Stata : 3rd Edition - An Integrative Approach - Sharon Lawner Weinberg
Microsoft 365 Access For Dummies, 2nd Edition : Access for Dummies - Ken Cook
SharePoint For Dummies : Sharepoint for Dummies - Rosemarie Withee

RRP $49.95

$38.75

22%
OFF
Ethics in Information Technology : 6th edition - George Reynolds

RRP $157.95

$129.75

18%
OFF
Microsoft Power BI Dashboards Step by Step : Step by Step - Errin O'Connor