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

Dynamic Drop Down List

quickly create a dynamic drop down list in excel featured image

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 […]

Check it out now

Generate Barcode In Excel

how to create a barcode template in excel featured image

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 […]

Check it out now

Excel Camera Tool

Learn About Excel Camera Tool Before Creating Your First Dashboard

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 […]

Check it out now

Concatenate a Range of Cells

2 concatenate a range of cells with fill justify

CONCATENATE is a handy function to concatenate text from different cells. You need to refer to the cells which you want to combine. It’s simple and easy to apply.But here is a bad news. In concatenate, it’s not possible to refer to an entire range.You need to select all the cells of a range one […]

Check it out now

Watch Window

Delete A Cell In Watch Window In Excel

Often there are some cells in our worksheet where we have important formulas. And, those formulas help us to calculate some crucial values.In this situation, it’s really important to take an eye on those cells, whether the calculation is correct or there is no error.But the point is, the more you have this kind of […]

Check it out now
1 2 3 5