Latest Blog Posts

How to Change Worksheet Tab Color in Excel (3 Handy Ways)

In many cases, we may need to add or change the worksheet tab color in Excel. This helps you identify any worksheet very easily. Also, adding or ...

Column Letter to Number Converter in Excel (5 Easy Examples)

Example 1 - Using COLUMN Function In the given sample dataset, we will use the COLUMN function for two conditions. The first condition is for ...

How to Add Watermark in Excel (2 Easy Ways)

We've used an Excel workbook with multiple worksheets that contain the same dataset. The dataset contains the Categories, Countries, Quantities, and ...

Line Graph in Excel Not Working: 3 Methods

Method 1 - Line Graph Command Is Producing Two Lines If you want to show two lines in a chart, you need to convert one series of data (in this ...

How to Fit Excel Sheet on One Page in Word (3 Simple Ways)

Download the Practice Workbook Fit Excel Sheet on One Page.xlsx 3 Simple Ways to Fit Excel Sheet on One Page in Word This is a consumer ...

How to Make Excel Look Like an Application – 4 Steps

  Step 1 - Creating a Dataset in Different Sheets Open a new Excel File. Add two sheets: Sheet1 and Sheet2. Enter data ...

Excel IFERROR Function to Return Blank Instead of 0

In this article, we’ll demonstrate 3 practical examples of how to get the Excel IFERROR function to return a blank Instead of 0. Introduction ...

How to Apply VLOOKUP to Return Blank Instead of 0 or NA

We will use a dataset with two columns, “Employee” and “Height(cm),” to demonstrate our methods. The value “Ross” is not listed on the primary ...

How to Add Text in the Middle of a Cell in Excel – 5 Easy Methods

The dataset showcases IDs of different Smartphone Products. Method 1 - Using the Excel LEFT and MID Functions to Add Text in the Middle of ...

How to Delete Blank Pages in the Print Preview in Excel – 4 Methods

Method 1 - Set the Print Area in the Page Layout Tab Steps: Select the area to print. Click the Page Layout tab. Select Set Print Area. ...

How to Stretch Excel Spreadsheet to Full Page Print (5 Easy Ways)

Download the Practice Workbook Stretch Spreadsheet to Full Page Print.xlsx 5 Methods to Stretch Excel Spreadsheet to Full Page Print ...

How to Add Single Quotes in Excel for Numbers (3 Easy Methods)

This article illustrates how to add single quotes in Excel for numbers. You may need to wrap some numbers in your dataset in single quotes. This ...

Dealing with Tables with Changing Headers in Power Query

As in real time it happens a lot, we tend to update our original data source a lot, during that period, we may alter the column Header a bit inside ...

How to Calculate the Market Share in Excel – 4 Examples

How Is the Market Share Calculated? The Market share describes how much a company contributes to the total sales of an industry over time. It is ...

How to Add Barcode Font in Excel (Installation and Application)

  What Are Excel Barcode Fonts? Generally, barcodes look like black bars and white spaces and store machine-readable information. Different ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo