Cover art for Microsoft Excel 2019 Formulas and Functions
Published
Microsoft Press, February 2019
ISBN
9781509306190
Format
Softcover, 512 pages
Dimensions
23cm × 19cm × 2cm

Microsoft Excel 2019 Formulas and Functions

Not in stock
Fast $7.95 flat-rate shipping!
Only pay $7.95 per order within Australia, including end-to-end parcel tracking.
100% encrypted and secure
We adhere to industry best practice and never store credit card details.
Talk to real people
Contact us seven days a week – our staff are here to help.

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

Related books