Advanced Excel

How to Create an Employee Database in Excel (with Easy Steps)

To keep track of employee information, we may need an Excel database with fields such as names, positions, salaries, and experiences, among other ...

How to Enable Share Workbook in Excel

This article illustrates how to enable the Share Workbook button in Excel. You can easily access the Share Workbook button in Excel 2013 and earlier ...

How to Share Excel File for Multiple Users

For working together in a team or organization, you might often need to share an Excel file. So that all of you can edit the workbook at the same ...

How to Send Bulk Email from Outlook Using Excel (3 Ways)

If you are looking for ways to send a bulk of email from Outlook using Excel, then you are in the right place. Sometimes we need to send the same ...

How to Convert CSV to Excel with Columns (5 Methods)

In this article, I will discuss how you can convert CSV files into Excel files with multiple columns (.xlsx format). As CSV files are easy to operate ...

How to Transpose Rows to Columns Based on Criteria in Excel (2 Ways)

Generally, The TRANSPOSE function may often be used to convert rows to columns. However, results depending on certain criteria, such as unique ...

Copy Table from PDF to Excel with Formatting (2 Effective Ways)

If you have a table in PDF format that you want to copy to your Excel worksheet, you may get jumbled and non-formatting results. As PDFs and Excel ...

How to Split Column in Excel Power Query (5 Easy Methods)

While working with large Microsoft Excel, sometimes we need to split columns using a power query. Splitting columns by using the power query is an ...

How to Convert CSV to XLSX Command Line (with Easy Steps)

There are a few ways to convert CSV files to Excel files (.xlsx, .xlsm). But you can do it by using the Windows command line. Additionally, it has ...

How to Link PDF Form to Excel Database (with Easy Steps)

You may need to know how to link a PDF form with an Excel database to update dynamic records if you have to keep individual records and the ...

How to Create a Database That Updates Automatically in Excel

This article illustrates how to create a database in Excel that updates automatically with the help of 4 useful methods. It’s an important feature ...

How to Create Inventory Database in Excel (3 Easy Methods)

In this article, we will create an inventory database in Excel. Generally, an inventory database is used to keep track of the products. Any retailer ...

How to Use Database Functions in Excel (With Examples)

This article illustrates how to use the database functions in Excel. There are 12 database functions in Excel. This article shows how to apply them ...

How to Create a Database with Form in Excel

In many cases, you might need to create a database in Excel. Luckily, Excel provides a data entry Form to accomplish such a task efficiently instead ...

How to Create a Relational Database in Excel (With Easy Steps)

Relational Databases identify the relations among the information stored across many different data tables. They ease the operations in Excel ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo