How to Sort Excel Sunburst Chart Order (2 Ideal Examples)

Example 1 - Sort Sunburst Chart Order Alphabetically in Excel Step 1 - Insert Sunburst Chart Select the data range for the chart. Go to the ...

How to Use Multiple Tags in One Cell in Excel – 4 Methods

The following dataset contains three columns: Employee's Name, ID, and Tags. The Tags column contains three types of information. To find managers ...

How to Delete Columns with Specific Text in Excel (3 Methods)

To demonstrate our methods we'll use the dataset below, namely a Monthly Itinerary for a Group of People. We used the Microsoft Office 365 ...

How to Make a Pro Forma Balance Sheet in Excel (6 Steps)

This article will show you how to make a pro forma balance sheet in Excel. We will project three years of financial statements for a startup business ...

How to Create a Drop Down Checklist in Excel (with Quick Steps)

Below is a dataset of several students' names. Of these students, only 3 passed. We want to create a drop-down checklist containing these students' ...

How to Encrypt Cell Content in Excel – 2 Methods

The dataset showcases Account Names, Card Numbers, and passwords. To encrypt the Password:   Method 1 - Applying VBA Macros to ...

How to Change Font in Excel to All Caps (8 Simple Ways)

The following dataset shows company department purchases. We will change the name font to all caps for the person related to the purchase. ...

How to Make a Checklist in Excel – 5 Steps

  This is the sample dataset: Step 1 - Enable the Developer Tab Click Customize Quick Access Toolbar above the Home tab. ...

Using Excel VBA to Scrape a Table from a Website – 4 Steps

This is a real-time data table from the investing.com website. STEP 1 - Open the Visual Basic Editor Go to the Developer tab and ...

How to Use Conditional Formatting in Data Labels in Excel

In this article, we will demonstrate how to use conditional formatting in data labels to present data in charts more eloquently. Download the ...

Excel Practice & Exercises with SUM Function

Problem Overview You will get six exercises related to the SUM function. To illustrate the problems, we have used a dataset. This dataset represents ...

How to Scrape Data from a Website into Excel (2 Easy Methods)

To illustrate our methods, we'll use a table on a webpage (see the screenshot below) that we want to export into Excel for further analysis. ...

How to Change Font Style in Excel (5 Easy Ways)

In this Excel tutorial, we will describe how to change font style. Changing font style in Excel is a process that enhances the visual appeal of the ...

Excel Practice & Exercises with IF Function

This article contains seven Excel practice exercises related to the IF function. The problems are easy to solve, so you will only need a basic level ...

How to Increase Font Size for Printing in Excel (2 Suitable Ways)

Method 1 - Apply Scaling Option to Increase Font Size for Printing in Excel STEPS: Click on File. Select Print. The Print ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo