Excel Basics

[Fix]: Formulas Not Copying Down in Excel Table (3 Solutions)

To save the consumption of time, you may need to apply the same formula in a number of columns in an Excel table. But sometimes it won't work for ...

How to Change Case in Excel Without a Formula (5 Ways)

Excel offers changing cases in Excel either using a formula or without even using formulas. In this article, you will learn 5 ways to change cases in ...

How to Add Number with Text in Excel Cell with Custom Format (4 Ways)

We will use four different approaches to add text with numbers to customize a cell format. Here's a simple data set to showcase how we'll convert ...

How to Keep Header in Excel When Printing (3 Ways)

  For this tutorial, we'll use a table that has 50 rows which aren’t possible to print on one page. Upon printing, on the second page, ...

How to Extract Data from a List Using Excel Formula (5 Methods)

Method 1 - Combine INDEX, MATCH, and COUNTIF Functions to Extract Unique Values from a List We have a dataset containing some names. We will extract ...

How to Filter in Excel with Merged Cells (Step-by-Step Procedure)

  We will use a dataset of Product Names in merged cells to demonstrate how you can filter based on them. Steps Select the table ...

How to Find and Replace the Asterisk (*) Character in Excel – 4 Methods

The dataset below showcases employees' details with an ‘*’ in column B. To replace the ‘*’ with ‘,’ in column C: Method 1 - Use the ...

How to Extract Data from Cell in Excel (5 Methods)

Consider the following Student Information List, which shows Serial No, Student ID, and E-mail ID columns. We will use 5 different methods to extract ...

How to Extract Data from Excel to Word (4 Ways)

The sample dataset represents sales in two consecutive Months and Total Sales. Method 1 - Using Paste Special to Extract Data from Excel ...

How to Format a Number in Thousands K and Millions M in Excel (4 Suitable Ways)

We'll use the following simple dataset to showcase formatting a number in terms of thousands with K and millions with M. Method 1 - Use a ...

Excel Wrap Text Cutting off Words: 4 Solutions

Fix 1 - If the Row Height Is Fixed If the row height is predefined, you get the problem of cutting off words after wrapping the text in Excel cell. ...

How to Provide Table Reference in Another Sheet in Excel

Say we have Sale data in Table format for March’22 for three different cities, New York, Boston, and Los Angeles. These three sets of Sales data are ...

Excel Auto Fit Row Height for Wrap Text (4 Methods)

    Method 1 - Keyboard Shortcuts to Auto Fit Row Height and Text Wrap in Excel The sample dataset contains a list of top ten books by ...

How to Make an Excel Table Expand Automatically (3 Ways)

In the sample dataset below, some aspects of the table can become unclear due to inadequate row height and column width. Method 1 - Make ...

How to Search by Sheet Name in Excel Workbook (2 Handy Methods)

Method 1 - Right-click the Navigation Button The Navigation button can be found just above the Status bar. In an Excel workbook containing ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo