Top 100 Microsoft Excel Tips and Tricks which will Make You a PRO this Year

Every Excel user do need a list of tips and tricks...

...which he/she can use to learn to save time.

Even if you learn a single tip a day you can learn 30 new things in a month.

It's a lot.

But the point is…

You must have a list which you can refer to every day.

Well, you don’t need to worry about this anymore, I’m here to help. I have listed Top 100 Excel Tips and Tricks for you.

And this is the most comprehensive list.

Yes, it is.

All the tips and tricks are listed under a specific category​ which makes easy to follow the entire list.

​...List of Top 100 Excel Tips and Tricks You need to Learn this Year to Increase your Productivity in No Time

Without any further ado below is the list of tips and tricks that can make you an advanced Excel user this year.

...now, let's get started.

📌 In this entire list, I have marked some of my favorites tips 🔥 which I love to use and I’m sure you’ll also love them.

Basic Tips

If you are just starting out with Excel then these tips can save you a lot of time and can help you to get better quickly in everyday tasks.

Serial Numbers

Current Date and Time

Select Non-Adjacent Cell 🔥

Sort

Drag and Drop

Status Bar 🔥

Clipboard

Bullet Points

Copy of Worksheet

Undo-Redo

Formatting Tips

Formatting is one the boring things when it comes to data and reporting and here we have some of the time saver formatting tips for you which you can use in your daily work.

Auto Format

Format Painter

Cell Message

Strikethrough

Barcode 🔥

Month Name

Highlight Blank Cells

Font Color with Custom Formatting 🔥

Theme 🔥

Clear Formatting

Formula Tips

Formulas and functions are the core power of Microsoft Excel. In short, they can make you great and here we have some formula tips which can make you smart.

Sentence Case

Random Numbers

Count Words

Calculate Age

Ratio

Root of Number

Days in Month

Month’s last Date

INDEX MATCH

SUMPRODUCT IF

Charting Tips

To make you better at charting, here some of my favorite tips and I’m pretty sure that these charting tips will help you to create charts in a smart way.

Smooth Line

Chart Formatting 🔥

Hide Axis Labels

34. Display Units

Round Corner

Hide Gap

Insert Picture 🔥

Chart Template

Default Chart

Hidden Cells

Printing Tips

In my clarity, one of the most time-consuming thing in Excel is printing reports.

So many times we need to adjust custom margins, scaling, or adding header and footers.

Here is the list of some awesome printing tips which you can use will printing your reports (These tips were originally published on ExcelDemy).

Print Titles 🔥

Page Order

Print Comments

Scale to Fit

Custom Header-Footer

Center on Page

Print Area

Custom Margin

Error Values 🔥

Custom Start Page Number

Advanced Tips

There are some options in Microsoft Excel which are meant to perform a specific function and can help you to get better at Excel in no time...

...and here I have listed some of those tips and tricks which you can use in your daily work.

Tracking Important Cells

Flash Fill 🔥

Combine Worksheets 🔥

Protect a Workbook

Live Image

Userform 🔥

Custom Tab

Goal Seek

Text to Speech

Named Range

Data Cleansing Tips

If you work with messy data then these simple tips can help you to clean your data in no time and the best part about these tips is, they are quick to learn.

Trim

Remove Duplicates

Merge Text

Remove Specific Character

Combine Text 🔥

Unpivot Data

Delete Error Cells

Arrange Columns 🔥

Convert to Date

Negative to Positive

Mouse Tricks

We all are eager to learn more keyboard shortcuts so they can work fast.

But, there are some tricks which we can perform with a mouse as well and these are some mouse tricks which you can use to speed up your work.

Format Painter

Rename a Worksheet

Fill Handle

Hide Ribbon 🔥

Edit a Shape

Column Width

Go to the Last Cell

Chart Formatting

Pivot Table Double Click

Right Click 🔥

Tips for One Time Set-Up

There are few options in Excel which you can customize according to your need to save your time and efforts on-wards and I have listed some of those here. 

Default Location

Disable Start Screen 🔥

Developer Tab

Enable Macros

AutoCorrect Option

Custom List

Apply Table 🔥

Grid-line Color

Pin to Taskbar 🔥

Time Saver Tips

Excel tips are all about saving time and making you more productive. Below we have some time saver tips which you can use.

Select Formula Cells

Multiply using Paste Special

Highlight Duplicate Values

Quick Analysis 🔥

RUN Command

Open Specific File

Open Excel Automatically 🔥

Smart Look Up

Screen Clipping

Locate a Keyboard Shortcut


2019-01-11T12:05:11+00:00

30 Comments

  1. Ebrima M. Njie 12 Jan, 19 at 4:51 pm - Reply

    I like it.

    • Puneet 13 Jan, 19 at 10:32 am - Reply

      I’m so glad you liked it. 🙂

  2. Yussif A Abdul Rahman 8 Jan, 19 at 11:14 am - Reply

    Very useful tips and I am loving them. Thanks for sharing.

    • Puneet 8 Jan, 19 at 11:40 am - Reply

      I’m so glad you liked it. 🙂

  3. Akash Jaiswal 7 Jan, 19 at 9:32 am - Reply

    Amazing tricks and tips. I love to read this kind of article:)

    • Puneet 8 Jan, 19 at 11:40 am - Reply

      I’m so glad you liked it. 🙂

  4. Said 16 Dec, 18 at 6:54 am - Reply

    Great Excel Tips. Keep it up.

    Thank you

    • Puneet 1 Jan, 19 at 2:45 am - Reply

      Thanks for your words. 🙂

  5. sam 14 Dec, 18 at 2:58 pm - Reply

    Awesome Content….Mind Blown

    • Puneet 1 Jan, 19 at 2:45 am - Reply

      I’m so glad you liked it. 🙂

  6. Aman 12 Dec, 18 at 6:43 am - Reply

    I have two cell with the format of 26/01/2018 10:30:40 & 15/08/2018 16:00:25. Now I need to calculate the time and days difference accordingly. Could you please help me or do you have any formula to solve this calculation?

    Thanks for your support!

    • ImAtWork 21 Dec, 18 at 10:56 pm - Reply

      I’m going to assume your dates are in cells A1 and B1 respectively.

      Try:

      =rounddown(B1-A1,0)&” days and “&text((B1-A1)-rounddown(B1-A1,0),”h:mm:ss”)

  7. Shailesh 23 Nov, 18 at 4:37 pm - Reply

    Nice Experience in Excel with your amazing tips N tricks, Thanks…

    • Puneet 8 Dec, 18 at 11:18 am - Reply

      You’re welcome. 🙂

  8. Chetan 19 Nov, 18 at 1:43 pm - Reply

    Great tips. I am a bit confused with tip no. 80 – appears the information given in there is incomplete.

    • Puneet 27 Nov, 18 at 9:05 am - Reply

      let me update it.

  9. Dhananjay 10 Nov, 18 at 6:20 pm - Reply

    Hi Mr Puneet

    This is simply great and all are awesome tricks and tips. Thanks.

    • Puneet 11 Nov, 18 at 10:42 am - Reply

      You’re welcome. 🙂

  10. REHAN 12 Oct, 18 at 10:08 am - Reply

    REALLY A GREAT WORKING

    • Puneet 8 Dec, 18 at 11:18 am - Reply

      Thank you so much. 🙂

  11. Armunanto 9 Oct, 18 at 2:35 pm - Reply

    It’s very useful.. I just said many thanks for your help..

    • Puneet 12 Oct, 18 at 10:47 am - Reply

      Thanks for your Words.

  12. Kanhaiyalal Newaskar 1 Oct, 18 at 9:03 am - Reply

    Sir,
    I must appreciate your efforts to teach deeply every topic. I hope every one who is following those steps, as I am, will surely be satisfied.
    And hope to receive more tips infuture.
    Thanking you.
    Kanhaiyalal Newaskar. Ahmednagar. Maharashtra.

    • Puneet 3 Oct, 18 at 11:23 am - Reply

      Thanks for your Words.

  13. Mg Aye Thar 18 Sep, 18 at 12:49 am - Reply

    thanks

    • Puneet 18 Sep, 18 at 8:50 am - Reply

      You’re Welcome, Mg.

  14. Madhav neupane 12 Sep, 18 at 8:23 am - Reply

    Super so super very very useful tricks . i salute to your willingness to share such remarkable knowledge.

    • Puneet 12 Sep, 18 at 10:09 am - Reply

      Thanks for your words, Madhav. 🙂

Leave A Comment