exceltrick.com Open in urlscan Pro
2606:4700:7::a29f:8836  Public Scan

Form analysis
1 forms found in the DOM

Name: mc-embedded-subscribe-form — POST https://exceltrick.us6.list-manage.com/subscribe/post?u=56fb3b4bfd1b169c843bd42cd&id=3bac792b5f

<form action="https://exceltrick.us6.list-manage.com/subscribe/post?u=56fb3b4bfd1b169c843bd42cd&amp;id=3bac792b5f" method="post" id="mc-embedded-subscribe-form" name="mc-embedded-subscribe-form" class="validate" target="_blank" novalidate="">
  <div id="mc_embed_signup_scroll"><label for="mce-EMAIL" style="color:#fff!important;font-size: inherit; text-align: left; font-weight: 100; clear: both; display: block;">Enter your email address to subscribe to this blog and receive monthly
      notifications of new posts by email.</label><input type="email" value="" name="EMAIL" class="email subscribe-email" id="mce-EMAIL" placeholder="Please enter your email address here..." required="">
    <div style="position: absolute; left: -5000px;" aria-hidden="true"><input type="text" name="b_56fb3b4bfd1b169c843bd42cd_3bac792b5f" tabindex="-1" value=""></div> <input type="submit" value="Subscribe" name="subscribe" id="mc-embedded-subscribe"
      class="button subscribe-submit">
  </div>
</form>

Text Content

Excel Trick

Excel Trick - Easy, Smart & Effective!

 * Blog
 * How To’s
 * Excel Functions
 * About


EXCEL CLEAN FUNCTION – HOW TO USE

The CLEAN function comes under the category of text/string functions in Excel.
It is used to remove first 32 non-printable characters from the text. Based

Read More »


EXCEL UNICHAR FUNCTION – HOW TO USE

The UNICHAR function in Excel returns the Unicode character or symbol associated
with the given number. Unicode is a global encoding standard in which each

Read More »


EXCEL UNICODE FUNCTION – HOW TO USE

The UNICODE function is a type of text function in Excel that returns the code
point, also known as Unicode number, against a character, text,

Read More »


FILL HANDLE NOT WORKING IN EXCEL (4 EASY FIXES)

You might not even know what the Fill Handle is while it gets so much of the
work done for you. Today, we’re not talking

Read More »


HOW TO INSERT AN ARROW IN A CELL IN EXCEL (6 EASY WAYS)

The grand job of Excel is to be an analysis tool that gives a quick visual and
graphic indication of data. Arrows also play a

Read More »


EXCEL CODE FUNCTION – HOW TO USE

The CODE function is an Excel text/string function that returns the numeric code
associated with the given character. The returned numeric code corresponds to
the

Read More »


HOW TO INSERT BULLET POINTS IN EXCEL (9 EASY WAYS)

Excel is not a word processor but you can still find several ways of getting a
bullet point on the worksheet because despite being a

Read More »


EXCEL CHAR FUNCTION – HOW TO USE

CHAR function, also known as the character function, is one of Excel's
text/string functions. It accepts an ASCII value as an input and returns the

Read More »


EXCEL MID FUNCTION – HOW TO USE

The MID function returns a specific number of characters from the middle of the
string after we state the starting position and the number of

Read More »


EXCEL RIGHT FUNCTION – HOW TO USE

RIGHT function is one of the string manipulation functions of Excel. The RIGHT
function returns the stated number of characters from the end of a

Read More »


HOW TO COPY CONDITIONAL FORMATTING IN EXCEL (3 EASY WAYS)

The number of convenience stores everywhere is a true indicator of how much we
revel in convenience. Excel agrees with the lot of us and

Read More »


EXCEL LEFT FUNCTION – HOW TO USE

The LEFT function is one of the many common and widely used text/string
functions offered by Microsoft Excel. The LEFT function enables you to extract

Read More »

« PreviousNext »



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

Read More »


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

Read More »


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

Read More »


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

Read More »


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

Read More »


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

Read More »



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

Read More »


#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

Read More »


#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

Read More »


#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

Read More »


#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.

Read More »


#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

Read More »



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

Read More »


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

Read More »


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

Read More »


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

Read More »


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

Read More »


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

Read More »



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

Read More »


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

Read More »


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

Read More »


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

Read More »


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

Read More »


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

Read More »



FEEDBACK

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!

Molly ClaytonExecutive at Equifax
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!

Marco BarnesFinancial Analyst at Keycorp
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!

Derek BauerConsultant at Aviva
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!

Molly ClaytonExecutive at Equifax
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!

Marco BarnesFinancial Analyst at Keycorp

Previous
Next
Exceltrick.com is your one-stop shop to learn all excel tricks, formulas,
how-tos & shortcuts. The goal of this site is to make you an excel geek.
© Copyright 2010-2022 Excel Trick · All Rights Reserved || SiteMap

SUBSCRIBE TO EXCELTRICK

Enter your email address to subscribe to this blog and receive monthly
notifications of new posts by email.

Quick Links: About Us | Terms Of Use | Privacy Policy | Comment Policy | DMCA |
Contact


Update Privacy Preferences