Excel can use a function to lookup and retrieve data from a specific column or row within a table. Vlookup works to return back a column of data and Hlookup works to return a row of data instead, therefore the V stands for vertical lookup and the H, Horizontal lookup.
...Search results
Track changes can be used to lock a document. Any changes made to the document after it has been locked will feature in a list of 'tracked changes' that can be approved or denied. These are similar to comments but will update the original document if approved.
Turning on...
There are multiple ways of highlighting or removing duplicates from an Excel worksheet.
Conditional FormattingConditional formatting can be used to highlight duplicates ready for manual removal. This will use any formatting you select to overlay the data and show you any duplicates....
Page numbering happens in the headers or footer of the document, making use of section breaks to indicate where page numbering will and will not be present. This guide will focus on adding page numbers from the beginning but will cover their usage afterwards.
Adding Page numbersOn the...
When focused mailbox mode is enabled it will split your Inbox into two Tabs:
Focused & OtherHigh priority emails are directed to the Focused tab, whilst low priority emails like advertisements and generic newsletter items are directed to the "Other" Mailbox...
The following formatting options have no visibility unless the ¶ button is selected:
Styles can be quickly used to apply a formatting choice over a large area of a document. All text is initially created under the Normal style and will remain in this style unless Word is told otherwise. You can modify any existing style or create your own if there is not a pre-existing...
Cell references are used in almost all functions and they interact differently with the Auto-fill handle depending on what type of reference you have used:
The fill handle is shown when a cell is selected (by left clicking it), you will...
The fill handle can be used in a variety of ways that may save you time. From repeating sequences or repeating data to repeating a formula over a large area.
The fill handle is the name given to the green dot found on the bottom right corner of the selected...
Conditional formatting is a feature that has a variety of uses. Mainly surrounding different ways of displaying data corresponding to the value found within the cell or range of data. This can help you visualise the data faster...