Q&A

If you have an Excel question and don’t know how to solve it, why not ask us using the forum. We will love to solve it for you. We hope we could help you learn more about Excel by solving the problem for you.

Note: We will not publish and answer school assignments.

 

  • A new formula called TEXTJOIN (2/13/2018) - I was exploring how I could help one of my friends how to join text together that I stumble on this new formula called TEXTJOIN which was added a few months ago by Excel. With the formula, you are able to return multiple values in one single cell. More details can be found in this […]
  • Does the cell contain any of the items in the list (2/10/2018) - One of my friends got an excel list and he wishes to find out in this list whether any of words he has in a second list can be found in the first list. He came out with a formula which is extremely long and find that it is impossible to use the formulas if […]
  • Why you should not use VLOOKUP? (2/8/2018) - I was just pasting some data over from one worksheet to another in the same file. The destination worksheet contains a few thousand VLOOKUP formula. When I paste the data over, it takes quite a few minutes to complete the paste. This is because Excel keep re-calculating the VLOOKUP formulas as the data get pasted […]
  • Free Excel Course (1/1/2018) - If you are computer literate but do not know how to Excel, here is how you can get a Free and Excellent guide to get you started. Here is how you get it. 1. Open Excel or open a new workbook. 2. Click on the icon that says “Take a Tour” as shown in the […]
  • Excel Table (1/14/2016) - Excel Table is a new function in Excel. It can organize information neater compared to a normal Excel worksheets. But one thing Excel Table cannot do is insert cut cells from another row of the table. For example, I would like to swop the values between E5 and E6. The way I would do it is to cut […]
  • Paul McKenna: I chose my wife by Excel spreadsheet (1/4/2016) - This is not one of the Excel uses I would recommend but Paul definitely used it correctly to organize information and see things clearer. http://www.telegraph.co.uk/news/celebritynews/12078792/Paul-McKenna-chose-wife-Kate-Davey-by-Excel-spreadsheet.html
  • VBA Excel – Goto Function (12/30/2015) - In one of the projects that I was working on, I wrote a set of Macros VBA code to select and highlight the cells that I want to keep. It behaves the same way as when the GOTO function is applied manually. The following code is what I used to highlighted the filtered cells yellow: […]
  • A Sum formula that always adds new rows (7/9/2015) - What do you do if you have a list and you constantly have to add the new records to the grand total using the SUM formula? If your SUM formula is immediately below the record, you will have to keep changing your range as the SUM formula would not include the new row added before the […]
  • Microsoft Excel can be installed as a standalone Android App (6/26/2015) - Previously, you have to install Microsoft Office App (Excel, PowerPoint and Words) to use Excel. Now they come as separate Apps and you can pick the App you wish to install on your Andriod Phone. Watch the YouTube video for more details.  
  • Microsoft launched a new keyboard for Android Tablets (3/2/2015) - Microsoft launched a new keyboard for Android tablet. The new keyboard basically contains a keypad on the right. It is going to be helpful for those who are have to enter lots of numbers quickly on their tablets. So far, there is no mention of an iPhone or iPad version.  Microsoft Excel Android Keyboard
s2Member®