Latest Blog Posts

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 Hide Row and Column Headings in Excel (2 Suitable Ways)

When using Microsoft Excel, sometimes we need to hide row and column headings to represent our dataset. This is a very basic Excel operation. Are you ...

How to Select Column A as Titles to Repeat on Each Page

Need to learn how to select column A as titles to repeat on each page in Excel? If you are looking for such unique kinds of tricks, you’ve come to ...

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 Create a Month to Month Comparison Chart in Excel – 3 Steps

Step 1 - Create an Organized Dataset Steps: Create a dataset based on month-to-month data. Here, monthly cost in production and ...

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 Create a Bubble Matrix in Excel: 7 Methods

Method 1 - Creating Helper Ranges You need to create the following 4 helper ranges first. These helper ranges are required to create the matrix ...

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

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo