How to Change Theme Font in Excel (2 Easy Ways)

Sometimes, we don’t like our default theme font in Excel. Excel gives us a platform where we change the theme font and at the time, we can customize ...

How to Repeat Rows in Excel When Scrolling (6 Suitable Ways)

Sometimes while working with a big dataset we need to repeat rows in Excel when scrolling. This feature helps to keep important rows visible during ...

Excel Cursor Locked in Select Mode: 6 Possible Solutions

Method 1 - Turn Off Extend Selection in Excel STEPS: Look for the F8 function key on your keyboard. Press the key. You can disable ...

How to Type Math Symbols in Excel: 3 Easy Methods

Method 1 - Apply Keyboard Shortcuts to Type Math Symbols in Excel Steps: You want to type the plus sign(+) without formula. Use the keyboard ...

How to a Save Workbook in a Specific Folder Using VBA in Excel (4 Methods)

The below dataset consists of 3 columns: Name, Car Model, and Car Maker. This dataset represents the car information of 6 employees car information ...

How to Convert Decimal to Time Over 24 Hours in Excel (2 Quick Methods)

If you don’t apply the proper format while converting the decimal numbers to times, you will get a time ranging from 0 to 24 hours. However, in this ...

How to Insert Dollar Sign in Excel Formula (3 Handy Methods)

Assume you have the following dataset. It contains sales from two different stores and their total. The FORMULATEXT function shows that the ...

How to Get Rid of Plus Sign Cursor in Excel: 2 Effective Methods

Method 1 - Using Excel Advanced Option Go to the File tab. Select Options from the left navigation menu. An Excel Options dialog box will ...

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

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo