Excel Basics

How to Insert Greater Than or Equal to Symbol in Excel (5 Quick Methods)

Let's use the following dataset that represents a student’s obtained grade and marks range to demonstrate how to insert the "greater than or equal" ...

How to Drag Formula in Excel with Keyboard (7 Easy Methods)

The following dataset table has 'Name', 'Salary', 'Increment', and 'Total Salary' columns. We will use a formula to calculate the 'Total Salary' in ...

How to Type Diameter Symbol in Excel (4 Quick Methods)

  Method 1 - Use the Insert Tab to Type a Diameter Symbol in Excel Steps: Select cell C5. Go to the Insert tab and select ...

How to insert a Plus Sign in Excel without a Formula – 3 Methods

The dataset showcases employee information: Name, Department, and Phone.   Method 1- Using the Custom Format Feature to Insert a ...

How to Open Multiple Excel Files in One Window: 4 Easy Methods

Method 1 - Use Windows and Arrow Keys to Open Multiple Excel Files in Single Window Steps: Open the files separately. The first Excel ...

Unable to Open Two Excel Files at the Same Time (12 Solutions)

Method 1 - Update Office and Windows Version Steps: Click the File tab from the worksheet. Click on the Account option. Click the ...

Convert Fraction to Decimal in Excel: 2 Simple Methods

Method 1 - Use the Format Cells Command to Convert Fraction to Decimal in Excel 1.1 Converting into General Format Steps: Copy the fraction ...

Excel Fill Down to Next Value (5 Easy Methods)

  We have a sample dataset with products, companies that make variations of that product, and the serial models they make. There are blank ...

Excel Protected View Message: Office Has Detected a Problem with This File – 4 Solutions

In the image below, Excel is showing the protected view message “Office has detected a problem with this file.” There can be several reasons for ...

How to Enable Drag Formula in Excel (With Quick Steps)

Sometimes, while working in Microsoft Excel, you may find that the drag & drop cursor or the fill handle tool is not showing up. If this occurs, ...

How to Convert Decimals to Days Hours and Minutes in Excel – 3 Methods

This is an overview: Method 1 - Using the TEXT Function to Convert Decimals to Days Hours and Minutes in Excel Step 1: Select a cell to ...

Setting Permissions for a Shared File in Excel (3 Handy Approaches)

Suppose we have a sheet of some students' IDs, names, and a record of their attendance on specific dates. We want to give access to another person ...

How to Insert a Dot between Numbers in Excel – 3 Methods

In the sample dataset, you have the Vehicle Engine Chassis Number, and want to insert dots.   Method 1 - Using the REPLACE Function to ...

How to Format Fraction to Percentage in Excel (2 Quick Methods)

We have some data in fraction format and need to convert the fractional numbers to the percentage format. Method 1 - Convert Fractions to ...

How to Add a Stacked Fraction in Excel: 5 Simple Methods

Method 1 - Using Fraction Format to Add a Stacked Fraction Steps: Select the cells C6:C10 and click Home > Number. Click on the drop-down ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo