Excel Basics

Formatting Currency in Excel (Format, Change & Remove)

This is the sample dataset. Download Practice Workbook Download the practice workbook. Currency Format in Excel.xlsx How ...

How to Apply Excel’s Auto Formatting (Add, Customize, Use & Remove)

What Is Auto Formatting in Excel? Auto formatting in Excel simplifies the process of making your data visually appealing. It provides ready-made ...

Excel Number Format (from Toolbar, Ribbon and Dialog Box)

In this Excel tutorial, you will learn how to apply the number format. You can access number formatting options from the toolbar, ribbon, and number ...

Data Entry Form in Excel

Data Entry Form in Excel: Knowledge Hub How to Create Data Entry Form in Excel How to Make an Excel Spreadsheet Look Like a Form How to ...

Cell Styles in Excel (All You Need to Know)

In Excel, cell styles offer a wide range of professionally designed formats which enable applying a uniform, visually appealing look to worksheets ...

Entering and Editing Data in Excel

Entering and Editing Data in Excel: Knowledge Hub How to Enable Editing in Excel How to Press Enter in Excel Without Changing Cells Making ...

How to Refresh Sheet in Excel

Excel Refresh Sheet: Knowledge Hub How to Refresh Excel Sheet Automatically How to Refresh Excel Sheet Automatically Using VBA How to Auto ...

How to Compare Sheets in Excel

Excel Compare Sheets: Knowledge Hub How to Compare Two Excel Sheets for Differences in Values How to Compare Sheets Side by Side in Excel ...

Organize Sheets in Excel (Sort, Group, Ungroup Worksheets)

Download Practice Workbook Organize Sheets.xlsm Example 1 - Apply Shortcuts to Highlight Sheet Select range B5:D9 >> press ...

How to Rename a Worksheet in Excel

In this Excel tutorial, we have discussed -Several ways of renaming a worksheet. -How to rename an Excel file. -How to rename an Excel table. ...

Grouping Sheets in Excel (All Things to Know)

Are you eager to learn about grouping multiple sheets in Excel? We usually group sheets when multiple worksheets are identical in structure in a ...

Context Menu in Excel (All Things to Know)

In this article, we will discuss the context menu (or right-click menu) in Excel, including 2 ways to open the context menu, how to add and remove ...

Alignment in Excel (Types, Change, Shortcut)

In this Excel tutorial, we will discuss how to apply different types of alignment in Excel. We will use different techniques like using control text ...

Excel Fonts (All Things You Need to Know)

Download Practice Workbook Fonts in Excel.xlsx Method 1 - Using the Excel Ribbon Options Select the cell containing the text you ...

Excel Address Format (All Things You Need to Know)

In this tutorial, you will learn how to format addresses in Excel. You will find four different techniques by which you will be able to format your ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo