Latest Blog Posts

How to Save a Worksheet in Excel (2 Handy Approaches)

In this article, we will learn to save a worksheet in Excel. Generally, we can save an Excel workbook very easily. But to save a single worksheet in ...

How to Calculate Sortino Ratio in Excel (2 Methods)

  What Is the Sortino Ratio? The Sortino ratio is a risk-adjustment statistics metric used to calculate the return from a certain investment ...

How to Move Cursor in Excel Cell (2 Useful Methods)

Moving the cursor in an Excel cell is a quite simple and basic task. The arrow keys are the tool that we use most commonly in this regard. But some ...

How to Create an Expense Report in Excel (Easy Steps)

What Is an Expense Report? An expense report is a document that records all expenses incurred by an organization. The common elements included in an ...

How to Automatically Update Stock Prices in Excel – 3 Methods

The following dataset showcases stock information of different companies. Method 1- Right-click to Automatically Update the Stock Prices ...

[Solved]: Share Workbook Not Showing in Excel (with Easy Steps)

Share Workbook is a feature that enables you to share your file with multiple users. If you are using the latest version of Microsoft Excel you might ...

How to Save VBA Code in Excel (3 Suitable Methods)

Method 1 - Save a VBA Code with an Excel Workbook You can save the full workbook with macros. But you have to use another format to keep the macros. ...

How to Remove Dollar Sign in Excel Formula (2 Easy Ways)

  Introduction to Relative, Mixed, and Absolute Cell References We use cell references in Excel to automate the calculation. For example, “=A4 ...

How to Remove Plus Sign in Excel (2 Easy Techniques)

Sometimes, when we extract data from a text file, it might happen that we have extracted some unwanted plus signs. Now, it is required to remove ...

How to Insert a Check Mark in Excel – 7 Methods

Method 1 - Adding a Check Mark with ASCII Characters using the Microsoft Notepad Steps: Open the Microsoft Notepad. Press & hold ALT and ...

How to Convert Percentage to Ratio in Excel (4 Easy Ways)

We have the following dataset containing the mark sheets of some students. Scores are given in percentages. We will convert these percentage values ...

How to Write to a Text File Using Excel VBA

In this article, I’ll show you how you can write to a text file using VBA in Excel. How to Write to a Text File Using Excel VBA (Quick View) ...

How to Calculate Odds Ratio (OR) in Excel

Understanding Odds Ratio (OR) The Odds Ratio (OR) represents the likelihood of an event occurring in one group compared to another group. ...

How to Type Minus Sign in Excel Without Formula: 6 Methods

Method 1 - Apply Insert Tab to Type Minus Sign in Excel Without Formula STEPS: Select cell C5. Go to the Insert tab. From the ...

How to Change Cursor from Plus to Arrow in Excel (3 Easy Steps)

Step 1 - Launch Visual Basic Window Select Visual Basic from the Developer tab. Step 2 - Insert VBA Code Click on Insert > Module. ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo