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 average non-contiguous cells (cells that aren't next to each other) if those cells contain numbers and are greater than 0. The regular AVERAGEIF() function will not work in this case; try it if you don't believe me! Average Non-Contiguous Cells that are Greater than 0 This assumes that you have some cells around your spreadsheet that are no ...
Added: Jul 22, 2016
 
Excel Tip
How to pass variables and values to macros. This allows you to get a result from one macro and use it in another macro, whether that result is text, numbers, a cell reference, or whatever you need. This tutorial focuses on the case when you call one macro from another macro. Sections: Create the Macro that Gets the Value Call/Reference the Macro t ...
Added: Jul 21, 2016
 
Excel Tip
Perform a lookup on dates and times in Excel: vlookup, hlookup, index/match, any kind of lookup. This tutorial shows you how to accurately use a lookup function on dates/times. This is important because time can be very tricky in Excel and sometimes you get positive results mixed-in with hidden negative results. The VLOOKUP() function will be used ...
Added: Jul 19, 2016
 
Excel Tip
How to prevent a user from closing an Excel workbook. The user won't know what to do! This is a great little prank that will leave your co-worker confused and annoyed. Use with caution ;) To make this work, you will have to install a small macro and make sure the workbook has macros enabled by default. Hit Alt + F11 to go to the VBA Editor. Double ...
Added: Jul 18, 2016
 
Excel Tip
How to run a macro when a user does something within the Workbook in Excel, such as opening a workbook, closing a workbook, and other activities that are not specific to a single worksheet. As such, this tutorial differs from the Run a Macro when a User Does Something in the Worksheet in Excel tutorial. In Excel, you can set macros to run when cer ...
Added: Jul 15, 2016
 
Excel Tip
IF statements allow you to make decisions in your Macros and VBA in Excel. An IF statement gives you the power to do different things in a macro depending on the outcome of a test or a condition, as it's called. This is probably the most important thing you will learn when it comes to creating a macro and programming in general. Below, I'll go ove ...
Added: Jul 14, 2016
 
Excel Tip
List all conditional formatting formulas in a worksheet in Excel. This allows you to quickly view and manage all of the formulas that you use for your conditional formatting rules. It will get the conditional formatting rules for the entire workbook and put them on their own new worksheet at the end of the workbook. Macro to List Conditional Format ...
Added: Jul 13, 2016
 
Excel Tip
Logical operators in VBA allow you to make decisions when certain conditions are met. They allow you to check if something equals this OR that; this AND that; NOT this; and combinations of all three. When used in conjunction with IF statements, they allows you to make more complex choices in your macros and VBA. Logical Operators OperatorMeaningAN ...
Added: Jul 12, 2016
 
Excel Tip
Macro to get data from a workbook, closed or open, over a network or locally on your computer. This is a versatile and self-contained macro that opens another workbook, gets information from it, and then closes that other workbook. This happens so fast that you won't even notice what is happening; it should feel seamless. (This technique will also ...
Added: Jul 11, 2016
 
Excel Tip
How to put comments into a macro so that it's easier to understand and maintain them. Comments allow you to make notes within your macro and VBA code. These notes do not affect the execution of the macro at all and, when the macro is run, Excel pretends that the comments aren't even there. Sections: How to Make Comments in Macros When should you U ...
Added: Jul 6, 2016
 
Subscribe for Free Excel tips & more!
E-mail: