When you have a big chunk of data, it may become tedious to sum up, every monthly, weekly, or even yearly total one by one. Excel has several ways to do this without so much hassle. Here are some of the ways you can sum in per month, week, or day in excel easily. Sum […]
How to sum in per month, week, or day in Excel Read More »
While using excel, you need to learn how to present data in your spreadsheets. One of these important skills is inserting, editing, and removing borders in excel. The borders are important so you can separate information like headers and total rows from the rest of the table. Therefore, it is important that you know how
How to insert, edit or remove outside border in Excel Read More »
Sometimes you may wish to keep a part of an Excel worksheet stick on top while you are working or scrolling through your worksheet. To do this, you will need to freeze the area so that it remains locked and constant when you are scrolling through your workbook. This is an easier task to achieve
How to keep one row in Excel on top Read More »
You can easily look up a value in a table using one criterion. Here you will apply the VLOOKUP formula. But at times, you may need to use more than one criterion. This may seem like a pretty hard thing to achieve in Excel but it is not the case. Excel offers several functions you
How to LOOKUP Value in Excel with Multiple Criteria – 6 Methods Read More »
Microsoft Excel is one of the most reliable spreadsheet programs when it comes to dealing with data. You can perform a lot of mathematical computations using the different functions in Excel. One of the functions Excel offers is the DATE function, where you can calculate the additions and differences between dates. You can minus or
How to minus dates in Excel-3 easy methods Read More »
When you round up a number, you remove the non-important values. In Excel, you can round your figures to the nearest tens, hundreds, or thousands when you do not need an exact figure. This is one of the useful skills any Excel user should know. Luckily, Microsoft Excel offers many functions that help handle the
How to round in Excel the nearest thousand Read More »
After working on Excel worksheets, you may need to print out your workbook. Printing comes with different editing features. You can specify custom margins, change margins, or even center your worksheet to be printed vertically or horizontally. Excel also offers users printing features that enable them to print workbooks in the middle of the page.
3 easy ways to print Excel in the middle of a page Read More »
Inserting location in Excel enables you to find a specific file when you want to use it. It is easier to trace and access your Excel file once you have inserted a location in it. You do not have to enter the location manually. It is easy to insert a location in Excel. Despite the
How to insert location in Excel (3 easy ways) Read More »
Sometimes, when working with Excel documents, you may need to keep a spreadsheet section visible as you scroll through the rest of the worksheet. It is especially handy when you are working with a large Excel worksheet. Keeping a row or column locked makes your work easier as you can view the contents of the
How to freeze panes in Excel top and side Read More »
Excel’s MID Function is categorized under Excel TEXT Functions. The MID Formula returns a specified value of characters from the middle of a given text string. The function requires three arguments which include: the n numbers of characters to return, text to extract from the original text string, and a start point. Generally, you can
How to FIND MID in Excel Read More »
