Excel Basics

How to Perform Workflow Automation in Excel (4 Easy Examples)

Doing repetitive work is exhausting sometimes in Excel. We are going to show Excel workflow automation to make your work better. Repetitive work can ...

3 Easy Ways to Press Enter Without Changing Cells

We can change in Excel’s settings for the Enter key to keep the selection from moving. There is also another shortcut- Ctrl+Enter to keep the ...

How to Insert the Double-Headed Arrow in Excel (4 Methods)

The double-headed arrow in Excel serves two purposes: it represents resizing and adjustment of columns or rows, and it can also be used for scrolling ...

How to Create Excel Sparkline for Multiple Data Ranges

Excel is an effective tool for visualizing and analyzing data. Sparklines, a type of small chart in Excel, can be used to represent trends and ...

How to Ungroup Sparklines in Excel (3 Suitable Ways)

The sparklines are very important and handy tools of Excel if you need to show a data trend analysis. A dataset sparklines always appear as a group. ...

How to Use the Intersection Operator in Excel – 5 Examples

Example 1 - Use the Intersection Command and a Function Button in Excel Steps: Press F9. Enter the first level of rows, here C5:E7. Enter ...

How to Concatenate Different Fonts in Excel – 2 Methods

Method 1 - Use the Cells.Value Property in VBA to Join Different Fonts Go to the Developer tab >> select Visual Basic. You can also ...

How to Filter Email Addresses in Excel (5 Methods)

Method 1 - Nesting the IF Function with Multiple Functions Open your Excel spreadsheet. In cell D5, enter the following formula: ...

How to Unfreeze Columns in Excel (3 Quick Ways)

You may have multiple columns in your spreadsheet while dealing with a large dataset. You need to freeze the columns at one place to scroll sidewise ...

How to Deselect in Excel (2 Quick Ways)

In Microsoft Excel, deselecting means removing the active selection of cells or a range of cells in the worksheet. Deselecting cells can be useful ...

Unfreeze Rows in Excel (3 Quick Ways)

When you work with a large dataset, you may find it challenging to scroll through multiple rows and columns. Fortunately, Excel offers the option to ...

How to Fix If Excel Dialog Box Is Hidden (3 Solutions)

  When and Why Is the Dialog Box Hidden in Excel? While multitasking, dialog boxes may get lost behind active windows or applications. ...

Using Excel Data Validation in Date Format – 4 Examples

This is an overview.   This is the sample dataset.   Example 1 - Creating a Dynamic Drop Down List of Dates In ...

How to Unfreeze Rows and Columns in Excel (with Quick Steps)

We frequently work with Excel datasets. For example, when scrolling through a vast dataset, you may need to freeze some rows or columns to keep them ...

How to Merge Cells in Excel Without Merging Actually

Consider the following dataset where the big Employee Information header is made from four different cells. We can insert a header into it without ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo