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 Advance Excel

Best 8 Tips to Filter Data in Excel

Using a filter in Excel is not a #rocketscience. Everyone knows that they can do a lot of things with filter option.But, the bad news is they are not actually using it to the best or maybe they forget to make a habit to use it.And, the good news is you can be one of […]

➲ Continue Reading

Use Data Entry Form in Excel

A data entry form is the best way to enter data in a table. But sometimes it’s time consuming to create a form.While struggling with this problem, I have found there is a default form in Excel which you can use for data entry.The best part about this form is it’s pre-designed and flexible in […]

➲ Continue Reading

Dynamic Drop Down List

A drop down list is a powerful tool.It can help you to make your data entry simple and quick. You can use a drop down list with your dashboards, charts or even with normal data.While using it, one thing always gave me nuts that you need to update its data source whenever you add a new […]

➲ Continue Reading

Steps to Install Font to Generate Barcode In Excel

People who track stock, sales, and purchases in Excel often ask me “how can we generate a barcode in Excel?”.Well, in Excel there is no default option to generate a barcode.And, the bad news is:There is no plan of Microsoft to add any option like this.But here is the good news:You can generate a barcode […]

➲ Continue Reading

Excel Camera Tool

While working in Excel, sometimes, you need to think out of the box.It happens to me sometimes when I share my dashboards and templates with other users and they made changes in it and all of my work break.Well, to solve this problem, I started to use live images of data tables instead of using […]

➲ Continue Reading