How to use Excel

You can use Excel's Consolidate feature to consolidate your worksheets (located in one workbook or multiple workbooks) into one worksheet.

This guide walks you through the steps to sort by date in Excel. It starts with how to convert text-formatted dates to actual date values followed by basic sorting methods and advanced techniques like sorting dates by month and sorting birthdays.

The OFFSET function in Excel returns a cell or range of cells that is a specified number of rows and columns from a cell or range of cells.

Excel has 3 wildcards. A question mark (?) matches exactly one character. An asterisk (*) matches zero or more characters. And a tilde (~).

Use slicers in Excel to quickly and easily filter pivot tables. Connect multiple slicers to multiple pivot tables to create awesome reports.

The FREQUENCY function in Excel calculates how often values occur within the ranges you specify in a bin table. You can also use the COUNTIFS function to create a frequency distribution.

The scope of a variable in Excel VBA determines where that variable may be used. You determine the scope of a variable when you declare it. There are three scoping levels: procedure level module level and public module level.

You can pass arguments to a procedure (function or sub) by reference or by value. By default Excel VBA passes arguments by reference. As always we will use an easy example to make things more clear.

Below we will look at a program in Excel VBA that counts the number of year occurrences.

Use data validation in Excel to make sure that users enter certain values into a cell.