Author: Denise Elizabeth

Sometimes, calculating data such as days or dates without doing so manually can be necessary. Finding the last Monday of the month can be important if you need to know which date the latest Monday within a certain timeframe has occurred or will occur. In any case, finding the last Monday of the month with Excel is possible and a task which you can complete. Here’s How to Find the Last Monday of the Month in Excel: In this tutorial, I will show you a simple way to find the Last Monday of the Month in Excel. This method will…

In Excel, things like cells and cell ranges can be changed or altered to make them different from the rest of the worksheet. These options which are available in Excel can enable you to do things like change the color and style of a worksheet. While working, you might come to a point when you want to shade in different parts of the document to make values or data stand out.  Or perhaps you want to Shade or Highlight Every Other Row in Excel to make it easier to read and follow. As such, you will need an effective solution…

Today we are going to go over the different methods to easily remove parentheses (Brackets) in Excel.  While reading documents, articles, or write ups we consciously or unconsciously come across parentheses. They are the round brackets ( ) mostly used to separate a group of words from the rest of the sentence. Parentheses as a symbol, have different use cases in various fields. In mathematics, it is used to direct us on how to order our operations as well as to signify multiplication. In English languages, (according to the Cambridge dictionary) it is put around a word, phrase, or sentence…

There are different formats which can be applied to worksheets in Excel. These formats can allow you to change the way that values are expressed. For example, the Accounting Number Format in Excel. The accounting number format is commonly used to express monetary values. This special format is distinctive from similar formats as it lines up things like decimal points and symbols of currency – making numerical data easier to visualize. This format can be very useful if you have a lot of data in number form that you need to appear more orderly.  For instance, if you want to…

In this tutorial we are going to learn how to Enter Sequential Numbers in Excel. A sequence can be defined as a list of objects or items which have been arranged in a specified manner. This object can be alphabets, numbers, dates, a group of items, etc. A set of numbers can be said to be sequential if they progress following a specified pattern. This pattern can be ascending (upwards / incremental) or descending (downwards / decremental). Now let’s move to the business of the day! How can we enter numbers sequentially in excel? Do we have to manually type…

If you are looking for Simple Tricks to Reverse a Text String in Excel, than you’ve come to the right place. Text strings are commonly used in programs such as Excel and other programs which have spreadsheets. Working with cell strings is most likely a familiar task if you use Excel.  A cell string is a group of characters or text within a cell. Cell strings can be comprised of a combination of different types of characters – including letters and numbers. There are many ways that you can work with and structure cell strings and other contents and values…

Excel has incorporated, some trigonometric capabilities that can help you effortlessly calculate the cosine, sine, or tangent of angles. You would agree with me that solving trigonometric problems requires detailed attention. More important is ensuring that the right unit of measurement is used during calculation and when displaying results. Should the reverse be the case (having the wrong unit of measurement), it invalidates the correctness of your calculation. Generally, there are three units of measure for angles and they are: Degrees Radian Revolution The default unit of measure in Excel for trigonometric problems is the Radians and it is important…

If a guest list containing 20,000 Professors was handed over to you with an instruction to add the title ‘Prof’ before their names and their occupation ‘Engr’ after their names, how will you carry out this assignment?  Do you belong to the class of persons who will manually input the ‘Prof’ and ‘Engr’ row by row? Adding text to the beginning or/and end of a range of cells value in excel is a very common task. Unfortunately, many are unaware that they do not necessarily have to manually carry out this action. Excel provides some easy methods in which you…

Dividing a spreadsheet in Excel into panes can make it easier to do certain tasks. While panes can be useful and helpful in some cases, there may come a point when they are no longer needed. This is where you will need to find a way to remove panes from your spreadsheet. How to Remove Panes in Excel: Removing the panes from a spreadsheet can be a very simple process. You will find that the methods in this tutorial are super simple, quick and offer convenience if you want to remove panes quickly. To start, let’s explore the first technique:…

At some point, it may become necessary to add up a large amount of data within a short amount of time. This is where getting the sum of values in Excel could become critical. While summing positive numbers up can be done manually, it can be done a lot quicker and more efficiently in Excel. Here are Easy ways to Sum (or ADD) Positive Numbers/Values in Excel: There happen to be a few effective methods that can be used to add up positive values in Excel. Here, we will work through a couple of techniques that can be effective for…

Working with data that needs to be calculated can be time consuming and complicated. Adding a total row can be useful if you have columns of numerical values or amounts which you would like to have added together. As such, adding a total row to a table in Excel can allow you to have your data totaled fast without a lot of effort. A total row can also make your work quicker and more efficient – saving you time in the process. How to Add a Total Row to an Excel Table: There are multiple ways that you can go…

In Excel, rows and columns have headings. The headings for columns appear as a letter above each column, while the headings for rows appear as a number to the left of each row. Although you might see numbers next to rows on the screen, Excel will not print out row numbers automatically. Yet, you may want to have these numbers printed in order to easily identify information and data within your spreadsheet. As a result, you will have to make some adjustments if you desire to have the numbers print along with the rows. Simple Tutorial to Print Row Numbers…

One of the ways we secure ourselves at home is by locking our doors. The level of protection employed by individuals may vary from person to person. While occupants of fenced apartments may decide to lock their entrance gates, others without a perimeter fence would simply lock up their entrance doors. This scenario is also applicable in excel. To restrict access/entry in excel, a lock action is carried out. This means the locked cell, column, and/or worksheet cannot be reformatted, deleted, or its content edited.    In this tutorial, we will learn how to carry out the ‘lock’ activity in excel.…

There are many problems that could manifest in Excel while you’re working on a task. A common problem that many people come across when using this program is the appearance of leading zeros. Leading zeros are zeros that appear immediately in front of the value (or multiple values) of a cell. Zeros can appear when issues with formatting arise – particularly if a numerical value is being formatted as text or cell formatting dictates that a certain amount of digits be shown. When they’re unwanted, leading zeros can cause a variety of issues to arise and can make getting things…

Dotted lines are known to appear in Excel from time to time due to a number of causes. For example, they can appear when dotted borders are placed around the cells or when the spreadsheet is indicating that there is a page break. Lines can also be the result of having parts of the spreadsheet being set as ‘Print Areas’ or the sheet being put into print view. Dotted lines can appear when border settings have been changed to show as dotted or they could simply even be gridlines that only appear to be dotted lines. Whatever the cause, dotted lines…