Advanced Excel

How to Get Unique Values in Excel (5 Easy Ways)

If you are looking for how to get unique values in Excel, then you are in the right place. Duplication of values in Excel can occur in a single ...

How to Convert Text to Columns in Excel (3 Cases)

Excel's Text to Columns Wizard is a very important feature with many uses. In this article, I will teach you how to convert text to columns in Excel. ...

How to Enter Date and Time in Excel (8 Quick Methods)

It is very helpful to insert the date and time in an Excel spreadsheet for the person who works as a financial accountant. We can add the date & ...

How to Make Negative Numbers Red in Excel (4 Easy Ways)

Sometimes, it is important to mark cells in Excel that have some specific values. Most often, users need to differently mark negative and positive ...

How to Format Excel to Print (13 Simple Tips)

In this article, you will learn how to format an Excel spreadsheet to print. I’m sure these tips will help print your data more professionally. You ...

How to Extract Data from Website to Excel Automatically

Extracting data (data collection and update) automatically from a web page to your Excel worksheet might be important for some jobs. Excel gives you ...

How to Import Data from Website to Excel with VBA Code

The key advantage of importing data from a website to Excel is the ability to routinely evaluate data in Microsoft Office Excel without having to ...

How to Create a Database in Excel (with Easy Steps)

Don’t know how to create a simple database in Excel? In this article, we will show you how you can make a database in Excel in just 7 simple steps. ...

How to Import Data from Word to Excel (3 Easy Methods)

Often while working with Excel, we need to import data from different sources. These sources may include Word files which is another commonly used ...

22 Limitations of Excel That Might Frustrate You

Excel is obviously one of the most important products in the world. It is very helpful in managing, analyzing data. But there is also something that ...

How to Insert Equation in Excel (3 Easy Ways)

In this article, you will learn how to insert an equation in Excel. If you do mathematics-related reports or assignments with Excel, you have to know ...

How to Do Forecasting on Excel (4 Easy Ways)

This article aims to show you four methods you can use to forecast in Excel. If you own or operate a business, this is a common scenario where you ...

How to Make FOR Loop in Excel Using Formula (3 Examples)

Don’t you want to use Excel VBA and want to make a FOR Loop in Excel using Formula? In this article, I’ve shown how you can make FOR Loop using ...

Essential Excel Skills That Will Make You an Excel Expert

Whether you’re just starting out on your Excel journey or have been using it for a while, there are a few essential skills you should know about ...

Conditional Formatting with Formula in Excel (21 Examples)

In this Excel tutorial, you will learn how to use conditional formatting with formulas in Excel with examples. Conditional formatting helps us ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo