Excel Basics

How to Group Two Worksheets in Excel (With Easy Steps)

When you are working on a bulk of numbers in separate worksheets you may find it really difficult to input the same data or formula on each one. In ...

How to Tally Words in Excel (4 Useful Methods)

In our practical life, we need to tally words according to different bases and ranges. By using Excel, we can easily tally words in different ...

How to Stop Formula to Convert into Value Automatically in Excel

By default, the calculation mode in Excel is set to Automatic. Thus, when you enter a formula into a range, Excel automatically calculates the value ...

How to Find Outliers Using Z Score in Excel (with Quick Steps)

What Is Z Score? In statistics, the z score represents the standard deviation from the population for a particular data point. This measure tells us ...

How to Find Outliers with Standard Deviation in Excel: 5 Methods

Method 1 - Estimate Mean of Dataset Select cell E5 and entitle the cell as Mean. Write down the following formula into cell F5. ...

How to Ungroup Worksheets in Excel (5 Easy Ways)

In Excel, you can ungroup worksheets. There are a couple of methods for ungrouping Excel sheets. In this article, I’m going to show how to ungroup ...

How to Group Dates by Filter in Excel: 3 Easy Methods

Method 1 - Using Filter Command to Group Dates by Filter in Excel 1.1. Utilizing AutoFilter Simply Steps: Select any data or the entire ...

How to Create an Email Address with First Initial and Last Name Using Excel Formulas (3 Methods)

Dataset Overview Our dataset contains the first and last names of some people. Method 1 - Combine LOWER and LEFT Functions Open your ...

How to Separate the City State and Zip from the Address Using an Excel Formula – 4 Steps

The sample dataset contains Addresses in column B.  The Address includes the Street, City, State, and Zip code. Step 1 - Combine the LEFT and ...

How to Organize Bank Statements in Excel – 2 Methods

  How to Create a Bank Statement Outline Using Data Organization Guidelines in Excel Create an organized outline for a Bank Statement using ...

How to Create Tally Salary Slip Format in Excel (With Easy Steps)

This tutorial will demonstrate how to create a tally salary slip format in Excel. For a professional, it is very important to understand what a ...

How to Convert Formulas to Values in Excel: 8 Quick Methods

Method 1 - Use Paste Special Command to Convert Formulas to Values Steps: Select cells (F5:F14). Press Ctrl+C to copy. Click Home ...

How to Analyze Survey Data in Excel: 6 Quick Methods

Method 1 - Creating a Survey Form for Feedback Create all the questions regarding your products. Create five questions to get the feedback ...

How to Analyze Survey Data with Multiple Responses in Excel (2 Methods)

Suppose we have a dataset of compiled survey data and we want to analyze it. In this article, we'll use multiple formulas and the Power Query ...

How to Hide All Comments in Excel (3 Simple Methods)

While working in an Excel workbook you can add comments in a cell which works as a reminder or explanation. If you insert a comment in a cell, a red ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo