Excel Basics

Excel Freeze Panes Not Working (5 Causes with Fixes)

A typical Excel dataset contains hundreds of rows and tens of columns. Excel Freeze Panes helps users to instantly recognize entries just by looking ...

How to Add 10 Percent to a Number in Excel (2 Easy Methods)

We often need to add a certain percentage to a number. This article shows 2 quick and easy methods for how to add 10 percent to a number in Excel. ...

How to Exclude a Cell in Excel AVERAGE Formula (4 Methods)

In Microsoft Excel, we use the AVERAGE function to determine the average of specific values from a data range. To extract the exact value of the ...

How to Calculate Monthly Growth Rate in Excel (2 Methods)

We calculate the monthly growth rate to figure out how much our assets and investments are worth. Microsoft Excel makes this task easier. From our ...

How to Print Excel Sheet with Lines (3 Easy Ways)

When reading data on worksheets printed in Excel, lines of the row and column titles can be useful. But, those lines aren't printed on a Microsoft ...

How to Use the Exponential Growth Formula in Excel (2 Methods)

In this article, we’ll discuss several examples of using the exponential growth formula in Excel. In one method we’ll explain how to use one of ...

How to Freeze Top 3 Rows in Excel (3 Methods)

While working with a large Excel worksheet, you may need to freeze different numbers of rows. It will allow you to navigate through your entire ...

How to Hide Rows Based on Cell Value in Excel (5 Methods)

In day-to-day uses, we need to hide rows based on cell values in Excel to deal with a huge dataset. Typically, an Excel dataset contains numerous ...

How to Use Profit and Loss Percentage Formula in Excel (4 Ways)

If you know how to track the performance of your business finances, you'll have a better idea of what you should do next. For anyone running their ...

How to Print Graph in Excel (5 Ways)

Microsoft Excel provides multiple ways to print a graph or chart. While printing a chart or a graph in Excel, you can change the page orientation to ...

How to Repeat Number Pattern in Excel (5 Methods)

While working with a large dataset in Microsoft Excel, sometimes we need to repeat the number pattern. Our today’s dataset is about information from ...

How to Apply Percentage Formula for Multiple Cells in Excel (5 Methods)

Sometimes, in our Excel worksheet, we need to apply the percentage formula in multiple cells to get particular information, or to compare between ...

How to Freeze Top Row and First Column in Excel (5 Methods)

While working with a large Excel worksheet, you may need to freeze the top row and first column. It will allow you to navigate through your entire ...

How to Calculate Margin Percentage in Excel (5 Easy Ways)

If you are searching for ways to calculate margin percentage in Excel, then you are in the right place. Margin is basically the difference between ...

How to Sort Excel Tabs in Ascending or Descending Order

In Microsoft Excel, If we wish to sort Excel tabs, there are no built-in functions or tools to do that. We can only do it manually or using macros ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo