How to Create a Star Rating Template in Excel

Here is a quick tip for you to create a star rating template in Excel.To create this star rating template all you need is REPT function. REPT Function is useful when you want to repeat a given text for a number of times.Steps to Create a Star Rating TemplateInsert two different types of stars (☆★) […]

Change the Default Chart Type in Excel

Do you know you can insert a chart with a shortcuts key? You can use Alt + F1 to insert a chart. But here’s a twist. In Excel, default chart type is a two-dimensional column chart. So, if you want to insert a line chart or any other chart which you use frequently with a […]

Select Non-Contiguous Cells in Excel

Normally, when you need to select multiple cells which are not continuing, you press and hold the control key and then select each cell with the mouse.Right?That’s the simple method.But I can bet that you have never heard about selecting non-continues cells without using a mouse.The reason for this is no one ever found this […]

How To Add Secondary Axis In Excel Charts In Simple Steps

Steps For Adding A Secondary Axis In Your Chart Follow these simple steps to create a dual axis. Method 1 Select the data series for which you want to add a secondary axis. Right Click on it & Go to Format Data Series → Series Option → Activate Secondary Axis. Now, you have a two scales in your chart. […]

Add Developer Tab [Windows + Mac]

Developer tab in excel is one of the most important and highly useful options in excel. But, before you use it you need add it on ribbon.When you install Excel, you need to activate it for first time.So today in this post, you will learn 3 different methods to add developer tab in Excel for windows as well […]