Remove Leading Space from Multiple Rows (Excel 2013)
Learn how to remove leading space from multiple rows in Excel without using any formulas!
Remove Leading Space from Multiple Rows (Excel 2013) Read MoreExcel
The Trick to Inserting an Image in a Specific Cell without the Need for Macro (Excel 2013)
Learn this interesting trick to insert an image into a specific cell in Excel without using any formulas!
The Trick to Inserting an Image in a Specific Cell without the Need for Macro (Excel 2013) Read More
6 Types of Hyperlink You Can Create in Excel (Excel 2013)
Creating hyperlinks in Excel can be beneficial in terms of helping you to navigate better, i.e. jumping from one worksheet or cell to another, or opening an external file that …
6 Types of Hyperlink You Can Create in Excel (Excel 2013) Read More
Create Table of Contents in Excel File (Excel 2013)
There are times where your spreadsheet will expand and have several worksheets within the same spreadsheet file. Normally, you would click the worksheet tabs (or next / previous arrow buttons) …
Create Table of Contents in Excel File (Excel 2013) Read More
Merge Multiple Cells at Once (Vertically / Horizontally) with Format Painter (Excel 2013)
Merging multiple cells across rows and columns is a fairly straightforward task. Simply choose the number of cells that you wish to merge, then click the Merge Cells button. Easy …
Merge Multiple Cells at Once (Vertically / Horizontally) with Format Painter (Excel 2013) Read More
Capitalise All Letters in a Row or Column (Excel 2013)
It is so easy to capitalise all the letters in a sentence or paragraph in Word (and vice versa), but it isn’t exactly straightforward to do the same in Excel. …
Capitalise All Letters in a Row or Column (Excel 2013) Read More
Highlight Cell Based On Specific Word or Value with Find and Replace Function (Excel 2013)
It’s very easy to search for words or values (and replace them) in any excel-generated report by using the Find and Replace function. Do you also know that you can …
Highlight Cell Based On Specific Word or Value with Find and Replace Function (Excel 2013) Read More
Top 4 Basic Formulas You Should Know (Excel 2010)
There are just so many formulas in Excel that you could use to your advantage, especially when your report involves a fair bit of calculation or requires a certain amount …
Top 4 Basic Formulas You Should Know (Excel 2010) Read MoreSimple Conditional Formatting (Excel 2010)
Conditional formatting in Excel has many useful purposes. I normally use it to alert or warn me if a certain condition is met (or otherwise). Let me get started on …
Simple Conditional Formatting (Excel 2010) Read More
Change the Values in a Drop-down List (Excel 2010)
This simple tutorial will show you how easy it is to change the values in a drop-down list. 1. Click on the cell that contains the list of values, and …
Change the Values in a Drop-down List (Excel 2010) Read More