Latest Blog Posts

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

Excel Invoice Template

Excel Invoice Template: Knowledge Hub Tally sales invoice in excel format Tally vat invoice format in excel Proforma invoice for advance ...

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

How to Edit Scatter Chart in Excel

Edit Scatter Chart in Excel: Knowledge Hub How to Change Bubble Size in Scatter Plot in Excel How to Add Second Vertical Axis in Excel ...

How to Convert Text to Number in Excel? (Complete Guideline)

In this Excel tutorial, we will discuss various ways to convert text to number format, including using Error Checking, Paste Special, Text to Columns ...

How to Convert Numbers to Text in Excel (4 Methods)

Method 1 - Using the TEXT Function The TEXT function in Excel can convert any value to text, including numbers. You can also specify a specific ...

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

Quick Access Toolbar in Excel: A Complete Guideline

In this article, we will introduce Quick Access Toolbar in Excel to you. We'll show you how to add or remove command buttons, change their order, ...

Excel Percentage Formula Examples

Excel Percentage Formula Examples: Knowledge Hub Calculate Percentage of Month in Excel Calculate Error Percentage in Excel Apply ...

List of Complex Functions in Excel (10+ Functions)

A complex number is a combination of real numbers and imaginary numbers represented in x+iy format. Where x is the real part and y is the coefficient ...

Top Financial Functions in Excel (15+ Functions)

1 - FV Function (Future Value) The FV function is an Excel financial function that is used to calculate the future value of an investment based on a ...

How to Use Subscript and Superscript in Excel: A Complete Guide

Understanding Subscript and Superscript In mathematics, computing, and typography: Subscript: A character or symbol written in the bottom-right ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo