Excel Productivity Guide
Useful Excel Tips | Keyboard Shortcuts | VBA Codes
Download this Free E-Book to take your excel skills to a whole next level using some smart Excel tactics.

Worth $20, Absolutely Free

Category Archives for Basic Excel

Insert a Timestamp in Excel

A few years back when I was working for a tech company I was one of those people who were Excel help point for all.And, that’s the real reason I’m fascinated to learn more.One day the lady who was working as a reception coordinator came to me and asked:“Puneet, I’m managing a list of tasks […]

Check it out now

Apply Strikethrough

A few days back, I wrote about different ways to add a check mark for completed tasks. But there also one more thing which we can use: That’s Strikethrough.It means to draw a line through a value in a cell.In Microsoft Word, the option for striking through a text is there on the home tab […]

Check it out now

Sort Horizontally

sort columns in excel

Have you ever wondered that you can horizontally sort data in Excel? I mean, you can sort columns like you sort rows.This is a useful option to streamline columns or if you want to arrange them in alphabetic order.Want to know the best part?You just need 5 seconds for this.So today, in this post, I’d […]

Check it out now

Add Leading Zeros

how to add leading zeros in excel featured image

There are few default rules in Excel which can annoy you. And, one of those rules is you can’t add a zero before a number.The reason behind this is, a zero before a number makes no sense and no value to the number itself.Whenever you try to insert a zero before a number, Excel removes […]

Check it out now

Insert a Check Mark

Last week while traveling on a train, I met a person who asked me a smart question. He was quietly working on his laptop and suddenly asked me this:“Hey, do you know how to insert a check mark symbol in Excel?”And then I figured out that he had a list of customers and wanted to […]

Check it out now