Email:      Pass:    Pass?
Featured Excel Content




Excel Tip
How to get the name of a worksheet in Excel using VBA and Macros and also how to store that name in a variable for later use. This is rather simple but there are a couple different ways to do it. First, we can reference the currently active worksheet and put Name after it: ActiveSheet.Name This gets us the name of the currently active sheet, which ...
Added: Jul 31, 2015
 
Excel Tip
Learn how to find the next empty cell in a range in Excel using VBA and Macros.  This method will skip any blanks that are between your data but not at the very end of it. Look at this example: We want the VBA to locate cell C7 and NOT cell C5. The VBA to do this is quite simple: Sub Find_Next_Empty_Row() 'selects the next empty row 'ignores blank ...
Added: Jul 30, 2015
 
Excel Tip
Ill show you how to see the cells used in a formula/function in Excel and also how to tell which cells are using that particular formula/function. This is a simple yet very helpful feature in Excel and it allows you to visually represent the relationship between the cells/formulas/functions in the worksheet. This is actually very easy to do, just ...
Added: Jul 29, 2015
 
Excel Tip
Ill show you how to use Excel to calculate the total time worked in a day minus lunch time or any breaks. This is actually quite simple once you know it, but too many people overcomplicate this. Here is our sample worksheet: (Dont forget to download the accompanying worksheet for this tutorial so you can follow along.) Formula to Calculate Time Wo ...
Added: Jul 28, 2015
 
Excel Tip
In this tutorial I am going to cover the difference between Absolute and Relative Cell References in Excel and show you how to use them and why they are so important. Relative Cell References Relative Cell references in a formula change as they are copied or filled down a spreadsheet. What this means is that the cell reference will update relative ...
Added: Jul 27, 2015
 
Excel Tip
In this tutorial I am going to introduce the idea of Named Cells. A Named Cell is a cell which you have given a custom name to. This cell can then be referred to by its new custom name within and Formula or Function. For example, I have a table of orders and at the bottom are my totals: I could use the cell references C12 and B12 calculate the aver ...
Added: Jul 24, 2015
 
Excel Tip
In this tutorial I am going to cover how to link cells together. This is a useful feature of Excel as you can link cells in an Excel Formula instead of typing in the values each time. Linking cells allows you to perform calculations based on the value of cells instead of typing in values. This means that you can copy Formulas over multiple cells an ...
Added: Jul 23, 2015
 
Excel Tip
In this tutorial I am going to introduce how to input, edit and manage excel formulas. To start entering a formula, you just select a cell and start typing with an equals sign first: Alternatively you can select the cell, then use the formula bar: When entering a Function into a formula make sure to use parenthesis/brackets to enclose the arguments ...
Added: Jul 22, 2015
 
Excel Tip
In this tutorial I will cover the basic concepts of Formulas and Functions in Excel. A formula is an expression which helps perform calculations (E.g. 2 + 1 + 5 + 4 = 12, E = MC2). Excel Formulas allow you to calculate the value of a cell based on a specified equation.  This can range from simple addition, subtraction etc. to the more complex such ...
Added: Jul 21, 2015
 
Excel Tip
Here, youll learn how to get the difference between two times in Excel. A common example of this is for when someone starts and finishes work. (Note that my version of Excel put the finish time in the 24 hour time format (military time) but that it is still just 5:45 PM.) Here we have a start and finish time and I want to see how much time has ela ...
Added: Jul 20, 2015
 
Subscribe for Free Excel tips & more!
E-mail: