Latest Blog Posts

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 Insert a Comma in Excel for Multiple Rows (3 Methods)

Dataset Overview Suppose we have a dataset with several rows containing data, and we want to insert a comma at the end of each row. ...

How to Remove Zeros in Front of a Number in Excel (6 Easy Ways)

Method 1 - Convert Numbers in Text Format to Number Format to Remove Zeros in Excel 1.1 Using Error Checking Option to Remove Zeros in Front of a ...

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 Add Text in an IF Formula in Excel (6 Methods)

Dataset Overview Let’s consider a Report Card dataset displayed in cells B4:C14. This dataset contains student names and their scores. ...

How to Fit All Columns on One Page in Excel (6 Methods)

The sample dataset contains 21 employees in the range of cells B4:H25. Looking at Page Break Preview shows that the table is broken over two pages. ...

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 Change Pie Chart Colors in Excel (4 Easy Ways)

Method 1 - Use Fill Color Tool to Change Pie Chart Colors Double-click on any of the slices in the pie chart. Right-click and select ...

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

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo