Excel Basics

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

How to Add Subscript in Excel Graph (7 Easy Methods)

If you want to add subscript(s) in an Excel graph, you have come to the right place. Here, we will walk you through 7 easy and effective methods to ...

How to Shuffle Numbers in Excel (7 Easy Methods)

Excel can help you shuffle or randomize different formats of data quickly in easy ways. You can shuffle data within one column as well as around ...

How to Convert Abbreviations to Words in Excel (2 Easy Methods)

In this tutorial, I am going to show you 2 simple methods to convert abbreviations to words in Excel. You can quickly use these methods even in large ...

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

How to Apply Margin Setting in Excel (2 Handy Approaches)

Microsoft Excel is one of the most important and capable computer applications. We can do endless computations on any dataset using Excel's features ...

How to Add Margin in Excel (7 Effective Ways)

Microsoft Excel is a very useful software. We use Excel functions and features for our educational, business, and other daily life purposes. ...

How to Change Default Font in Existing Excel Workbook

The default font is the font you see when you open Excel. Calibri, Times New Roman, and Arial are popular fonts normally used as defaults. You can ...

How to Apply Abbreviation Using Formula in Excel

We will use the following sample data set to apply abbreviations. Method 1 - Combine TEXTJOIN, ISNUMBER, MATCH, CODE, MID, ROW, INDIRECT, ...

How to Change Page Margins to Wide in Excel

In this article, I will show you how to change page margins to wide in Excel. While working on an Excel workbook, sometimes you may need to plot any ...

How to Delete Every Other Column in Excel: 5 Easy Ways

Method 1 - Use Custom Sort Feature to Delete Every Other Column Steps: Add row 3 over the header row. Input the following formula in cell ...

How to Find 2 Letter State Abbreviations in Excel (4 Ways)

Indeed, while working in Excel we may need to obtain the abbreviation of the State names. Though there is no dedicated function to do this, however, ...

How to Make Name Tags in Excel (with Easy Steps)

Name Tags are used very often for practical purposes. This is a useful trick frequently used for efficient data management. In this article, I am ...

How to Delete All Sheets Except One in Excel (2 Quick Methods)

While working in Microsoft Excel, sometimes we need to delete all sheets from a workbook except one sheet or the active sheet. But doing it one by ...

How to Delete Hidden Columns in Excel (2 Simple Methods)

Method 1 - Using the Inspect Document Feature in Excel to Delete Hidden Columns STEPS: Select column D. Right-click and choose Hide. ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo