Excel Basics

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 ...

How to Repeat Column Headings on Each Page in Excel – 3 Methods

This is a large dataset showcasing months and the corresponding sales amount in different countries. There is no column heading in the print ...

How to Align Checkboxes in Excel (2 Easy Ways)

A checkbox is an interactive tool in Excel that lets you select or deselect an option. Checkboxes can be used to make dynamic charts, dashboards, and ...

How to Save Excel Chart as High Resolution Image (6 Easy Ways)

In this article, we will demonstrate 6 easy ways to save an Excel chart as a high resolution image. To illustrate the methods, we will use the ...

How to Convert Percentage to Whole Number in Excel (4 Methods)

This article will demonstrate how to convert a percentage to a whole number in Excel. About Percentage and Whole Numbers Percentage refers to ...

How to Remove Column1 and Column2 in Excel (4 Easy Methods)

We’ll use a sample dataset as an example in Excel. We have Column1 (Names) in Column B, Column2 (Working Hours) in Column C, and Column3 (Daily Pay) ...

How to Create Trend Charts in Excel (4 Methods)

Overview of Trend Charts in Excel A trend chart illustrates the overall pattern of data over time. The trendline ...

How to Remove Page 1 Watermark in Excel (4 Easy Methods)

Method 1 - Change Workbook Views to Remove the Page 1 Watermark in Excel In many situations, a page 1 watermark appears in an Excel workbook because ...

How to Make Excel Look Pretty (16 Easy Formats)

The following data table represents the monthly data of a company. The Month, Employee Name, Total Assigned Leave, Leave Taken, and Salary are the ...

How to Set Print Titles to Repeat in Excel (2 Ways)

Example 1 - Setting Column Titles to Repeat in Excel The sample dataset contains data up to Week 47 which will come to more than one page when ...

How to Change the Default Background Color in Excel

Below is a dataset that contains information about several Sales Representatives of the Armani group. Columns B, C, D, and E give the names of the ...

How to Copy the Sum from the Status Bar in Excel – 3 Steps

The sample dataset showcases Employee Names. Step 1 - Make the SUM Data Visible in the Excel Status Bar Prepare the dataset by ...

How to Convert Peso Number to Words in Excel (With Easy Steps)

This tutorial will demonstrate how to convert peso number to words in Excel. Undoubtedly it is very important to convert the currency numbers into ...

How to Fix Background Color Not Changing in Excel (6 Solutions)

Reason Behind Background Color Not Changing in Excel By default, the fill color of cells in an Excel worksheet cannot be modified. Each cell starts ...

How to Automatically Insert Serial Numbers in Excel Based on Another Column (4 Examples)

Example 1 - Combination of COUNTIF and IF Functions To create auto serial numbers with specific criteria, we’ll use the SUM, IF, and COUNTIF ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo