Book description
- Work with basic Excel functions
- Use the LOOKUP function
- Take advantage of new functions in information functions
- Create a mega formula
Table of contents
- Cover
- Front Matter
- 1. What Is an Excel Function?
- 2. Text Functions
- 3. Date Functions
- 4. Time Functions
- 5. Named Ranges and Excel Tables
- 6. Lookup & Reference Functions
- 7. Aggregate Functions
- 8. Logical Functions
- 9. Math Functions
- 10. Information Functions
- 11. Finance Functions
- 12. Error Handling
- 13. Megaformulas
- 14. Array Formulas
- Back Matter
Product information
- Title: Microsoft Excel Functions Quick Reference: For High-Quality Data Analysis, Dashboards, and More
- Author(s):
- Release date: January 2021
- Publisher(s): Apress
- ISBN: 9781484266137
You might also like
book
Microsoft Excel 2019 Pivot Table Data Crunching
Renowned Excel experts Bill Jelen (MrExcel) and Michael Alexander help you crunch data from any source …
book
Excel Dashboards & Reports For Dummies, 4th Edition
It’s time for some truly “Excel-lent” spreadsheet reporting Beneath the seemingly endless rows and columns of …
book
Excel Formulas & Functions For Dummies, 5th Edition
Put the power of Excel functions to work in your formulas There are more than 400 …
book
Mastering Excel Through Projects: A Learn-by-Doing Approach from Payroll to Crypto to Data Analysis
Master Excel in less than two weeks with this unique project-based book! Let’s face it, we …