Excel Basics

How to Select Multiple Cells in Excel (7 Useful Methods)

If you are looking for how to select multiple cells in Excel, then you are in the right place. One of the most basic actions that we perform in Excel ...

How to Shift Cells Down in Excel (5 Easy Methods)

  Method 1 – Using the Keyboard Shortcut  Steps: Select the cell or cell range you want to shift down. Press the shortcut ...

How to Apply Same Formula to Multiple Cells in Excel

Scenario: Let’s consider a sales data set where sellers receive a 10% commission on each product sold. To calculate the commission, we’ve placed a ...

How to Use Excel Formula to Calculate Percentage of Grand Total

In this tutorial, you will learn several methods of using the Excel formula to calculate the percentage of grand total. Basics of Percentage ...

Adding and Subtracting in Excel in One Formula (4 Easy Ways)

Adding and subtracting are the two most common mathematical operations that we do in our everyday lives. In this post, you will learn how to add and ...

Division Formula in Excel for Multiple Cells (5 Suitable Examples)

If you are searching for some special tricks to use division formula in Excel for multiple cells then you have landed in the right place. There are ...

How to Show Formula in Cells Instead of Value in Excel (7 Ways)

In Excel, a lot of things are done using the functions that together make formulas. In this article, we are going to show you some tips on "How to ...

How to Copy and Paste Multiple Cells in Excel (9 Quick Methods)

For this tutorial, we have a dataset of some Employee Names, Employee IDs, and Total Sales. These methods show you how to copy and paste multiple ...

Excel Formula Symbols Cheat Sheet (13 Cool Tips)

In this article, you are going to see some Excel formula symbols cheat sheet. This article will be helpful for learning about the process of ...

How to Insert Formula for Entire Column in Excel (6 Quick Ways)

The heart and soul of an Excel spreadsheet are its formulas and typically you apply these formulas in a range of cells located in columns or rows. ...

How to Make Excel File Read Only (2 Quick Methods)

If you want no one can edit or update your Excel file without your permission, you can make your Excel file read-only. No problem if you don't know ...

How to Print Excel Spreadsheet with Lines and Change Its Color

Have you ever wanted to change the color of the gridlines in Excel or perhaps print the gridlines in your worksheet? Look no further since I will ...

How to Apply Accounting Number Format in Excel (6 Effective Ways)

Select the cells that you want to format. Right-click on the selected cells, and from the context menu, choose Format Cells. Select Number ...

Excel Table vs. Range: What Is the Difference?

There is a great deal of confoundment regarding Table and Range in Excel. Especially, the new Excel users often mistake a table for a range and vice ...

How to Enable and Use Synchronous Scrolling in Excel

The basic concept of synchronous scrolling is the way to arrange two Excel workbooks side by side and scroll through them both at the same time. The ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo