In many databases names may show up as last name, first name which doesn't make it ideal for sorting and filtering data easily. However this can be quickly rearranged in Excel. I'll show you two ways to do this: 1) using text to columns (the easier m ...
This post will show you how to create the effect of highlighting alternating rows, which sometimes makes it easier to read a data set.In order to accomplish this, first select all the cells in the worksheet and then select New Rule under conditional ...
If you come across a custom function or macro that you want to use in your spreadsheets, this post will show you how to do so.As far as coding goes, they key difference in a function as opposed to a sub procedure in Excel is in the way the code is ex ...
When working with multiple worksheets or tabs, it becomes useful to reference them in formulas or to consolidate data. First, I’ll look at working with different tabs.Referencing Other TabsThe easiest way to refer to a cell in another tab is to start ...
Naming ranges offers an easy way to refer to a single cell or range without having to remember the address, and instead referring to it by name instead. This comes particularly useful if you will continually be referring to that cell. The key ...
An overview of how various IF functions workIF FunctionAn if function creates a test, and can have different results depending on whether the test is true or false.Example 1 =IF(A1="A",1,0)In this example, if A1 is equal to the letter A then the ...
If you do a lot of repetitive tasks (and even if you don't), macros can help save lots of time. In some cases you can be talking hours worth of work in one macro.Recording a MacroNow, if you're not familiar with macros or VBA at all, a good way to le ...
For Excel 2007 and newer:Select the data you want to extract unique values from, and under the Data tab, click on Remove Duplicates.If the column you select is alongside other data, it will remove those cells as well. If that's not what you want ...
Lookups are popular in Excel and here I'll look at the more popular one - VLOOKUP. However it's not always the best option for doing lookups in Excel, and I'll show you why.VLOOKUPExact MatchesWhat Vlookup does is look for a value you have selected, ...
