How to Insert Degree Symbol (°C) in Excel (7 Easy Ways)
It must be a hundred degrees out there! This blazing flush of summer gave us an idea for another Excel how-to. The clue’s in the
Excel Trick - Easy, Smart & Effective!
Read More »
Excel AutoCorrect Feature – Enable, Disable & Add Exceptions
If we had a dime for every time AutoCorrect saved us from first and secondhand embarrassment, we’d be minted. We’d also be equally rich for
How to Stop Excel from Rounding (Large Numbers & Decimals)
Excel has its limits and it’s a good thing we’re not talking about temperament here. We'll name one limit and learn at length how to
How to Calculate Compound Interest in Excel (2 Easy Ways)
Today we’re trying to build your interest in compound interest. Interest can be an income on investment or an expense or borrowing. But compound interest
How to Insert Delta Symbol (Δ) in Excel (7 Easy Ways)
The delta symbol (Δ) that you may have a distant memory from the Mathematics classes. The hollow triangle you see up there is called a
How to Calculate Ratio in Excel (4 Easy Formulas)
A ratio shows the quantitative relation between two positive numeric values, indicating how many times one number contains the other. More commonly, you may be
How to Delete Filtered Rows in Excel (5 Easy Ways)
Data is something very crucial and you may need to keep logs of everything for some very rainy day but sometimes you need to sift
How to Calculate Business Days in Excel (3 Easy Formulas)
Where are you from? Are you a TGIF person or is your Saturday spirit drowning somewhere behind the office walls? The most common understanding of
How to Insert Square Root Symbol (√) in Excel (6 Quick Ways)
Excel's main purpose is visualization, calculation, and analysis of data, and a great part of visualization is organized data. The stress on visualization is because
How to Calculate Years of Service in Excel (3 Easy Ways)
Finding out the years of service of employees may come with their resignation. The intent may be to find out the employment duration or to
How to Number Rows in Excel (In 8 Easy Ways)
Numbering rows in Excel. Doesn’t sound like a tough feat, right? Don’t worry, it really isn’t. Why would you need to number rows? When handling
How to Calculate Weighted Average in Excel (2 Easy Formulas)
We all know how averages work, right? Means or averages are easily calculable and represent a central value. That's all fine for regular numbers but
Featured on
Excel Functions
Excel TEXT Function – How to Use
The TEXT function in Excel converts numeric values to a text string. While you'll mostly be fiddling with numbers on an Excel sheet, you may
Excel WORKDAY Function – How to Use
The WORKDAY function is categorized as a Date and Time function. It helps us add or subtract N working days to a date provided by
Excel WEEKDAY Function – How to Use
The WEEKDAY function is a DATE and TIME function that can be used to find the weekday for a given date. The date is supplied
Excel FILTER Function – How To Use
The FILTER function is an Excel function that lets you fetch or "filter" a data set based on the criteria supplied via an argument. The
Excel OFFSET Function – How to Use
The OFFSET function is one of the most enigmatic Excel functions that may take a while to wrap your head around. But I will ensure
Excel IF Function – How to Use
IF function is undoubtedly one of the most important functions in excel. In general, IF statements give the desired intelligence to a program so that
Formula Errors
#N/A Error In Excel – How To Fix
Sometimes, when you’ve used a bunch of lookup tables on your Excel sheet, you might spot a #N/A error. The #N/A error is typically associated
#NAME? Error In Excel – How To Fix
The #NAME? error is a common Excel error because it’s easy to make mistakes that can cause the #NAME? error. In most cases, you’ll be
#DIV/0! Error In Excel – How To Fix
When you’ve done some computations on your Excel sheet, you sometimes look at the whole thing later and find that one of the cells has
#NUM! Error In Excel – How To Fix
The #NUM! error is a frequent visitor on your worksheet. This can make you want to pull your hair out if you’ve used the output
#REF! Error In Excel – How To Fix
Say you’ve got this worksheet from a couple of months ago ready to work with. You pull it up on your computer and start working.
#NULL! Error In Excel – How To Fix
The #NULL! error is less common than other errors like #VALUE! or #NUM! errors. The error is basically Excel telling you that you’ve supplied an
How To's
How to Insert, View, Move And Remove Page Breaks in Excel
If you feel your data is crowding the page it is to be printed on and dividing the data would help with clarity, you can
How to Lock Cells in Excel – Protecting Excel Worksheets
Whether you are trying to steer clear of accidental overwrites, feeling fickle, or trying to protect some important data; all your reasons are good enough
How to Create, Use, Edit and Delete Named Ranges in Excel
Names are one convenient identity. Imagine how we'd be addressed if we didn't have names? Excel tries to make our lives easier by providing us
How to Find and Fix Circular References in Excel
A circular reference occurs when you end up having a formula in a cell – which in itself uses the cell reference (in which it’s
Excel Flash Fill – How To Use
What is Excel Flash Fill, and more importantly, what is so special about it? Flash Fill is a special tool in Excel that can automatically
How to Insert a Checkbox in Excel (In 5 Easy Steps)
Inserting a checkbox in Excel is an easy task. The checkbox control is available in the Excel developer tools option. Checkbox and other controls like dropdowns can
Calculations
How to Calculate Business Days in Excel (3 Easy Formulas)
Where are you from? Are you a TGIF person or is your Saturday spirit drowning somewhere behind the office walls? The most common understanding of
How to Calculate Years of Service in Excel (3 Easy Ways)
Finding out the years of service of employees may come with their resignation. The intent may be to find out the employment duration or to
How to Calculate Weighted Average in Excel (2 Easy Formulas)
We all know how averages work, right? Means or averages are easily calculable and represent a central value. That's all fine for regular numbers but
How to Calculate Square Root in Excel (4 Easy Ways)
Hello there citizen of Excel town! Here's a brainwave. Have you ever thought about getting Excel to do what you have been doing for a
How to Square a Number in Excel (In 5 Different Ways)
The aim is simple. Squaring a number, a number raised to the power 2, the number multiplied by itself; it's all the same thing, you
How to Calculate Age in Excel (7 Easy Formulas)
Excel doesn't have a dedicated function for calculating age, but there are several ways we can use someone's date of birth to compute the person's
Feedback
Excel Trick helped me hone my Excel skills from my college course enough to be able to secure a job during the pandemic. I have now become the excel go-to (still a lot to learn)! So I owe you much of my career. Thanks!
I am writing to thank you for your generosity in sharing your knowledge. You have one of the most useful, unobtrusive sites I have had the pleasure to find. I sincerely appreciate your efforts!
The best excel tutorials I've ever come across! Your articles save me tons of time to do my work, and every formula that I've ever encountered with you has all the right answers!
Previous
Next
ExcelTrick.com offers a variety of resources to help users improve their Excel skills. From beginner-friendly tutorials to advanced formulas and VBA guides, this site offers a wealth of information to help you work more efficiently and effectively.