Browse all of our latest posts here.
Microsoft Excel – Get current date and time
In this quick tutorial we will be going to add the current date and time as a cell within an Excel spreadsheet, the date and time will update each time a change to the spreadsheet is made or each time it is opened. To doContinue reading “Microsoft Excel – Get current date and time”
Microsoft Excel – Highlighting column differences
In todays post we will be highlighting any column differences within our Excel spreadsheet, to do this carry out the following steps: Start by highlighting the columns where you duplicate row values may exist. Within the ‘Home‘ tab click on ‘Find & Select button, withinContinue reading “Microsoft Excel – Highlighting column differences”
Microsoft Excel – Highlighting row differences
In todays post we will be highlighting any row differences within our Excel spreadsheet, to do this carry out the following steps: Start by highlighting the rows where you duplicate row values may exist. Within the ‘Home‘ tab click on ‘Find & Select button, withinContinue reading “Microsoft Excel – Highlighting row differences”
Microsoft Excel – Find and replace text
In todays post we will go through removing blank cells within a spreadsheet, to achieve this you will need to carry out the steps listed below: Start by highlighting the range of cells where the text you are wanting to replace may exist. Within theContinue reading “Microsoft Excel – Find and replace text”
Microsoft Excel – Highlighting cells less than
In todays post we will be highlighting cells with a value less than a given number, to do this carry out the following steps: Start by highlighting the range of cells where you are wanting test if the values are greater than a given value.Continue reading “Microsoft Excel – Highlighting cells less than”
Microsoft Excel – Highlighting cells greater than
In todays post we will be highlighting cells with a value greater than a given number, to do this carry out the following steps: Start by highlighting the range of cells where you are wanting test if the values are greater than a given value.Continue reading “Microsoft Excel – Highlighting cells greater than”
Microsoft Excel – Jumping to the last cell
In this tutorial we will be covering the process to jumping or going to the last populated cell, this is especially useful if you are working with a very large set of data. To do this carry out the following steps. Select any cell withinContinue reading “Microsoft Excel – Jumping to the last cell”
Microsoft Excel – Text to columns
Text to columns is useful feature in Microsoft Excel that allows that allows us to parse data in a single cell to many cells based on a defined delimiter. To do this carry out the following steps: Highlight the cell or column that you areContinue reading “Microsoft Excel – Text to columns”
Microsoft Excel – Highlighting cells with duplicate values
In todays post we will be highlighting cells with duplicate values, to do this carry out the following steps: Start by highlighting the range of cells where duplicates may exist. Within the ‘Home‘ tab click on ‘Conditional Formatting‘ button, within the dropdown click ‘Highlight CellsContinue reading “Microsoft Excel – Highlighting cells with duplicate values”
Microsoft Excel – Removing blank cells in a spreadsheet
In todays post we will go through removing blank cells within a spreadsheet, to achieve this you will need to carry out the steps listed below: Start by highlighting the range of cells where you are wanting to remove the blanks. Within the ‘Home‘ tabContinue reading “Microsoft Excel – Removing blank cells in a spreadsheet”