Latest Blog Posts

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

Excel Roadmap Templates

Excel Roadmap Templates: Knowledge Hub How to Create a Roadmap in Excel << Go Back to Excel Templates

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

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

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

Logical Functions in Excel

Logical Functions in Excel IF AND OR NOT IFERROR IFNA XOR << Go Back to Excel Function Categories | Excel ...

How to Use the Excel Formula Bar

Show or Hide the Formula Bar 1. Using the View Tab Go to the View tab. In the Show group, select Formula Bar to display it. Deselect it ...

Spell Number in Excel (With/Without Currency)

You can spell out numbers in different currencies as well as without currency as per your requirement. We have a list of numbers and various ...

Write, Display and Convert Fraction in Excel: 7 Methods

Method 1 - Using Mixed Fraction Technique to Display Fraction In cell D5, we have written a proper fraction in a mixed fraction manner, where 0 ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo