Excel Basics

How to Link a Text Box to a Cell in Excel – 4 Examples

The dataset showcases a list of products with their sales values, and profit or loss.   Example 1 - Linking a Single Cell to a Text Box ...

[Solved] Embedded Excel in PowerPoint Not Showing All Data

Embedding an Excel file is one of several ways to insert Excel data into a PowerPoint presentation. A copy of the Excel file is attached to the ...

How to Write 1st 2nd 3rd in Excel (3 Easy Ways)

We will use the following dataset. It has three columns B, C, and D for the Student ID, Name, and Position. You can see the position has ordinal ...

How to Write Subscript in Excel (7 Effective Ways)

One of the frequently used features in Excel is the ability to format text, numbers, and formulas to make them more visually appealing and easier to ...

How to Make a Daily Checklist in Excel (2 Simple Methods)

A checklist displays some items, tasks, etc. and beside them, attached boxes where we can put a mark for denoting whether the task is complete or ...

How to Sort Numbers with Letter Suffix in Excel (4 Useful Methods)

In our regular life, we often notice numbers with suffix letters such as product code, zip code, account code, insurance numbers, and lots more. But ...

How to Change Margins in Excel (2 Methods)

Understanding Margins in Excel In Excel, margins refer to the free or empty space around the edges of a sheet or paper. These margins indicate where ...

How to Change Font Size in Excel – A Complete Guide

The following datasets provide an overview. Changing the Default Font Size in Excel To change the default font size in Excel: Go to ...

How to Edit Document Properties in Excel (with Detailed Steps)

Document properties are the combination of all basic properties of that document. It is also called metadata. It contains the author's name, title, ...

How to Abbreviate Days of the Week in Excel (5 Suitable Ways)

Fortunately, many of us use Excel in our business organizations. In any business organization, we use Excel to organize data as per need and make ...

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 Superscript Text in Excel Graph (3 Quick Ways)

In terms of working with Microsoft Excel, you may occasionally need to use superscripts. Superscripts are small numbers or letters that appear ...

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

How to Calculate Exponential in Excel (3 Easy Methods)

While working with Excel, users have to do different types of calculations. Some may be done manually, and some may require special Excel functions. ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo