Excel Basics

How to Calculate Inverse Matrix in Excel (3 Ways)

This article will show you various techniques to calculate the inverse matrix in Excel. The Inverse Matrix calculation is a fundamental linear ...

How to Add Excel Feathered Theme

In this article, we will learn how to add Excel feathered theme. While working in Excel, you will find different types of themes that can improve the ...

How to Create Dynamic Table in Excel

Dynamic Tables in Excel provide a revolutionary method for effective data management. Dynamic tables reduce the need for manual updates and resizing ...

How to Create Dynamic Table of Contents in Excel (3 Easy Methods)

A dynamic table of contents in Excel is a very powerful thing that allows users to create an interactive and automated index for their workbooks. By ...

Excel Convert Timestamp to Time (4 Easy Ways)

The timestamp is widely used to record and analyze time-based information, such as financial transactions, online meetings, and event logs. However, ...

How to Insert Excel Table from Image

In this article, we will explore the process of extracting an Excel Table from image. The table is an important feature of Excel. Tables are used to ...

Excel Scientific Notation Without e (7 Quick Tricks)

This article explores methods to convert Excel scientific notation without e to regular numbers. Scientific notation, often denoted with the "e" ...

How to Fit Long Text in One Cell in Excel

Nowadays, Excel is quite a common tool to use in corporate life and day-to-day life as well. As a beginner, many people face some common problems in ...

How to Create Drop Down List from Another Workbook in Excel

Drop-down lists in Excel are a great way to make data entry more efficient and accurate. By using a drop-down list, users can select predefined ...

220++ Keyboard Shortcuts in Excel ( for Quick Navigation)

Shortcuts in Excel allow us to complete a task quickly because we don't have to go through multiple tabs or context menus. Instead, we only need a ...

How to Make a Roster in Excel (with Detailed Steps)

A roster usually indicates a schedule that divides the turn of duties (or even leave) in an organization for an individual or a group. From ...

How to Make a List in Excel (All Things You Need to Know)

In this Excel tutorial, you'll learn how to - Make a drop-down list in Excel (dependent, editable, and dynamic) - Input a message and error alert ...

[Fixed!] Excel Date Filter Is Not Grouping by Month (3 Solutions)

Filtering data according to particular criteria, like filtering dates by month, is one of the most popular Excel tasks. Excel's date filter ...

How to Change Print Area in Excel (7 Smart Ways)

Sometimes, we face the necessity to print out our work in Microsoft Excel as hardcopy. But it has a certain default dimension as a print area. ...

How to Swap Columns and Rows in Excel (9 Easy Ways)

Are you struggling with analyzing or viewing a complex Excel dataset? If so, swapping the columns and rows in your Excel spreadsheet might be the ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo