We use timestamps when we want to track activities. It is a type of data type that determines the date and time. In our article below, we illustrate the different methods you can use to insert a timestamp when a cell changes in Excel Using a keyboard shortcut 1. Select the cell where you need […]
How to timestamp when a cell changes in Microsoft Excel Read More »
Run Time Error 9 VBA Subscript out of range is one of the most common errors. But it’s actually one of the most useful error messages. Excel uses this error to inform you that a cell, range, worksheet, or workbook that you have referenced does not exist. Therefore it’s out of range. In this article,
Run Time Error 9 VBA Subscript out of Range Read More »
Excel is a powerful spreadsheet program. Sometimes it throws error messages to help users understand why a certain action didn’t work as intended. In most cases, the errors are associated with functions but there are others that cut across all features. One of the most common errors in Excel is the #####. If you are
How To Solve the ##### Error in Excel Read More »
Excel is the most used spreadsheet software in the world. This means a lot of people like it and would prefer it over the others. However, even while using Excel you can face some errors. Some are easy to fix while others require complex solutions. Thus it’s most likely you have come across errors such
How to Solve Excel Errors? 15 Most Common Errors Read More »
Excel is getting more advanced every day. You can now insert real-time stock prices in Excel using the data types stocks option. By inserting stock prices in Excel you can easy analyze and come up with strategies to invest in the stock market. It supports all the major markets such as the NSE, NASDAQ, and
How to Insert Stock Prices in Excel Read More »
Are you an advanced Excel user? Find out by answering the following 10 Excel questions. They touch on various topics, from formulas, pivot tables, shortcuts, etc. Click “Quiz Start” to begin answering the questions. To answer the questions just tick on the correct answer and click on the next button to load more questions. The
Excel Quiz For Advanced Users Read More »
Excel is one of the most important tools when it comes to the financial world. This is due to its advanced features that help manage day-to-day finances for individuals and institutions. Recently, Microsoft Excel added a data card feature that allows users to import real-time currency exchange rates and stock prices. The data card not
How to Insert Exchange Rate in Excel Read More »
Accounting differs depending on locations, industries, and professions. In some areas, the appropriate way to display negative numbers is in brackets. However, Excel has its default way of displaying negative numbers which may not match your style. Luckily you can change or customize how to show negative numbers in an an Excel spreadsheet. In this
How to Display Negative Numbers in Brackets in Excel Read More »
Regardless of how you format the date, Excel stores it in one format in the backend. When you type dates using hyphens, dashes, or dots, Excel automatically converts them to slashes. This is a major setback especially if you want your date formats to have other delimiters as separators rather than slashes. In this article,
How to Change the Default Date Format in Excel Read More »
Planning your year or month helps boost productivity. The best place to get a free and easy-to-update calendar is from Excel. With Excel, you can create a monthly, weekly, quarterly, or yearly calendar. Besides, you can also decorate the calendar with different colors and fonts. Lastly, you can print it to hang on your wall
How to Create a Calendar in Excel 2024 Read More »
