Cantitate/Preț
Produs
Total produse
Vezi coșul
Microsoft Excel Functions Quick Reference: For High-Quality Data Analysis, Dashboards, and More de Mandeep Mehta

Microsoft Excel Functions Quick Reference: For High-Quality Data Analysis, Dashboards, and More

Autor Mandeep Mehta
en Limba Engleză Paperback – 8 ian 2021
This condensed syntax reference presents the essential Excel function syntax in a well-organized format that can be used as a quick and handy reference. You can use it to improve your Excel knowledge and increase your productivity. It will help you upgrade the quality of your data analysis, dashboards, models, and templates.

The Microsoft Excel Functions Quick Reference helps you set up workbooks, enter data, and format it for easier viewing. It starts by giving an overview of Excel functions explaining the different types of Excel functions available followed by an understanding of string functions and date functions. It then covers time, lookup, aggregate, and logical functions along with practice problems. Further, you will see math functions and information functions in Excel. You will also be able to create sophisticated forecast worksheets, key performance indicators (KPIs), and timelines. Each function in the text is illustrated by helpful, illuminating examples.

With this book by your side, you'll always have the answer to your Excel function syntax questions. 

What You Will Learn
  • Work with basic Excel functions
  • Use the LOOKUP function
  • Take advantage of new functions in information functions
  • Create a mega formula
Who This Book Is For

Administrators, analysts, and anyone else working with Microsoft Excel.




Citește tot Restrânge

Preț: 21023 lei

Preț vechi: 26278 lei
-20% Nou

Puncte Express: 315
Preț estimativ în valută:
4023€ • 4179$ • 3342£

Carte disponibilă

Livrare economică 13-27 ianuarie 25
Livrare express 27 decembrie 24 - 02 ianuarie 25 pentru 9108 lei

 Adaugă în coș

Wish list
Gift list
Am citit!
Adaugă în listă
Preluare comenzi: 021 569.72.76

Specificații

ISBN-13: 9781484266120
ISBN-10: 1484266129
Pagini: 190
Ilustrații: XXIX, 255 p. 127 illus.
Dimensiuni: 155 x 235 x 23 mm
Greutate: 0.41 kg
Ediția:1st ed.
Editura: Apress
Colecția Apress
Locul publicării:Berkeley, CA, United States

Cuprins

Chapter 1: What is an Excel function?.- Chapter 2: TEXT functions.- Chapter 3: DATE functions.- Chapter 4: TIME functions.- Chapter 5: Named Ranges and Excel Tables.- Chapter 6: LOOKUP   functions.- Chapter 7: AGGREGATE functions.- Chapter 8: LOGICAL functions.- Chapter 9: Maths functions.- Chapter 10: INFORMATION functions.- Chapter 11: Finance functions.- Chapter 12: Error Handling.- Chapter 13: Megaformulas.- Chapter 14: Array formula. Appendix A: Formula ready reckoner.

Notă biografică

Mandeep has more than 20 years of experience in administration, operations, software development, and reporting. He mostly works with cross-functional teams in ensuring operational and service excellence. Mandeep has worked with Capgemini for more than ten years and is currently working as a freelancer in conducting various training in MS Office and providing data services. 

Textul de pe ultima copertă

This condensed syntax reference presents the essential Excel function syntax in a well-organized format that can be used as a quick and handy reference. You can use it to improve your Excel knowledge and increase your productivity. It will help you upgrade the quality of your data analysis, dashboards, models, and templates.

The Microsoft Excel Functions Quick Reference helps you set up workbooks, enter data, and format it for easier viewing. It starts by giving an overview of Excel functions explaining the different types of Excel functions available followed by an understanding of string functions and date functions. It then covers time, lookup, aggregate, and logical functions along with practice problems. Further, you will see math functions and information functions in Excel. You will also be able to create sophisticated forecast worksheets, key performance indicators (KPIs), and timelines. Each function in the text isillustrated by helpful, illuminating examples.

With this book by your side, you'll always have the answer to your Excel function syntax questions. 

You will:
  • Work with basic Excel functions
  • Use the LOOKUP function
  • Take advantage of new functions in information functions
  • Create a mega formula

Caracteristici

Consists of examples for each function discussed Discusses complex calculations and their solutions by using a mega formula Covers simplification of multiple calculations at once