Latest Blog Posts

How to Use Excel Selection Pane (3 Useful Applications)

To demonstrate the purpose and applications of the Excel Selection Pane is the aim of this content. Often professionals require to build shapes, ...

Excel Overtime Formula

Excel Overtime Formula: Knowledge Hub Calculate Hours Worked and Overtime Using Excel Formula Excel Formula for Overtime over 8 Hours ...

How to Insert and Use Timestamp in Excel?

n the picture below, we have demonstrated an example of inserting a timestamp in Excel. Download the Practice Workbook Timestamp in ...

Toolbar in Excel

Toolbar in Excel: Knowledge Hub Types of Toolbars in MS Excel How to Show Toolbar in Excel How to Restore Toolbar in Excel How to Hide ...

How to Enable and Exit Full Screen in Excel (Complete Guide)

Why Use Full Screen in Excel? Enabling full-screen mode expands the viewable area, allowing you to see more columns and rows simultaneously. When ...

How to Import a PDF to Excel – 2 Easy Methods

This is the sample dataset. Download Practice Workbook You can download the practice workbook and the PDF file: PDF to Excel.xlsx ...

Calculate Date in Excel

Calculate Date in Excel: Knowledge Hub How to Add Days to Date Using Excel Formula Subtract Dates in Excel Excel Formula to Calculate ...

Excel Formulas Names

Excel Formulas Names: Knowledge Hub How to Use Paste Name Dialog Box In Excel <<Go Back to Excel Formulas | Learn Excel

Text Import Wizard Excel

We often need to import data in our Excel worksheet from a different file. The Text Import Wizard Excel is a feature that allows you to simplify the ...

Subtract Dates in Excel

Subtract Dates in Excel: Knowledge Hub How to Subtract Dates in Excel to Get Years How to Calculate Time Difference in Excel Between Two ...

Create, Edit, and Delete a Data Table in Excel

This is an overview: Download Practice Workbook Download the practice workbook. Data Table Excel.xlsx What Is a Data Table in ...

Ageing Formula in Excel (All Things You Need to Know)

Download Practice Workbook Ageing Formula.xlsx Method 1 - Calculate Age in Years We can use the combination of several functions ...

Budget Template in Excel [Free Download]

In this Excel tutorial, we will present a basic budget template in Excel (free downloadable) in a generalized format, as presented in the following ...

Uses of MS Excel

Uses of MS Excel: Knowledge Hub How to Use Microsoft Excel for Beginners << Go Back to Learn Excel

Excel Date Format

This is an overview: Click here to enlarge this image. Download Practice Workbook Date Format.xlsx The Date Format in Excel ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo