Latest Blog Posts

How to Generate Code 128 Barcode Font for Excel

Note: The given VBA user-defined function Code128 can only be used in the Windows operating system. It will not work properly in Mac OS. ...

How to Make Excel Move Automatically to the Next Cell: 4 Suitable Methods

Method 1 - Using VBA to Make Excel Move Automatically to Next Cell Steps: Go to the Developer tab >> click on Visual Basic. The ...

How to See Who Made Changes in Excel (6 Easy Methods)

Method 1 - Applying Version History Feature to See Who Made Changes in Excel All newer versions of Excel come with a Version History feature that ...

How to Calculate Annual Leave in Excel (with Detailed Steps)

Step 1 - Insert Employee Information We are going to calculate the annual leaves of an organization consisting of 10 employees. Input the Names ...

How to Calculate Daily Simple Interest in Excel (3 Easy Ways)

  Below, we have a dataset that contains the Principal Amount, Interest Rate (Daily), and Time (Days). Method 1 - Using a Generic ...

Dividend Reinvestment Calculator with Monthly Contributions in Excel

Dividend Reinvestment Formulas Inputs: Initial Balance: This is the balance you have at the beginning of your calculation of dividend ...

Create Home Loan Calculator in Excel Sheet with Prepayment Option

We’ve taken a Loan Amount of $100,000 for 1-year tenure at an 8% interest rate. The reimbursement system is monthly. We have to repay the loan as ...

How to Stop Calculating 8 Threads in Excel (14 Effective Ways)

Method 1 - Disable Multi-Threaded Calculation Steps Click on the File tab. Select Options. You'll get a dialog box named ...

How to Calculate the Present Value of a Bond in Excel – 3 Methods

  Method 1 - Applying a Conventional Formula The present value can be calculated for a coupon bond or a zero-coupon bond. The conventional ...

How to Calculate Monthly Salary in Excel (with Easy Steps)

Suppose we have a dataset of some Employee Name, Basic Salary of employees, and Total Working Days. We'll use this data to calculate the full salary ...

How to Calculate Gross Salary in Excel: 3 Useful Methods

Method 1 - Utilizing PRODUCT Function to Calculate Gross Salary in Excel You can use the PRODUCT function when salary is based on Working Hours. We ...

How to Use Code 39 Barcode Font for Excel (with Easy Steps)

  Step 1 - Downloading a Suitable Code 39 Barcode Font Close all of your office applications. Download the code 39 barcode font using ...

How to Make Monthly Expenses Sheet in Excel (With Easy Steps)

  Step 1 - Prepare the Excel Workbook Open a blank Excel workbook. Give a clear heading of what it's about. Type the Month names in ...

How to Create a Progress Tracker in Excel (3 Handy Ways)

We have a dataset with a list of people and the percentage of their Task Completed. We'll add progress bar to track their progress. Method ...

How to Capitalize All Letters Without Formula in Excel (4 Methods)

Method 1 - Using the Flash Fill feature to Capitalize All Letters We have a dataset of different Student names and IDs. We want to put the names in ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo