Excel Basics

How to Print Selected Cells in Excel – 6 Methods

The dataset showcases 4 columns: Customer Name, Email, Phone Number, and Credit Card Type. Method 1 - Use the Print Option to ...

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

Download Practice Workbook Selecting Multiple Cells.xlsx 7 Ways to Select Multiple Cells in Excel Method 1 - Dragging Mouse to Select ...

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 Use Point and Click Method in Excel (3 Examples)

When you use the Point and Click Method to build a formula in Excel, the formula becomes errorless and the process saves you time. So, it is ...

How to Apply the Same Formula to Multiple Cells in Excel

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

How to Use Excel Formula to Calculate Percentage of Grand Total

Basics of Percentage (%) Percentage (%) is one of the most important mathematical concepts that we use in our daily lives. The percentage is level ...

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

  Option 1 - Performing Calculations from Left to Right 100 – 50 + 30 – 20 + 10 = 10 + 30 +50 - 20 = 40 + 30 = 70 Option 2 - ...

Division Formula in Excel for Multiple Cells: 5 Suitable Methods

Method 1 - Applying Formula to Divide Entire Column Values by Specific Number in Excel Steps: In the cell C5, insert this formula: =B5/10 ...

How to Copy a Worksheet in Excel (4 Smart Ways)

The process of copying worksheets is a very common phenomenon among excel users. Especially, when the dataset gets quite large, we tend to copy the ...

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

In the sample dataset, we have height in cell B5 and width in cell C5. The formula for calculating the area is, Area= Height*Width. We have ...

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 Methods

Method 1 - Order and Precedence of Operators in Excel Excel uses many symbols for mathematical operations. These operations follow some precedence. ...

How to use a Formula for an Entire Column in Excel – 6 Methods

Consider the Performance of Sales Reps dataset. It showcases Names, the 2022 Sales, and the 2021 Sales of each employee.   Method ...

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

There are two ways to make Excel files read-only, either with a password or without. Method 1 - Make an Excel File Read Only without Password ...

How to Print Excel Spreadsheet with Lines and Change Its Color

Download the Practice workbook Printing Spreadsheet with Lines.xlsx 2 Ways to Print Excel Spreadsheet with Lines and Change Its Color We ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo