Microsoft Excel 2019 Formulas and Functions, 1st edition

Microsoft Excel 2019 Formulas and Functions

ISBN-13:  9781509306343

Microsoft Excel 2019 Formulas and Functions

ISBN-13:  9781509306190

• Quickly create powerful spreadsheets with FlashFill
• Use conditional formatting to instantly reveal anomalies, problems, or opportunities
• Analyze 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