September 16, 2020
All You Need to Know About
Excel Tips and Tricks
We have a huge collection of Excel Tips and Tricks compiled for you. Whether you are a beginner or advanced user, you are bound to find hidden gems here for your Excel journey!
Here are the top things on what you can do with Excel Quick Tips:
How to Use Windings Symbols in Excel
Wingdings is a symbolic font that a lot of us use for fun. I do that a lot too! But what if we wanted those cool symbols to be of good use in Excel?
Whenever I tried typing using the Wingdings font, I was not sure which symbol I would get!
I will show you how easy it is to pick a cool Wingdings Symbol and use it in your Excel worksheet!
Here is a sample usage of a Wingdings symbol for stock prices:
I explain how you can Use Windings Symbols in Excel below:
STEP 1: Select the cells that you want to place the symbols in:
From the Font dropdown, select Wingdings:
STEP 2: Now that our cells are able to accept Wingdings symbols, go to Windows Start (Windows 10) > Search Bar > Character Map
If you are have an older version of Windows, go to Start > All Programs > Accessories > System Tools > Character Map
STEP 3: You will now see all the characters! Ensure the Font is Wingdings.
Double click on the symbol you want to use. Click Copy.
STEP 4: Go to your Excel Spreadsheet and click Paste.
Do the rest for the other cells, and you have used Wingdings Symbols!
NOTE: Another way is to click in a blank cell and go to Insert > Symbol > Font: Windings > Insert > Close.
Evaluate Formulas Step By Step in Excel
This is one of the coolest tricks I have seen in Excel, as there are countless times wherein I had a hard time understand formulas. Especially long and complex ones!
Excel provides the way to evaluate your formula, and break it down step by step so that you can understand it!
Let us take the formulas I’ve created below in the IS THE VALUE IN BETWEEN column . We will see how this formula is resolved in a series of steps:
STEP 1: You can see our formula uses both the If formula and the Median formula.
The goal of this formula is to evaluate if a value (VALUE TO BE EVALUATED) is in between the range (START OF RANGE to VALUE TO BE EVALUATED)
For example: Is 50 the median of the range 20; 60; 50?
=IF(C7=MEDIAN(A7:C7), “Yes”, “No”)
To start understanding our formula, highlight the formula, then go to Formulas > Evaluate Formula:
STEP 2: Our formula is now shown on screen, and the part that is underlined is the one to be evaluated first. Click Evaluate.
STEP 3: C7 has been evaluated to 50. Click Evaluate.
STEP 4: The median of the values from A7 to C7 (20, 60, 50) is evaluated as 50. Click Evaluate.
STEP 5: Is 50 equal to 50?
Excel has evaluated it to TRUE. Click Evaluate.
STEP 6: Since the If formula received a TRUE, Excel evaluated it as a Yes end result. We have seen how the formula gave us the result in a few easy steps!
Excel 2019 VS Office 365
Ever wondered what is the difference between Excel 2019 and Office 365? Look no further as we will give you a detailed comparison on Excel 2019 VS Office 365!
We will be using Excel 2019 and Office 2019 interchangeably as they pertain to the entire package :)
First things first, what is the main difference between the two?
- If you purchase Office 2019, this is a perpetual license wherein you pay once and you own it forever.
- Office 365 on the other hand is subscription-based, you either pay a monthly fee or annual fee to keep on using it.
On paper, the own-it-forever sounds better right? But there is more than meets the eye, keep on reading!
Office 365 has two offerings:
- Office 365 Home allows you to have 6 users maximum just for $99.99 a year
- Office 365 Personal allows for 1 user for $69.99 a year
Which means if you have at least 2 users, then Office 365 Home becomes a better deal instantly as compared to Office 365 Personal.
For Office 2019, we are making the assumption that the software has 3 years of ownership, before you upgrade your software to the newer version. This allows us to compute to a cost of $50.00 a year.
And if you see the inclusions, there are more Office Applications included in the Office 365 package. (e.g. Outlook, Publisher, Access, Onedrive, Skype).
So from a cost perspective, Office 365 Home is the better deal, assuming you have at least 2 users (up to a maximum of 6!).
From a features perspective are they exactly the same? Office 365 has one major advantage over Office 2019: Office 365 constantly gets updated with new features every couple of months!
Office 2019 and Office 365 right now are almost at par in terms of features at the time of this writing. However give it some time, and Office 365 will be ahead in terms of the features race.
Another good thing, is the changes are gradual in Office 365 and you get them right away. And as compared to the perpetual Office 2019, the changes are more drastic when you upgrade from one perpetual Office version to another (e.g. Office 2016 to Office 2019).
Here is an example list of the updates that are new in both Excel 2019 and Office 365:
- New functions such as IFS, SWITCH, TEXTJOIN, MAXIFS, MINIFS
- Co-authoring for multiple users
- Assigning default behavior for Pivot Tables
- 3D Models
- Custom visuals such as bullet charts, speedometers and even word clouds!
- The list will grow longer for Office 365 soon!
Debunking the Online Myth
One common misconception is that with Office 365 is you have to be connected to the internet to use it.
It’s not true! Office 365 is installed locally on your computer, similar to how Office 2019 is installed. We suggest moving over to the subscription model, as it keeps your Office applications up to date and you will reap the benefits sooner too!
Imagine seeing a sparkling new feature, then only to discover that your perpetual Office installation does not support it! Office 365 removes this issue outright, as you get it right away as included in your subscription.
And remember, this does not only apply to Excel, but also to all your Office applications as well! (e.g. Word, Powerpoint)
I hope this has been helpful for you in terms of comparing Office 365 and Office 2019. If you can get Office 365, I highly suggest to go for it!
(Disclaimer: We do not make any money or are affiliated with Office 365, we just want you to have the best solution at the most affordable price!)
What Excel Version Do You Have?
If you’re not sure what version you have, go to the File tab of any Office application and select Account.
You will see your version under Product Information.
We have compiled this tutorial which easily shows you which Excel version you currently have: What Microsoft Excel Version Do I Have?
December 19, 2019