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 How To

Add a Horizontal Line in a Chart

featured image to add horizontal line in excel chart

While creating a chart in Excel, you can use a horizontal line as a target line or an average line.It helps you to compare achievement with the target you want to meet or an average you need to maintain.Let’s say you have an average value which you want to maintain in your sales throughout the […]

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

Pivot Table Timeline

Learn About Pivot Table Timeline

Using Pivot Table Timeline is not only save your ton of hard work but it will also a good habit of using it in our dashboards. Please follow me & learn how this Pivot Table Timeline will change your life. So here is the complete detail about Pivot Table Timeline.

Check it out now

Refresh All Pivot Tables

refresh all pivot tables at once featured image

A pivot table is one of the best things that I have ever used. I love the thing that I don’t need to insert it again and again. It’s a one-time setup.It saves a lot of time because once you create a pivot table, you just need to refresh it with a single click when […]

Check it out now

Excel’s AUTO FORMAT Option

how to use excel auto format option for quick formatting

Formatting is a tedious task. It’s really hard to format your data every time when you present it to someone.But, this is the only thing which makes your data more meaning full and easy to consume. It would be great if you have an option which you can use to format your data without spending […]

Check it out now
1 2 3 7