Cover Image: Excel 2019 Intermediate Reference and Cheat Sheet

Excel 2019 Intermediate Reference and Cheat Sheet

Pub Date:   |   Archive Date:

Member Reviews

This 4 pages leaflet is very useful as it is stuffed with all the shortcut and the main references for "normal" excel usage.

Waiting for the advanced version with pivot tables, vlookup, analytics, statistics etc.

Was this review helpful?

A good reference tool for my excel needs. Sometimes you forget how to do something that's not utilized often so a great reference and cheat sheet for that purpose.

Was this review helpful?

use Excel daily at work and this is a handy chart with so many shortcuts. It's hard to remember the ones I don't frequently use so this is helpful to have on hand rather than having to look up what I need from my notes from the classes I took a while back.

Was this review helpful?

I use Excel daily at work and this is a handy chart with so many shortcuts. It's hard to remember the ones I don't frequently use so this is helpful to have on hand rather than having to look up what I need from my notes from the classes I took a while back.

Was this review helpful?

This Excel Reference and Cheat Sheet is a must for every office. This would be so useful at my school, especially in the main office.

Was this review helpful?

I was given a copy of this book in exchange for an honest review of the information.

Well written, helpful information for the novice Excel user

Was this review helpful?

Excel is not the easiest program to use and even the most experienced still need reference sheets. This Cheat Sheet has a lot of helpful information on how to complete tasks, math, loan payments, sorting, and shortcuts. I recommend this Reference Cheat Sheet!

Was this review helpful?

I am a technical professional and I often need to review or work on excel spreadsheets. I would consider myself to be novice to medium experience level.
This Reference and Cheat Sheet is an excellent tool for my day to day work.
It is handy to keep nearby and use a quick reference and guide. I plan to use this
often.
Highly recommend as a efficient way to work with Microsoft excel in a time efficient and strategic way.

Was this review helpful?

I have not had to use excel for years and I forgot how to do all of this, I love the simple layout and explanations for the equations. I can now calculate loans again.

Was this review helpful?

Priceless resource for junior data analysts and college students.

Very handy resource.

Highly recommended for anyone who uses 'intermediate' Excel formulas and are looking for a handy reference sheet.

Was this review helpful?

Excel 2019 Intermediate Reference and Cheat Sheet by In 30 Minutes
Book Review by Dawn Thomas

4 Pages
Publisher: In 30 Minutes / i30 Media Corp
Release Date: June 3, 2020

Reference, Computers & Internet

This is a very handy guide to have while working with Excel. The command directions are easy to follow. The order of operations & nested functions is an important topic to cover since there can be controversy about which goes first. I was unaware Excel could perform monthly loan payments and a CD’s future value. I always use my financial calculator for those actions.

I think the keyboard shortcuts list is worth its weight in gold. I know how frustrated I get when I want to perform a specific action and wish I knew a way to do it quickly. This is definitely something I will have on hand whenever I use Excel. I highly recommend this to anyone that uses Excel on wither a Windows computer or a Mac.

Was this review helpful?

I love Microsoft Excel and everything it has to offer. That being said, the vast array of options can often be overwhelming. This cheat sheet is both a great guide and a reminder of just some of the many possibilities when it comes to mastering an excel document. Though a brief document it gives a good mix of a key few items that excel is capable off. Worth the read.

Was this review helpful?

Cheat sheet / reference, glossary is extremely informative and the reference at the back is awesome. However, there is so much in excel and then so much that falls under intermediate it is not clear what it would cover for this 30 minute whirlwind discovery. I couldn’t see a pattern or any particular genre / area of excel so whilst it is great it gives you the answers you need in a flash you wouldn’t know if this could help you or not until you’d been through it all. I assume there’s others in the series and so maybe a topic / subject area to cover such as personal finance or People / data management etc would make it a 5 star cheat sheet!

Was this review helpful?

This 4-page document is worth its weight in gold. Although some of the excel formulas are a bit advanced - the final page gives you all of the shortcuts that you would ever probably need for Excel use.

Brilliant

Was this review helpful?

Wow! This reference sheet is a must for anyone who wants to use Excel on more than a basic level, it is definitely the answers to all my prayers. As a frequent user of Excel I’ve only ever been doing what I needed to get by, basically, adding, subtracting etc. After reading through this fact sheet I’ve learnt things I would have never known, it’s going to make my life so much easier,. Every office should have a copy of this, and it’s so handy, much better than having to troll through a thick manual. What a perfect addition to both my work office and my home office. Thank you NetGalley for bringing this to my attention.

Was this review helpful?

An essential PDF guide perfect for anyone, at any level (not just intermediate), as well as for all staff and collections

Was this review helpful?

This cheat sheet is filled with great information and is so helpful to have next to my computer for reference! No matter how many times I type a formula and such, I can never remember. After only a short time, I found this tool invaluable!

Was this review helpful?

This is an absolutely fantastic reference guide for Excel 2019.

Every computer, in every office building, as well as in every home office MUST have this supremely helpful guide on hand.

This is a resource that can (and will) save time, and, as we all know, time is money.

I rate this handy reference guide as 5 OUT OF 5 STARS ⭐⭐⭐⭐⭐ and I know that I will refer to it over and over again for the foreseeable future.

Was this review helpful?

I love Excel and use it frequently. This short reference guide is well-organized, accurate, and helpful. The collection of shortcuts looks particularly useful, and I know I will look back at the order of operations entry when I am debugging a formula. Although I reviewed an electronic ARC, it appears that this will be a four-panel desk reference, which would be easy and accessible to keep at one's work station.

Highly recommended.

Many thanks to NetGalley for the ARC in exchange for an honest review.

Was this review helpful?

I'm an excel newbie and this fact sheet is very helpful! Not too complex or impossible to understand for beginners.

Was this review helpful?