Site Information and Updates

Early Forum Access Starts Today!

Finally, the forum is ready to be opened up to you beta testers!

Almost 300 of you signed up for early access to the forum and created an account.

Guidelines

  • Don’t post “test” questions or answers; ask real questions and give real answers.
  • Once you get answers to your question, select the best one by clicking the Select button under it. This is a very important feature of the forum and what you do now sets an example for those who will come after you.
  • Stay on topic – only ask questions about Excel. (the forum may expand later but, for now, it’s only for Excel)
  • If you have questions, comments, or thoughts about the forum, how to use it, or anything not Excel specific, please post that in a comment on this post or in theMembers Discussion Forum.
    • If you post an Excel question in the Members Discussion forum, a Goblin will probably eat you or ban you for being annoying.

Access the Forum

To access the Excel Forum, login to your account on teachexcel.com and click the Forum link in the top navigation menu.

Here is a link to the Excel Forum

The Excel Forum will ONLY be accessible to you if you signed up for a beta testing account AND you have an account on teachexcel.com. If you failed to do one of those things, you will have to wait until the forum is open to the general public in order to access it.

Read the full blog post.

posted: June 28, 2016


Featured Excel Content



Excel Tip
How to check if a cell is empty or is not empty in Excel; this tutorial shows you a couple different ways to do this. Sections: Check if a Cell is Empty or Not - Method 1 Check if a Cell is Empty or Not - Method 2 Notes Check if a Cell is Empty or Not - Method 1 Use the ISBLANK() function. =ISBLANK(A1) This will return TRUE if the cell is empty or ...
Added: Aug 29, 2016
 
Excel Tip
How to use a single formula to apply conditional formatting to multiple cells at once in Excel. This saves you the time of changing a formula for each cell and then individually adding the conditional formatting to it. Steps Create the formula that you want to use within the worksheet so that you can make sure that it is working. Remember that a fo ...
Added: Aug 25, 2016
 
Excel Tip
Change or replace text in a cell with other text - you can replace a single character, numbers, letters, etc. This allows you to do things like replace all dashes with spaces, or vice versa, replace a word or a number in a cell, and even to replace all instances or a word, number, or character in a cell or a list of cells. To do this, we use the SU ...
Added: Aug 24, 2016
 
Excel Tip
Round each number to a specific decimal number. This works for numbers that don't already have a decimal and ones that do have a decimal. To do this, we will use the TRUNC() function in Excel. =TRUNC(A1)+.49 A1 is the cell that has the number that we want to "round" and .49 is the decimal that we want the number to have. In Excel it looks like this ...
Added: Aug 22, 2016
 
Excel Tip
How to find the last row of data using a Macro/VBA in Excel, including getting the number of that row and any data from that row. This tutorial shows you the small line of code that will get you the actual row number for the last row of data in Excel and also, if you want, the data from that row. Sections: Get the Last Row Number Select the Last R ...
Added: Aug 19, 2016
 
Excel Tip
How to use a formula to get the first word from a cell in Excel. This works for a single cell and an entire list or data set. Sections: Get the First Word in the Cell Non-Space Separators More Versatile Formula - Works when Only 1 Word is in a Cell or it is Empty Notes Get the First Word in the Cell To do this, we use the LEFT() and FIND() function ...
Added: Aug 17, 2016
 
Excel Tip
How to prevent errors from appearing in formulas in Excel. This is especially helpful for the Vlookup function. Sections: Excel 2007 and Later Excel 2003 and Earlier Notes Excel 2007 and Later This is very easy to do in Excel 2007 and later using the IFERROR() function. Syntax =IFERROR(value, value_if_error) The value is the function or formula tha ...
Added: Aug 16, 2016
 
Excel Tip
How to input any length number in Excel and have it remain visible. Excel truncates any number longer than 15 characters in length. This means that any number longer than that will have everything after 15 turned into zeros. If you type: 1234567890123456789 Excel will change that to: 1234567890123450000 To keep your long number, type a single quot ...
Added: Aug 15, 2016
 
Excel Tip
How to get a column letter from a number in Excel using a simple formula. This is an important thing to be able to do when working with complex formulas in Excel, especially the INDIRECT() function. Sections: Basic Formula - Works for A to Z More Complex Formula - Works For All Columns Notes Basic Formula - Works for A to Z The formula: =CHAR(64+A ...
Added: Aug 10, 2016
 
Excel Tip
Return Vlookup results on partial matches of a cell's contents. You could type the start, end, or middle of a lookup value and still return a result. I assume that you are already familiar with Vlookup, if you aren't, then checkout our tutorials on lookup functions in Excel. Sections: Vlookup Match the Start of a Cell Vlookup Match the End of a Cel ...
Added: Aug 9, 2016
 
Subscribe for Free Excel tips & more!
E-mail: