The default color of excel may not be pleasing to all users as some of them do not prefer high—contrast visuals. Therefore due to this, Excel is an added feature that enables its user to change the outlook of the Excel to dark mode. The process of transiting to dark mode is pretty simple as … Read more
Sorting data is an important data analysis practice. Through data sorting, one can quickly visualize and conclude the data. Therefore, this eases the process of finding any data from your excel document. Excel is responsive software as it allows its users to sort data with either number, date and times or color. In this article, … Read more
Welcome to yet another exciting tutorial on our excel series. In this post, we will swiftly discuss the quickest way to deduce the initial day of the month from an excel spreadsheet. As we know, excel is never in short supply of intrigues, so let's proceed! As already stated, only one function is being present … Read more
A quick way of changing dates in Excel into text strings without using any formula is making use of Notepad or other text editors. Unlike the Wizard, this particular one enables you to change and transform dates in Excel to texts using any format or approach of your choice. 1. While using your Worksheet, configure … Read more
As you are successfully conversant with the MONTH and EOMONTH Excel functions, you can decide to progress and make the visual display better. In doing this, the Excel conditional formatting for dates will be utilized. To further buttress on the examples given in the write-up above, you will be shown how to easily highlight cells … Read more
Two functions exist in Excel that can assist you in changing the names of months to numbers of months. They are the DATAVALUE and the MONTH function. The function of the DATAVALUE is changing a date saved as a text into a serial number which is recognizable by Microsoft Excel as a date. In comparison, … Read more
If you're looking for a way to change the present date to a text, all you need to know is to make use of the TEXT function in Excel together with the TODAY function, which returns the present date, e.g =TEXT(TODAY(), "dd-mmm-yyyy") The outcome of this operation will display 08-Mar-2015. If you would love to … Read more
It is easy to highlight duplicates in an excel worksheet using the same color by use of conditional formatting, additionally, we can use different colors for every highlight in the same column to make them easily noticeable while working on an excel worksheet. Below are the steps and how to highlight using different colors: 1. … Read more
Having the basic knowledge of excel formulas and functions is important for beginners in the journey of becoming good data analysts and or financial analysts in the future. Excel is used mostly for data processing, financial projections, financial analysis, data modeling, and presentations. Excel is an incredibly important Microsoft for the window for its features … Read more
It is quite easy to sort a full name column with the first name. However, sometimes you may want to sort the full name column by the last name. How could you sort the full name by last name in Excel? This article brings you some tricky ways to help you sort full names column … Read more