Excel Basics

Excel Text to Columns

Excel Text to Columns: Knowledge Hub Convert Text to Columns Excel Convert Column to Text with Delimiter in Excel Excel Text to Columns ...

Sheet View in Excel

Sheet View in Excel: Knowledge Hub How to Use Sheet View How to Turn Off Sheet View << Go Back to View in Excel | Learn Excel

Understanding Views in Excel (A Complete Guideline)

Here's an overview of the View tab and the most common View options you'll need in Excel. Download the Practice Workbook Download this ...

How to Highlight in Excel – 6 Examples

Method 1 - Using Cell Styles to Highlight Cells Select cells >> go to the Home tab >>  Styles >> select Cell Styles >> ...

How to Use Conditional Formatting Icon Sets?

"Icon sets" are used as a performance indicator, progress tracking, risk assessment, comparison and analysis, and so on. They are also helpful for ...

Excel Color Scales (Add, Customize & Remove)

In this article, we will talk about and show how to work with Excel color scales. We will do the task using Conditional Formatting. We will go ...

Excel Table (Insert, Customize, and Applications)

In this Excel tutorial, we will learn in detail about Excel table including inserting, customizing, and using multiple features. An Excel table is ...

How to Add & Remove Page Number in Excel?

In this Excel tutorial, you will learn how to add page number in Excel. You will also learn to add sequential page numbers, page numbers on even or ...

Watermark in Excel (Add, Format, Remove)

In this Excel tutorial, you will learn about the watermark in Excel. This will cover how to insert, reposition, resize, and remove watermarks in ...

How to Unfreeze Panes in Excel

How to Unfreeze Panes in Excel: Knowledge Hub Unfreeze Rows in Excel How to Unfreeze Columns in Excel How to Unlock Cells in Excel When ...

How to Adjust the Margin in Excel (Default/Custom Margins)

  Using the Page Layout Tab STEPS: Select the worksheet you want to print. Go to the Page Layout tab, and from Page Layout, select ...

Page Break in Excel (Insert, Move, Remove and Fix)

In this article, we are going to learn everything about Excel page break. We’ll focus on how to insert page breaks manually as well as based on ...

Create Folder in Excel (Step-by-Step Guide)

Create Folder in Excel: Knowledge Hub Create Multiple Folders at Once from Excel Create Outlook Folders from Excel List Create Files from ...

How to Use Number System Conversion in Excel?

This article is about Excel number system conversion. In this Excel tutorial, you will learn - How to use built-in functions to convert binary, ...

How to Add Quotes in Excel (Single and Double Quotes)

We will use the following sample dataset to insert quotes in various cells. Download the Practice Workbook Use of Quotes.xlsm ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo