Latest Blog Posts

Scrolling in Excel: Options, Smooth Scrolling, Scroll Lock, Custom Scroll Bar, and Issues

Excel Scrolling Options for Vertical and Horizontal Scrolling 1. Scrolling Using the Arrow Keys To scroll up, select a cell => Press the Up ...

How to Use the Excel Student Loan Amortization Schedule [Free Download]

Download the Free Excel Student Loan Amortization Schedule Template Feel free to download our free Excel Student Loan Amortization Schedule ...

How to Export Data from Excel to Doc, PDF, CSV, XML, vCard

This is an overview.   1. Using the “Save As” Command to Export Excel Data to Text or CSV File This is the sample dataset. To ...

Find and Replace in Excel (A Complete Guideline)

In this blog post, you will learn how to find and replace data in Excel- Using the Find and Replace tool Using the Go to Special feature for ...

How to Extract Data from Excel – 10+ Basic & Advanced Methods

This is a dataset of Order Management. And this is our sample dataset. Method 1 - Extracting Data from Excel Manually Select ...

Understanding the Excel Ribbon: A Complete Guide for Beginners

In the following image, you can see the Ribbon. The Home tab is selected: you can see the available features and commands. Click on image for ...

Excel Formula List (40+ Useful Formulas to Master Excel)

In the following image, you see some students with their marks in English. We have calculated the total marks, average marks, total no. of students, ...

Guide to How to Add, Use and Remove Filter in Excel

Method 1 - Add Filter in Excel Using Home Tab Select a random cell in the range or the whole range => navigate to the Home tab => Editing ...

Learn Excel

What Is the Importance of Using Microsoft Excel? Data Organization: Excel excels in organizing large datasets, making information easy to ...

How to Work with Rows Using VBA in Excel (Ultimate Guide)

For example, in the GIF below, you can see that we have selected the header row of our dataset. We have used the Rows property along with the Select ...

How to Compare in Excel? (10 Practical Examples)

In the following overview image, we have compared two different lists containing the available products in a store and ordered products. If the ...

VBA Cells in Excel: Select, Get, Count, Format, Copy-Paste, etc.

What Is VBA Cells Property? Cells property refers to a cell for any operation in VBA. It can access or modify cells based on row and column ...

Excel 30 Year Amortization Schedule Template [Free Download]

Download our free 30-Year Amortization Schedule Excel template to generate your own amortization schedule for a 30-year loan. Read the article ...

Excel Car Loan Amortization Schedule Template [Free Download]

This template will be helpful to bankers, business owners, job holders, financial planners, and all kinds of lenders and borrowers looking to take or ...

How to Use Fill Handle in Excel (All You Need to Know)

The Fill Handle tool is used to fill or extend data or series in Excel. It is a plus-sign cursor (+). For example, in the following GIF, we have ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo