Latest Blog Posts - Page 20 of 412

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

Jul 6, 2024

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

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

Excel Invoice Template

Apr 29, 2024

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)

Jul 16, 2024

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

Context Menu in Excel (All Things to Know)

Alignment in Excel (Types, Change, Shortcut)

Aug 6, 2024

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

Alignment in Excel (Types, Change, Shortcut)

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

Aug 2, 2024

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 Text to Number in Excel? (Complete Guideline)

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

Jul 15, 2024

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

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

Excel Fonts (All Things You Need to Know)

Jul 6, 2024

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

Excel Fonts (All Things You Need to Know)

Top Financial Functions in Excel (15+ Functions)

Aug 5, 2024

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

Top Financial Functions in Excel (15+ Functions)

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

Jul 24, 2024

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

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

Logical Functions in Excel

Jul 31, 2024

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

Jul 12, 2024

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)

Jul 9, 2024

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

Spell Number in Excel (With/Without Currency)

Write, Display and Convert Fraction in Excel: 7 Methods

May 28, 2024

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

Write, Display and Convert Fraction in Excel: 7 Methods

Negative Number in Excel (Add, Format, and Convert)

Aug 4, 2024

Here's an overview of negative numbers in Excel and how they can be formatted. Download the Practice Workbook Negative Number in ...

Negative Number in Excel (Add, Format, and Convert)

Excel Cash Book Template

Apr 29, 2024

Excel Cash Book Template: Knowledge Hub Petty cash book format in excel Daily cash book format in excel Double column cash book format in ...