How to protect Word documents with a password
By password protecting a Word document, you’re encrypting important data to protect it from unauthorised access or unwanted changes. With this feature, your Microsoft Word or Office program file can only be opened if a valid password is entered. Find out how to password protect a…
Read more
What are the free Microsoft Word alternatives?
Microsoft Word is one of the best-known computer programs in the world. It’s likely that anyone who has ever written a document on a computer has used Word, and it is widely utilised by companies. However, one significant downside is its cost. The price can be prohibitive,…
Read more
How to add page numbers in Word
Adding page numbers makes documents more accessible and easier to reference. With the built-in feature for inserting page numbers in Microsoft Word, numbering pages is easy. In this article, we’ll explain how to insert page numbers in Word as well as different page numbering…
Read more
How do you round numbers in Excel?
With Excel, you can perform complex computations. However, sometimes you may want to simplify the results, either by rounding up or down. In Excel, you can round using a function, saving you time and effort. You can use the ROUND function in its simple form or build it into…
Read more
Excel LOOKUP formula: Commands and examples
Do you have a huge table where it’s difficult to keep track of all the entries? In Excel, you can use LOOKUP to quickly find values. You can think of this function as a mini search engine for your spreadsheet. Enter a search term and Excel will seek out the value for you. Here,…
Read more
Excel: Move columns and rows - A step-by-step-guide
Moving columns and rows in your Excel spreadsheet is effortless when you use the drag-and-drop function or keyboard shortcuts. In this article, we’ll show you how to move columns or rows in Excel as well as how to cut and paste them into a different location. That way, you can…
Read more
How to calculate the median in Excel
The median is the middle number in a set of numbers. It is also known as the central value. If you don’t want to measure the average, but instead are looking for the central value in a series of numbers, you can use Excel’s median function. The median function can be applied to…
Read more
WEEKNUM in Excel – How to use it
In business, you often need to know the calendar week number. Excel’s WEEKNUM function ensures that you always have the correct week number right at your fingertips. The function can even take different counting methods into account, allowing it to adapt to international…
Read more
How to split cells in Excel
If a cell contains several values, it often makes sense to split the Excel cell. Although the Microsoft spreadsheet program doesn’t offer a general feature for this, you can split the contents in the cell among multiple columns by configuring and using separators. In this…
Read more
How to create a histogram in Excel
A histogram shows the frequency of data, making this chart an important tool for statistics. With a bar graph format, histograms make it easy to identify which ranges of data have a high frequency and which ones don’t. Luckily, you don’t need to use any extra software, because…
Read more