User Posts: Hosne Ara
0
Excel VBA to Sort a ComboBox List Alphabetically
0

The ComboBox is a special feature of Excel. If we ever need to choose from multiple options, VBA ComboBox is there for the job. Not only that, but we can also ...

0
How to Calculate Sortino Ratio in Excel (2 Methods)
0

In this article, I will discuss how you can calculate the Sortino Ratio in Excel. I will calculate this using excel formulas and VBA. Before starting the ...

0
How to Open Multiple Excel Files in One Window (4 Easy Methods)
0

This article will discuss how you can open multiple excel files in one window. Often working with Microsoft Excel, we may need to open and view multiple ...

0
How to Protect Formulas in Excel (With Easy Steps)
0

This article will discuss how you can protect formulas in Microsoft Excel. Sometimes, when you share spreadsheets with other people, you might want no one to ...

0
How to Recover File after Crash in Excel (4 Methods)
0

In this article, I will discuss how you can recover an unsaved excel file after a crash. A crash can happen due to several reasons. For example, your PC can ...

0
How to Hide Toolbar in Excel (3 Quick Methods)
0

In this article, I will discuss how you can hide the Toolbar (Ribbon) in excel. The Excel Toolbar is located on the top of the excel window and contains a ...

0
How to Calculate Difference Between Two Times in Excel (8 Methods)
0

While working in Microsoft Excel, we often have to calculate the difference between two times. Calculating time differences is a very common operation in ...

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

In this article, I will discuss how you can create a client database in Microsoft Excel. Usually, a traditional database has tables, fields, records, primary ...

0
How to Convert Excel to Word Labels (With Easy Steps)
0

In this article, I will discuss how you can convert a mailing list in Excel into MS Word mailing labels by applying the Mail Merge feature. Often when we have ...

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

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

0
How to Make Excel Workbook Read Only with Password (With Easy Steps)
0

While working with Microsoft Excel, often we have to make the workbook read only with a password for the sake of data integrity. We protect workbooks with ...

0
How to Subtract in Excel Based on Criteria (3 Suitable Examples)
0

This article will discuss methods to subtract excel data based on different criteria. While working with Microsoft Excel, we subtract cell values using the ...

0
How to Separate Date from Text in Excel (4 Methods)
0

In this article, I will discuss how you can separate the date from text strings in Microsoft Excel. While working with excel, often we receive spreadsheets ...

0
How to Open Two Excel Files Separately (5 Easy Methods)
0

In this article, I will discuss how you can open two excel files separately in different windows. People who are using updated versions of excel won't face ...

0
[Fixed!] Excel Rows Not Showing but Not Hidden (3 Reasons & Solutions)
0

Sometimes, while working in Microsoft Excel, we see some rows not showing although they are not hidden. In such cases, the usual Hide & Unhide option of ...

Browsing All Comments By: Hosne Ara

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo