BIBLIO is the largest independent book marketplace in the world, with over 100 million books.

Skip to content

Microsoft Excel Functions Quick Reference: For High-Quality Data Analysis,
Stock photo: cover may vary

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

by Mandeep Mehta

Add to wish list

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

From the publisher

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.


From the rear cover

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

Details

  • Title Microsoft Excel Functions Quick Reference: For High-Quality Data Analysis, Dashboards, and More
  • Author Mandeep Mehta
  • Binding Paperback
  • Pages 255
  • Volumes 1
  • Language ENG
  • Publisher Apress
  • ISBN 9781484266120 / 1484266129
  • Weight 0.9 lbs (0.41 kg)
  • Dimensions 9.21 x 6.14 x 0.6 in (23.39 x 15.60 x 1.52 cm)
  • Category Computers - Languages / Programming

About the author

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.

More Copies for Sale

Microsoft Excel Functions Quick Reference: For High-Quality Data Analysis, Dashboards, and More
Stock photo: cover may vary

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

by Mehta, Mandeep

  • Used
  • Very good
  • Paperback
Condition
Very good
Binding
Paperback
ISBN 10 / ISBN 13
9781484266120 / 1484266129
Quantity available
1
Seller
Item price
A$38.90
Free Delivery to USA

Show details

Description:
Apress, 2021. Paperback. Very Good. Former library book; May have limited writing in cover pages. Pages are unmarked. ~ ThriftBooks: Read More, Spend Less.Dust jacket quality is not guaranteed.
Add to wish list
Item price
A$38.90
Free Delivery to USA
Microsoft Excel Functions Quick Reference: For High-Quality Data Analysis, Dashboards, and More
Stock photo: cover may vary

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

by Mehta, Mandeep

  • Used
Condition
New
ISBN 10 / ISBN 13
9781484266120 / 1484266129
Quantity available
1
Seller
Item price
A$43.75
A$5.74 Delivery to USA

Show details

Description:
like new.
Add to wish list
Item price
A$43.75
A$5.74 Delivery to USA
Microsoft Excel Functions Quick Reference: For High-quality Data Analysis, Dashboards, and More
Stock photo: cover may vary

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

by Mehta, Mandeep

  • New
  • Paperback
Condition
New
Binding
Paperback
ISBN 10 / ISBN 13
9781484266120 / 1484266129
Quantity available
1
Seller
Item price
A$72.85
A$48.23 Delivery to USA

Show details

Description:
Apress, 2021. Paperback. New. 255 pages. 9.25x6.00x0.50 inches.
Add to wish list
Item price
A$72.85
A$48.23 Delivery to USA
Microsoft Excel Functions Quick Reference: For High-Quality Data Analysis, Dashboards, and More
Stock photo: cover may vary

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

by Mehta, Mandeep

  • New
Condition
New
ISBN 10 / ISBN 13
9781484266120 / 1484266129
Quantity available
1
Seller
Item price
A$58.76
A$5.74 Delivery to USA

Show details

Description:
new.
Add to wish list
Item price
A$58.76
A$5.74 Delivery to USA
Microsoft Excel Functions Quick Reference: For High-Quality Data Analysis, Dashboards, and More
Stock photo: cover may vary

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

by Mehta, Mandeep

  • New
  • Paperback
  • first
Condition
New
Edition
1st ed
Binding
Paperback
ISBN 10 / ISBN 13
9781484266120 / 1484266129
Quantity available
1
Seller
Item price
A$64.52
Free Delivery to USA

Show details

Description:
Apress, 2021-01-08. 1st ed. paperback. New. 6.10x0.65x9.25. Buy with confidence. Excellent Customer Service & Return policy.
Add to wish list
Item price
A$64.52
Free Delivery to USA
Microsoft Excel Functions Quick Reference: For High-Quality Data Analysis, Dashboards, and More
Stock photo: cover may vary

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

by Mehta, Mandeep

  • Used
  • Paperback
  • first
Condition
Used
Edition
1st ed
Binding
Paperback
ISBN 10 / ISBN 13
9781484266120 / 1484266129
Quantity available
1
Seller
Item price
A$86.23
Free Delivery to USA

Show details

Description:
Apress, 2021-01-08. 1st ed. paperback. Used: Good. 6.10x0.65x9.25. Buy with confidence. Excellent Customer Service & Return policy.
Add to wish list
Item price
A$86.23
Free Delivery to USA
Microsoft Excel Functions Quick Reference: For High-Quality Data Analysis, Dashboards, and More
Stock photo: cover may vary

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

by Mehta, Mandeep

  • Used
  • Good
  • Paperback
Condition
Good
Binding
Paperback
ISBN 10 / ISBN 13
9781484266120 / 1484266129
Quantity available
1
Seller
Item price
A$96.07
Free Delivery to USA

Show details

Description:
paperback. Good. Access codes and supplements are not guaranteed with used items. May be an ex-library book.
Add to wish list
Item price
A$96.07
Free Delivery to USA
Microsoft Excel Functions Quick Reference: For High-Quality Data Analysis, Dashboards, and More
Stock photo: cover may vary

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

  • New
Condition
New
ISBN 10 / ISBN 13
9781484266120 / 1484266129
Quantity available
4
Seller
Item price
A$121.85
A$5.74 Delivery to USA

Show details

Description:
1st ed. edition NO-PA16APR2015-KAP. Papeback. New.
Add to wish list
Item price
A$121.85
A$5.74 Delivery to USA