Best Excel Tutorial

The largest Excel knowledge base ✅ The best place to learn Excel online ❤️

horizontal line data set table

How to Make a Progress Chart in Excel

A progress chart in Microsoft Excel is a visual representation of progress towards a goal or target. It can be used to track the progress of a project, the completion of tasks, or the attainment of a certain target.  In this Excel charting tutorial you will learn how to make a progress chart. Inserting a progress chart has multiple reasons.

Read More

AutoCorrect Turning Off Checkboxes

How to Stop Excel from Changing Numbers to Dates

Excel has autocorrect data input turned on by default. After pasting the number into the cell, it is automatically replaced with the date. If the Excel number has a similar length as the date, it will go crazy and change the number to a date.

This changes the contents of the cell. A strange date appears instead of a number. These are often dates from hundreds of years ago or from the future.

Read More

Power Query download

How to use Power Query in Excel

Power Query is a powerful data connectivity and data transformation tool that is available in Microsoft Excel. It allows you to connect to a wide range of data sources, such as spreadsheets, databases, and cloud services, and to easily manipulate, shape, and transform the data to meet your needs.

You learn to install and use Power Query in Excel.

Read More