List of Excel Solutions

Tutorials

Find the answer you are looking for in our Excel or VBA tutorials.

Title	Solution Type	Title and Solution Type
HOW TO INTERFACE Hide the Formula Bar How to hide the Formula Bar
HOW TO INTERFACE Show the Formula Bar How to show the Formula Bar
HOW TO INTERFACE Expand the Formula Bar How to expand the Formula Bar
HOW TO INTERFACE Collapse the Formula Bar How to collapse the Formula Bar
HOW TO INTERFACE Hide formula in the Formula Bar How to hide a formula in the Formula Bar using Excel
HOW TO INTERFACE Hide row and column headings in a worksheet How to hide row and column headings in a worksheet using Excel and VBA methods
HOW TO INTERFACE Show row and column headings in a worksheet How to show row and column headings in a worksheet using Excel and VBA methods
HOW TO INTERFACE Hide row and column headings in multiple worksheets How to hide row and column headings in multiple worksheets using Excel and VBA methods
HOW TO INTERFACE Show row and column headings in multiple worksheets How to show row and column headings in multiple worksheets using Excel and VBA methods
HOW TO INTERFACE Hide row and column headings in a workbook How to hide row and column headings in a workbook using Excel and VBA methods
HOW TO INTERFACE Show row and column headings in a workbook How to show row and column headings in a workbook using Excel and VBA methods
HOW TO INTERFACE Hide gridlines in a worksheet How to hide gridlines in a worksheet using Excel and VBA methods
HOW TO INTERFACE Show gridlines in a worksheet How to show gridlines in a worksheet using Excel and VBA methods
HOW TO INTERFACE Hide gridlines in multiple worksheets How to hide gridlines in multiple worksheets using Excel and VBA methods
HOW TO INTERFACE Show gridlines in multiple worksheets How to show gridlines in multiple worksheets using Excel and VBA methods
HOW TO INTERFACE Hide gridlines in a workbook How to hide gridlines in a workbook using Excel and VBA methods
HOW TO INTERFACE Show gridlines in a workbook How to show gridlines in a workbook using Excel and VBA methods
HOW TO INTERFACE Change caption in the Title Bar How to change the caption in the Title Bar using VBA
HOW TO INTERFACE Clear caption in the Title Bar How to clear the caption in the Title Bar using VBA
HOW TO INTERFACE Display the current date and time in the Title Bar How to display the current date and time in the Title Bar using VBA
HOW TO INTERFACE Display the current date and time in the Title Bar when opening a workbook How to display the current date and time in the Title Bar when opening a workbook using VBA
HOW TO INTERFACE Display the current date and time in the Title Bar when a workbook was last saved How to display the current date and time in the Title Bar when a workbook was last saved using VBA
HOW TO INTERFACE Open Ribbon customization menu How to access the Customize the Ribbon menu using Excel
HOW TO INTERFACE Insert new tabs to the Ribbon How to insert new tabs to the Ribbon using Excel
HOW TO INTERFACE Remove tabs from a Ribbon How to remove tabs from the Ribbon using Excel
HOW TO INTERFACE Hide tabs in the Ribbon How to hide tabs in the Ribbon using Excel
HOW TO INTERFACE Show tabs in the Ribbon How to show tabs in the Ribbon using Excel
HOW TO INTERFACE Create a new group in the Ribbon How to create a new group in the Ribbon using Excel
HOW TO INTERFACE Remove a group from the Ribbon How to remove a group from the Ribbon using Excel
HOW TO INTERFACE Add the Developer tab How to add the Developer tab to an Excel Ribbon
HOW TO SHEETS and WORKBOOKS Create a new Excel workbook How to create a new excel file (workbook) using Excel, VBA and Shortcut methods
HOW TO SHEETS and WORKBOOKS Create and Save a new workbook How to create and save a new workbook using VBA
HOW TO SHEETS and WORKBOOKS Open an Excel workbook How to open a single workbook using Excel, VBA and Shortcut methods
HOW TO SHEETS and WORKBOOKS Open a specific Word document How to open a specific Word document using VBA
HOW TO SHEETS and WORKBOOKS Open a specific PDF file How to open a specific PDF file using VBA
HOW TO SHEETS and WORKBOOKS Open all Excel files in a folder How to open all excel files in a specific folder at once using VBA
HOW TO SHEETS and WORKBOOKS Open an Excel workbook that was recently used How to open a workbook that was recently used and closed using Excel and Shortcut methods
HOW TO SHEETS and WORKBOOKS Open an Excel workbook as Read-Only How to open a single workbook as Read-Only using Excel and VBA methods
HOW TO SHEETS and WORKBOOKS Open an Excel workbook in Protected View How to open a single workbook in Protected View using Excel and VBA methods
HOW TO SHEETS and WORKBOOKS Close an Excel workbook How to close a single workbook using Excel, VBA and Shortcut methods
HOW TO SHEETS and WORKBOOKS Close all Excel workbooks except the active workbook How to close all open excel workbooks except the active workbook at once
HOW TO SHEETS and WORKBOOKS Save an Excel workbook How to save a workbook using Excel, VBA and Shortcut methods
HOW TO SHEETS and WORKBOOKS Save all open Excel workbooks How to save all open excel files at once
HOW TO SHEETS and WORKBOOKS Save Excel workbook in multiple locations How to save an Excel file in multiple locations at once
HOW TO SHEETS and WORKBOOKS Save Excel workbook without being prompted How to save an Excel workbook without being prompted using VBA
HOW TO SHEETS and WORKBOOKS Save and close an Excel workbook How to save and close a workbook using VBA
HOW TO SHEETS and WORKBOOKS Insert an Excel worksheet How to insert a single Excel worksheet using Excel, VBA and Shortcut methods
HOW TO SHEETS and WORKBOOKS Insert multiple Excel worksheets How to insert multiple Excel worksheets at the same time using Excel, VBA and Shortcut methods
HOW TO SHEETS and WORKBOOKS Insert an Excel worksheet as the first sheet How to insert a single Excel worksheet as the first sheet using Excel, VBA and Shortcut methods
HOW TO SHEETS and WORKBOOKS Insert an Excel worksheet as the last sheet How to insert a single Excel worksheet as the last sheet using Excel and VBA methods
HOW TO SHEETS and WORKBOOKS Insert an Excel worksheet after a specific sheet How to insert a single Excel worksheet after a specific sheet using using Excel, VBA and Shortcut methods
HOW TO SHEETS and WORKBOOKS Insert an Excel worksheet before a specific sheet How to insert a single Excel worksheet before a specific sheet using Excel, VBA and Shortcut methods
HOW TO SHEETS and WORKBOOKS Insert an Excel worksheet before the last sheet How to insert a single Excel worksheet before the last sheet using Excel, VBA and Shortcut methods
HOW TO SHEETS and WORKBOOKS Insert an Excel worksheet after the first sheet How to insert a single Excel worksheet after the first sheet using Excel, VBA and Shortcut methods
HOW TO SHEETS and WORKBOOKS Insert an Excel worksheet in another workbook How to insert a single Excel worksheet in another open or closed workbook using VBA
HOW TO SHEETS and WORKBOOKS Insert multiple Excel worksheets in another workbook How to insert multiple Excel worksheets in another open or closed workbook using VBA
HOW TO SHEETS and WORKBOOKS Insert an Excel worksheet in multiple workbooks How to insert a single Excel worksheet in multiple open or closed workbooks using VBA
HOW TO SHEETS and WORKBOOKS Insert multiple Excel worksheets after a specific sheet How to insert multiple Excel worksheets after a specific sheet using Excel, VBA and Shortcut methods
HOW TO SHEETS and WORKBOOKS Insert multiple Excel worksheets before a specific sheet How to insert multiple Excel worksheets before a specific sheet using Excel, VBA and Shortcut methods
HOW TO SHEETS and WORKBOOKS Insert an Excel chart sheet How to insert a single Excel chart sheet using Excel, VBA and Shortcut methods
HOW TO SHEETS and WORKBOOKS Insert multiple Excel chart sheets How to insert multiple Excel chart sheets at the same time using Excel, VBA and Shortcut methods
HOW TO SHEETS and WORKBOOKS Insert an Excel chart sheet as the first sheet How to insert a single Excel chart sheet as the first sheet using Excel, VBA and Shortcut methods
HOW TO SHEETS and WORKBOOKS Insert an Excel chart sheet after a specific sheet How to insert a single Excel chart sheet after a specific sheet using Excel, VBA and Shortcut methods
HOW TO SHEETS and WORKBOOKS Insert an Excel chart sheet before a specific sheet How to insert a single Excel chart sheet before a specific sheet using Excel, VBA and Shortcut methods
HOW TO SHEETS and WORKBOOKS Insert an Excel chart sheet before the last sheet How to insert a single Excel chart sheet before the last sheet using Excel, VBA and Shortcut methods
HOW TO SHEETS and WORKBOOKS Insert an Excel chart sheet after the first sheet How to insert a single Excel chart sheet after the first sheet using Excel, VBA and Shortcut methods
HOW TO SHEETS and WORKBOOKS Insert an Excel chart sheet in another workbook How to insert a single Excel chart sheet in another open or closed workbook using VBA
HOW TO SHEETS and WORKBOOKS Insert multiple Excel chart sheets in another workbook How to insert multiple Excel chart sheets in another open or closed workbook using VBA
HOW TO SHEETS and WORKBOOKS Insert an Excel chart sheet in multiple workbooks How to insert a single Excel chart sheet in multiple open or closed workbooks using VBA
HOW TO SHEETS and WORKBOOKS Rename an Excel worksheet How to rename a single Excel worksheet using Excel, VBA and Shortcut methods
HOW TO SHEETS and WORKBOOKS Rename an active Excel worksheet How to rename an active Excel worksheet using VBA and Shortcut methods
HOW TO SHEETS and WORKBOOKS Rename multiple Excel worksheets How to rename multiple Excel worksheets using VBA
HOW TO SHEETS and WORKBOOKS Rename an Excel worksheet in another workbook How to rename a single Excel worksheet in another open or closed workbook using VBA
HOW TO SHEETS and WORKBOOKS Delete an Excel worksheet How to delete a single Excel worksheet using Excel, VBA and Shortcut methods
HOW TO SHEETS and WORKBOOKS Delete an active Excel worksheet How to delete an active Excel worksheet using VBA and Shortcut methods
HOW TO SHEETS and WORKBOOKS Delete an Excel worksheet without a warning message How to delete an Excel worksheet without a warning message using VBA
HOW TO SHEETS and WORKBOOKS Delete multiple Excel worksheets How to delete multiple Excel worksheets using Excel, VBA and Shortcut methods
HOW TO SHEETS and WORKBOOKS Delete an Excel worksheet in another workbook How to delete a single Excel worksheet in another open or closed workbook using VBA
HOW TO SHEETS and WORKBOOKS Color an Excel worksheet tab How to color a single Excel worksheet tab using Excel and VBA methods
HOW TO SHEETS and WORKBOOKS Color an active Excel worksheet tab How to color an active Excel worksheet tab using VBA
HOW TO SHEETS and WORKBOOKS Color multiple Excel worksheet tabs How to color multiple Excel worksheet tabs using Excel and VBA methods
HOW TO SHEETS and WORKBOOKS Color an Excel worksheet tab in another workbook How to color a single Excel worksheet tab in another open or closed workbook using VBA
HOW TO SHEETS and WORKBOOKS Hide an Excel worksheet How to hide a single Excel worksheet using Excel, VBA and Shortcut methods
HOW TO SHEETS and WORKBOOKS Hide an active Excel worksheet How to hide an active Excel worksheet using VBA and Shortcut methods
HOW TO SHEETS and WORKBOOKS Hide multiple Excel worksheets How to hide multiple Excel worksheets using Excel, VBA and Shortcut methods
HOW TO SHEETS and WORKBOOKS Hide an Excel worksheet in another workbook How to hide a single Excel worksheet in another open or closed workbook using VBA
HOW TO SHEETS and WORKBOOKS Unhide an Excel worksheet How to unhide a single Excel worksheet using Excel, VBA and Shortcut methods
HOW TO SHEETS and WORKBOOKS Unhide all Excel worksheets at once How to unhide all Excel worksheets at once using VBA
HOW TO SHEETS and WORKBOOKS Remove an Excel worksheet tab Color How to remove a single Excel worksheet tab's color using Excel and VBA methods
HOW TO SHEETS and WORKBOOKS Remove an active Excel worksheet tab's Color How to remove a active Excel worksheet tab's color using VBA
HOW TO SHEETS and WORKBOOKS Remove multiple Excel worksheet tabs Colors How to remove multiple Excel worksheet tabs colors at the same time, using Excel and VBA methods
HOW TO SHEETS and WORKBOOKS Check if an Excel worksheet exists with the same name How to check if an Excel worksheet exists with the same name using VBA
HOW TO SHEETS and WORKBOOKS Check if an Excel worksheet name doesn't exist and then add a worksheet How to check if an Excel worksheet name doesn't exist and then add a worksheet using VBA
HOW TO SHEETS and WORKBOOKS Check if an Excel worksheet exists with the same name and then delete the worksheet Check if an Excel worksheet exists with the same name and then delete the worksheet using VBA
HOW TO SHEETS and WORKBOOKS Check if an Excel worksheet exists with the same name and then replace the worksheet Check if an Excel worksheet exists with the same name and then replace the worksheet using VBA
HOW TO SHEETS and WORKBOOKS Hide an Excel worksheet and do not permit users to unhide How to hide an Excel worksheet and restrict users from unhiding the hidden worksheet using VBA
HOW TO SHEETS and WORKBOOKS Move to specific sheet How to move to a specific sheet using the Excel and VBA methods
HOW TO SHEETS and WORKBOOKS Show last saved date and time How to display the last date and time the workbook was saved
HOW TO SHEETS and WORKBOOKS Add Excel add-ins How to add Excel add-ins
HOW TO SHEETS and WORKBOOKS Hide sheet tabs section How to hide the sheet tabs section at the bottom of the workbook
HOW TO SHEETS and WORKBOOKS Show sheet tabs section How to show the sheet tabs section at the bottom of the workbook
HOW TO SHEETS and WORKBOOKS Insert a header How to insert a header in a specific sheet
HOW TO SHEETS and WORKBOOKS Insert a footer How to insert a footer in a specific sheet
HOW TO SHEETS and WORKBOOKS Insert a header in all sheets How to insert a header in all sheets
HOW TO SHEETS and WORKBOOKS Insert a footer in all sheets How to insert a footer in all sheets
HOW TO SHEETS and WORKBOOKS Insert a header and footer How to insert a header and footer at once in a specific sheet
HOW TO SHEETS and WORKBOOKS Insert a header on first page only How to insert a header on first page only in a specific sheet
HOW TO SHEETS and WORKBOOKS Insert a footer on first page only How to insert a footer on first page only in a specific sheet
HOW TO SHEETS and WORKBOOKS Insert page numbers into header How to insert page numbers into a header in a specific sheet
HOW TO SHEETS and WORKBOOKS Insert page numbers into footer How to insert page numbers into a footer in a specific sheet
HOW TO SHEETS and WORKBOOKS Insert current and total page numbers into header How to insert the current page number over total number of pages into a header in a specific sheet
HOW TO SHEETS and WORKBOOKS Insert current and total page numbers into footer How to insert the current page number over total number of pages into a footer in a specific sheet
HOW TO SHEETS and WORKBOOKS Insert current date into header How to insert the current date into a header in a specific sheet
HOW TO SHEETS and WORKBOOKS Insert current date into footer How to insert the current date into a footer in a specific sheet
HOW TO SHEETS and WORKBOOKS Insert current time into header How to insert the current time into a header in a specific sheet
HOW TO SHEETS and WORKBOOKS Insert current time into footer How to insert the current time into a footer in a specific sheet
HOW TO SHEETS and WORKBOOKS Insert current date and time into header How to insert the current date and time into a header in a specific sheet
HOW TO SHEETS and WORKBOOKS Insert current date and time into footer How to insert the current date and time into a footer in a specific sheet
HOW TO SHEETS and WORKBOOKS Insert sheet name into header How to insert the sheet name into a header in a specific sheet
HOW TO SHEETS and WORKBOOKS Insert sheet name into footer How to insert the sheet name into a footer in a specific sheet
HOW TO SHEETS and WORKBOOKS Insert file path and name into header How to insert the file path and name into a header in a specific sheet
HOW TO SHEETS and WORKBOOKS Insert file path and name into footer How to insert the file path and name into a footer in a specific sheet
HOW TO CELLS, COLUMNS and ROWS Insert a row How to insert a single row in a worksheet using Excel, VBA and Shortcut methods
HOW TO CELLS, COLUMNS and ROWS Insert multiple rows How to insert multiple rows in a worksheet using Excel, VBA and Shortcut methods
HOW TO CELLS, COLUMNS and ROWS Insert a column How to insert a single column in a worksheet using Excel, VBA and Shortcut methods
HOW TO CELLS, COLUMNS and ROWS Insert multiple columns How to insert multiple columns in a worksheet using Excel, VBA and Shortcut methods
HOW TO CELLS, COLUMNS and ROWS Delete a row How to delete a single row in a worksheet using Excel, VBA and Shortcut methods
HOW TO CELLS, COLUMNS and ROWS Delete multiple rows How to delete multiple rows in a worksheet using Excel, VBA and Shortcut methods
HOW TO CELLS, COLUMNS and ROWS Delete a column How to delete a single column in a worksheet using Excel, VBA and Shortcut methods
HOW TO CELLS, COLUMNS and ROWS Delete multiple columns How to delete multiple columns in a worksheet using Excel, VBA and Shortcut methods
HOW TO CELLS, COLUMNS and ROWS Clear formatting in cells How to clear formatting in cells using the Excel and VBA methods
HOW TO CELLS, COLUMNS and ROWS Clear contents in cells How to clear contents in cells using the Excel, VBA and Shortcut methods
HOW TO CELLS, COLUMNS and ROWS Superscript part value in a cell How to superscript (above the line) only some characters in a cell using Excel and VBA
HOW TO CELLS, COLUMNS and ROWS Superscript entire value in a cell How to superscript (above the line) all of the characters in a cell using Excel and VBA
HOW TO CELLS, COLUMNS and ROWS Merge cells How to merge cells using Excel and VBA methods
HOW TO CELLS, COLUMNS and ROWS Unmerge cells How to unmerge cells using Excel and VBA methods
HOW TO CELLS, COLUMNS and ROWS Wrap text How to fit content in a cell without adjusting column width using Excel and VBA methods
HOW TO CELLS, COLUMNS and ROWS Unwrap text How to unwrap content in a cell using Excel and VBA methods
HOW TO CELLS, COLUMNS and ROWS Shrink text to fit in a cell This tutorial explains and provides step by step instructions on how to shrink cell content to fit in the same cell using Excel and VBA methods
HOW TO CELLS, COLUMNS and ROWS Insert a comment How to insert a comment using the Excel, VBA and Shortcut methods
HOW TO CELLS, COLUMNS and ROWS Edit a comment How to edit a comment using the Excel, VBA and Shortcut methods
HOW TO CELLS, COLUMNS and ROWS Delete a comment How to delete a comment using the Excel, VBA and Shortcut methods
HOW TO CELLS, COLUMNS and ROWS Show a comment How to show a comment using the Excel and VBA methods
HOW TO CELLS, COLUMNS and ROWS Hide a comment How to hide a comment using the Excel and VBA methods
HOW TO CELLS, COLUMNS and ROWS Show all comments in a workbook How to show all comments in a workbook using the Excel and VBA methods
HOW TO CELLS, COLUMNS and ROWS Show all comments in a worksheet How to show all comments in a workbook using VBA
HOW TO CELLS, COLUMNS and ROWS Hide all comments in a workbook How to hide all comments in a workbook using the Excel and VBA methods
HOW TO CELLS, COLUMNS and ROWS Hide all comments in a worksheet How to hide all comments in a worksheet using VBA
HOW TO CELLS, COLUMNS and ROWS Paste ignoring hidden or filtered cells How to paste values ignoring hidden or filtered cells using an Excel method
HOW TO CELLS, COLUMNS and ROWS Select visible cells only How to only select visible cells from a selected range using Excel and VBA method
HOW TO CELLS, COLUMNS and ROWS Fill blank cells with a specific value How to fill blank cells with a specific value using an Excel and VBA method
HOW TO CELLS, COLUMNS and ROWS Color blank cells How to highlight blank cells using Excel and VBA methods
HOW TO CELLS, COLUMNS and ROWS Color non blank cells How to highlight non blank cells using Excel and VBA methods
HOW TO CELLS, COLUMNS and ROWS Highlight cells with duplicate values How to highlight cells that contain duplicate values using Excel or VBA
HOW TO CELLS, COLUMNS and ROWS Highlight cells with unique values How to highlight cells that contain unique values using Excel or VBA
HOW TO CELLS, COLUMNS and ROWS Highlight cells if value appears at least n times How to highlight cells that contain unique values using Excel or VBA
HOW TO CELLS, COLUMNS and ROWS Highlight cells if value appears no more than n times How to highlight cells if the value contained in the cells appear no more than n times in a selected range using Excel or VBA
HOW TO CELLS, COLUMNS and ROWS Highlight cells if number greater than How to highlight cells if a number in a cell is greater than a specific number in a selected range using Excel or VBA
HOW TO CELLS, COLUMNS and ROWS Highlight cells if number less than How to highlight cells if a number in a cell is less than a specific number in a selected range using Excel or VBA
HOW TO CELLS, COLUMNS and ROWS Highlight cells if number greater than or equal to How to highlight cells if a number in a cell is greater than or equal to a specific number in a selected range using Excel or VBA
HOW TO CELLS, COLUMNS and ROWS Highlight cells if number less than or equal to How to highlight cells if a number in a cell is less than or equal to a specific number in a selected range using Excel or VBA
HOW TO CELLS, COLUMNS and ROWS Highlight highest value How to highlight the highest number in a range
HOW TO CELLS, COLUMNS and ROWS Highlight lowest value How to highlight the lowest number in a range
HOW TO CELLS, COLUMNS and ROWS Highlight top 3 values How to highlight the top 3 numbers in a range
HOW TO CELLS, COLUMNS and ROWS Highlight bottom 3 values How to highlight the bottom 3 numbers in a range
HOW TO CELLS, COLUMNS and ROWS Delete entire row if contains text How to delete an entire row if text is contained in a selected range using Excel and VBA methods
HOW TO CELLS, COLUMNS and ROWS Delete entire row if contains number How to delete an entire row if a number is contained in a selected range using Excel and VBA methods
HOW TO CELLS, COLUMNS and ROWS Delete hidden rows and columns in a workbook How to delete all hidden rows and columns in a workbook at once
HOW TO CELLS, COLUMNS and ROWS Delete hidden rows and columns in a worksheet How to delete all hidden rows and columns in a specific worksheet at once
HOW TO CELLS, COLUMNS and ROWS Delete hidden rows in a worksheet How to delete only the hidden rows in a specific worksheet at once
HOW TO CELLS, COLUMNS and ROWS Delete hidden columns in a worksheet How to delete only the hidden columns in a specific worksheet at once
HOW TO FIND and REPLACE Find and select cells with specific value in a worksheet How to find and select cells with specific value in a worksheet using an Excel and VBA method
HOW TO FIND and REPLACE Find and select cells with specific value in a range How to find and select cells with specific value in a range using an Excel and VBA method
HOW TO FIND and REPLACE Find and Replace cells with specific value in a range How to find and replace cells with specific value in a range using an Excel and VBA method
HOW TO FIND and REPLACE Find and Replace cells with specific value in a worksheet How to find and replace the cells with specific value in an entire worksheet using an Excel and VBA method
HOW TO FIND and REPLACE Find and select cells between specific values in a range How to find and select cells between specific values in a range using VBA
HOW TO FIND and REPLACE Find and select cells between specific values in a worksheet How to find and select cells between specific values in a worksheet using VBA
HOW TO DATA OPTIMISATION Sort data alphabetically (A-Z) in a column How to sort data in an alphabetical order (A to Z) in a column using Excel and VBA methods
HOW TO DATA OPTIMISATION Sort data alphabetically (Z-A) in a column How to sort data in an alphabetical order (Z to A) in a column using Excel and VBA methods
HOW TO DATA OPTIMISATION Sort data alphabetically (A-Z) in a row How to sort data in an alphabetical order (A to Z) in a row using Excel and VBA methods
HOW TO DATA OPTIMISATION Sort data alphabetically (Z-A) in a row How to sort data in an alphabetical order (Z to A) in a row using Excel and VBA methods
HOW TO DATA OPTIMISATION Sort data smallest to largest in a column How to sort data from smallest to largest number in a column using Excel and VBA methods
HOW TO DATA OPTIMISATION Sort data largest to smallest in a column How to sort data from largest to smallest number in a column using Excel and VBA methods
HOW TO DATA OPTIMISATION Sort data smallest to largest in a row How to sort data from smallest to largest number in a row using Excel and VBA methods
HOW TO DATA OPTIMISATION Sort data largest to smallest in a row How to sort data from largest to smallest number in a row using Excel and VBA methods
HOW TO DATA OPTIMISATION Filter data How to filter data using Excel and VBA methods
HOW TO DATA OPTIMISATION Filter by color How to filter by color using Excel and VBA methods
HOW TO DATA OPTIMISATION Filter between two numbers How to filter between two numbers using Excel and VBA methods
HOW TO DATA OPTIMISATION Filter data for multiple criteria How to filter data for more than one criteria in a single column using VBA
HOW TO DATA OPTIMISATION Limit maximum number of characters in a cell How to limit users to only be able to enter up to a specific number of characters in a cell using Excel or VBA
HOW TO DATA OPTIMISATION Limit minimum number of characters in a cell How to limit a minimum number of characters that can be entered in a cell using Excel or VBA
HOW TO DATA OPTIMISATION Limit number of characters in a cell How to allow to only enter n number of characters in a cell using Excel or VBA
HOW TO DATA OPTIMISATION Limit between number of characters in a cell How to limit entry of characters between greater or less than number of characters in a cell using Excel or VBA
HOW TO DATA OPTIMISATION Limit not between number of characters in a cell How to limit entry of characters not between specified number of characters in a cell using Excel or VBA
HOW TO DATA OPTIMISATION Allow date greater than today in a cell How to only allow entry of dates in a cell that are greater than the current date using Excel or VBA
HOW TO DATA OPTIMISATION Allow date less than today in a cell How to only allow entry of dates in a cell that are less than the current date using Excel or VBA
HOW TO DATA OPTIMISATION Limit date to a specific year in a cell How to only allow entry of dates that have a specific year using Excel or VBA
HOW TO DATA OPTIMISATION Limit date to a specific month in a cell How to only allow entry of dates that have a specific month using Excel or VBA
HOW TO DATA OPTIMISATION Limit date to a specific day in a cell How to only allow entry of dates that have a specific day using Excel or VBA
HOW TO DATA OPTIMISATION Limit date to a specific year and month in a cell How to only allow entry of dates that have a specific year and month using Excel or VBA
HOW TO DATA OPTIMISATION Limit date to a specific month and day in a cell How to only allow entry of dates that have a specific month and day using Excel or VBA
HOW TO DATA OPTIMISATION Limit date to multiple years in a cell How to limit entry into a cell for only specific years using Excel or VBA
HOW TO SECURITY Protect a single sheet How to protect a single sheet in a workbook using Excel or VBA
HOW TO SECURITY Unprotect a single sheet How to unprotect a single sheet in a workbook using Excel or VBA
HOW TO SECURITY Protect all sheets at once How to protect all sheets in a single workbook at once through the use of VBA
HOW TO SECURITY Unprotect all sheets at once How to unprotect all protected sheets in a single workbook at once through the use of VBA
HOW TO SECURITY Protect multiple sheets at once How to protect multiple sheets at once through the use of VBA
HOW TO SECURITY Unprotect multiple sheets at once How to unprotect multiple sheets at once through the use of VBA
HOW TO SECURITY Protect a workbook How to protect an excel workbook structure using Excel or VBA
HOW TO SECURITY Unprotect a workbook How to unprotect an excel workbook structure using Excel or VBA
HOW TO TABLES Import tables from Word into Excel How to import tables from a Word document into Excel using VBA
FUNCTIONS LOOKUP & REFERENCE Excel AREAS Function The Excel AREAS function returns the number of ranges (areas) in a specified reference
FUNCTIONS LOOKUP & REFERENCE Excel ADDRESS Function The Excel ADDRESS function returns a cell reference as a string, based on a row and column number
FUNCTIONS LOOKUP & REFERENCE Excel CHOOSE Function The Excel CHOOSE function returns a value from a range (list) that is driven by a specified position
FUNCTIONS LOOKUP & REFERENCE Excel MATCH Function The Excel MATCH function searches for a specified value in a range and returns its position relative to the range
FUNCTIONS LOOKUP & REFERENCE Excel COLUMN Function The Excel COLUMN function returns the first column number of the selected reference
FUNCTIONS LOOKUP & REFERENCE Excel COLUMNS Function The Excel COLUMNS function returns the number of columns in a specified array
FUNCTIONS LOOKUP & REFERENCE Excel ROW Function The Excel ROW function returns the first row number of the selected reference
FUNCTIONS LOOKUP & REFERENCE Excel ROWS Function The Excel ROWS function returns the number of rows in a specified array
FUNCTIONS LOOKUP & REFERENCE Excel INDEX Function The Excel INDEX function returns a value that is referenced from a specified range
FUNCTIONS LOOKUP & REFERENCE Excel VLOOKUP Function The Excel VLOOKUP function searches for a specific value in the first column of the selected range (table) and returns a value that resides in the same row as the lookup value from a specific column
FUNCTIONS LOOKUP & REFERENCE Excel HLOOKUP Function The Excel HLOOKUP function searches for a specific value in the first row of the selected range (table) and returns a value that resides in the same column as the lookup value from a specific row
FUNCTIONS LOOKUP & REFERENCE Excel INDIRECT Function The Excel INDIRECT function returns a reference based on a text string
FUNCTIONS STATISTICAL Excel MAX Function The Excel MAX function returns the largest value from a specified range of numeric values
FUNCTIONS STATISTICAL Excel MIN Function The Excel MIN function returns the smallest value from a specified range of numeric values
FUNCTIONS STATISTICAL Excel COUNT Function The Excel COUNT function returns the number of cells that contain numeric values in a specified range
FUNCTIONS STATISTICAL Excel COUNTIF Function The Excel COUNTIF function returns the number of cells in a range that meet a specified criteria
FUNCTIONS STATISTICAL Excel COUNTIFS Function The Excel COUNTIFS function returns the number of cells in a range that meet one or more specified criteria
FUNCTIONS STATISTICAL Excel COUNTA Function The Excel COUNTA function returns the number of non-empty cells from a specified range
FUNCTIONS STATISTICAL Excel COUNTBLANK Function The Excel COUNTBLANK function returns the number of empty cells from a specified range
FUNCTIONS STATISTICAL Excel AVERAGE Function The Excel AVERAGE function returns the average value from a specified range
FUNCTIONS STATISTICAL Excel AVERAGEIF Function The Excel AVERAGEIF function returns the average of the numbers in a specified range based on a single criteria
FUNCTIONS STATISTICAL Excel AVERAGEIFS Function The Excel AVERAGEIFS function returns the average of the numbers in a specified range based on multiple criteria
FUNCTIONS STATISTICAL Excel LARGE Function The Excel LARGE function returns the numeric value from a specified range based on the kth largest position
FUNCTIONS STATISTICAL Excel SMALL Function The Excel SMALL function returns the numeric value from a specified range based on the kth smallest position
FUNCTIONS TEXT Excel LEFT Function The Excel LEFT function returns the specified number of characters from a specified string, starting from the left side
FUNCTIONS TEXT Excel RIGHT Function The Excel RIGHT function returns the specified number of characters from a specified string, starting from the right side
FUNCTIONS TEXT Excel MID Function The Excel MID function returns the specified number of characters from a selected string, starting at a specified position
FUNCTIONS TEXT Excel LEN Function The Excel LEN function returns the number of characters in a specified string
FUNCTIONS TEXT Excel TEXT Function The Excel TEXT function returns a numeric value as text, in a specified format
FUNCTIONS TEXT Excel FIND Function The Excel FIND function returns the position of a specific sub-string within a string
FUNCTIONS TEXT Excel SEARCH Function The Excel SEARCH function returns the position of a specific sub-string within a string
FUNCTIONS TEXT Excel SUBSTITUTE Function The Excel SUBSTITUTE function returns the position of a specific sub-string within a string
FUNCTIONS TEXT Excel TRIM Function The Excel TRIM function removes the spaces at the start and end of the text and also removes the unnecessary spaces between words, leaving only a single space between words and numbers that form part of the text
FUNCTIONS TEXT Excel VALUE Function The Excel VALUE function converts a text string that comprises number into a numeric value
FUNCTIONS TEXT Excel UPPER Function The Excel UPPER function converts all lowercase text in a specified text string to uppercase
FUNCTIONS TEXT Excel LOWER Function The Excel LOWER function converts all uppercase text in a specified text string to lowercase
FUNCTIONS LOGICAL Excel IF Function The Excel IF function performs a test on specified conditions entered into the formula and returns a specified value if the result is TRUE or another specified value if the result is FALSE
FUNCTIONS LOGICAL Excel AND Function The Excel AND function performs a test on two or more conditions and returns a TRUE or a FALSE result
FUNCTIONS LOGICAL Excel OR Function The Excel OR function performs a test on two or more conditions and returns a TRUE result if one of the conditions is met or a FALSE result if all of the specified conditions were not met
FUNCTIONS LOGICAL Excel IFERROR Function The Excel IFERROR function returns a specified value if the first value in the IFERROR formula returns an error, otherwise it will return the standard result
FUNCTIONS LOGICAL Excel NOT Function The Excel NOT function returns the opposite result of a logical value
FUNCTIONS INFORMATION Excel ISTEXT Function The Excel ISTEXT function tests a specified value (cell) if it's a text value and returns TRUE if it's a text value or FALSE if it's not a text value
FUNCTIONS INFORMATION Excel ISNUMBER Function The Excel ISNUMBER function tests a specified value (cell) if it's a numeric value and returns TRUE if it's a text value or FALSE if it's not a numeric value
FUNCTIONS INFORMATION Excel ISBLANK Function The Excel ISBLANK function is used to check if a cell is empty
FUNCTIONS MATH & TRIG Excel SUM Function The Excel SUM function returns the sum of all numbers in a specified range
FUNCTIONS MATH & TRIG Excel SUMIF Function The Excel SUMIF function returns the sum of all numbers in a specified range based on a single criteria
FUNCTIONS MATH & TRIG Excel SUMIFS Function The Excel SUMIFS function returns the sum of all numbers in a specified range based on multiple criteria
FUNCTIONS MATH & TRIG Excel SUMPRODUCT Function The Excel SUMPRODUCT function multiplies corresponding ranges and returns the sum of these values
FUNCTIONS MATH & TRIG Excel ROUND Function The Excel ROUND function returns a rounded number in accordance with the specified number of digits
FUNCTIONS MATH & TRIG Excel ROUNDUP Function The Excel ROUNDUP function returns a number that is rounded up in accordance with the specified number of digits
FUNCTIONS MATH & TRIG Excel ROUNDDOWN Function The Excel ROUNDDOWN function returns a number that is rounded down in accordance with the specified number of digits
FUNCTIONS MATH & TRIG Excel MOD Function The Excel MOD function returns the remainder after dividing a number by the divisor
FUNCTIONS MATH & TRIG Excel ABS Function The Excel ABS function returns the absolute value of a number
FUNCTIONS MATH & TRIG Excel RAND Function The Excel RAND function returns a random number between 0 and 1
FUNCTIONS MATH & TRIG Excel RANDBETWEEN Function The Excel RANDBETWEEN function returns a random number between two specified numbers
FUNCTIONS DATE & TIME Excel WEEKDAY Function The Excel WEEKDAY function returns a number between 1 and 7, representing the day of the week based on the return type that has been selected
FUNCTIONS DATE & TIME Excel DATE Function The Excel DATE function returns a date through the use of individual year, month and day parameters
FUNCTIONS DATE & TIME Excel EDATE Function The Excel EDATE function returns a date after the addition or subtraction of a specified number of months from a selected date
FUNCTIONS DATE & TIME Excel YEAR Function The Excel YEAR function returns the year from a specified date
FUNCTIONS DATE & TIME Excel MONTH Function The Excel MONTH function returns the month from a specified date
FUNCTIONS DATE & TIME Excel DAY Function The Excel DAY function returns the day from a specified date
FUNCTIONS DATE & TIME Excel TODAY Function The Excel TODAY function returns the current date
FUNCTIONS DATE & TIME Excel NOW Function The Excel NOW function returns the current date and time
FUNCTIONS COMBINATION OF FUNCTIONS IF, AND and OR Functions combined Test multiple conditions by applying the IF, AND and OR functions into a single formula
FUNCTIONS COMBINATION OF FUNCTIONS IF and AND Functions combined Applying the IF and AND functions into a single formula will return a specified value if all of the conditions are TRUE or return another specified value if one of the conditions is FALSE
FUNCTIONS COMBINATION OF FUNCTIONS IF and OR Functions combined Applying the IF and OR functions into a single formula will return a specified value if at least one of the conditions is TRUE or return another specified value is all of the conditions are FALSE
FORMULAS IF If a cell is blank How to test if a cell is blank (empty) and return a value if the test is True or False through the use of Excel formulas, with the IF and ISBLANK functions, or VBA
FORMULAS IF If a cell is blank in a range How to test if a cell is blank in a range and return a value if the test is True or False through the use of an Excel formula, with the IF and COUNTBLANK functions, or VBA
FORMULAS IF If a cell is not blank How to test if a cell is not blank and return a value if the test is True or False through the use of Excel formulas, with the IF, NOT and ISBLANK functions, or VBA
FORMULAS IF If a cell is not blank in a range How to test if a cell is not blank in a range and return a value if the test is True or False through the use of an Excel formula, with the IF and COUNTA functions, or VBA
FORMULAS IF If a cell is less than a specific value To test if a cell is less than a specific value and return a specified value you can apply an Excel or a VBA method using the Excel IF function
FORMULAS IF If a cell is greater than a specific value To test if a cell is greater than a specific value and return a specified value you can apply an Excel or a VBA method using the Excel IF function
FORMULAS IF If a cell is greater than or equal to a specific value To test if a cell is greater than or equal to a specific value and return a specified value you can apply an Excel or a VBA method using the Excel IF function
FORMULAS IF If a cell is less than or equal to a specific value To test if a cell is less than or equal to a specific value and return a specified value you can apply an Excel or a VBA method using the Excel IF function
FORMULAS IF If a range contains a specific value by row To test if a range contains a specific value by row and return a specified value you can apply an Excel or a VBA method using the Excel IF and VLOOKUP functions
FORMULAS IF If a range contains a specific value by column To test if a range contains a specific value by column and return a specified value you can apply an Excel or a VBA method using the Excel IF and HLOOKUP functions
FORMULAS IF If a range contains a value greater than To test if a range contains a value greater than a specific value and return a specified value you can apply an Excel or a VBA method using the Excel IF and COUNTIF functions
FORMULAS IF If a range contains a value less than To test if a range contains a value less than a specific value and return a specified value you can apply an Excel or a VBA method using the Excel IF and COUNTIF functions
FORMULAS IF If a range contains a value greater than or equal to To test if a range contains a value greater than or equal to a specific value and return a specified value you can apply an Excel or a VBA method using the Excel IF and COUNTIF functions
FORMULAS IF If a range contains a value less than or equal to To test if a range contains a value less than or equal to a specific value and return a specified value you can apply an Excel or a VBA method using the Excel IF and COUNTIF functions
FORMULAS IF If a range does not contain a specific value To test if a range does not contain a specific value and return a specified value you can apply an Excel or a VBA method using the Excel IF and COUNTIF functions
FORMULAS IF If a range contains a specific value To test if a range contains a specific value and return a specified value you can apply an Excel or a VBA method using the Excel IF and COUNTIF functions
FORMULAS IF If a range contains a number How to test if at least one cell in a range contains only numbers and then return a specified value
FORMULAS IF If a range contains text How to test if at least one cell in a range contains only text and then return a specified value
FORMULAS IF If a cell contains text To test if a cell contains text and return a specified value you can apply Excel or VBA methods through multiple methods with the use of an Excel IF function combined with a COUNTIF, ISNUMBER or ISTEXT function
FORMULAS IF If average number is greater than How to test if an average number from a range of cells is greater that a specific number and return a value if the test is True or False
FORMULAS IF If average number is less than How to test if an average number from a range of cells is less that a specific number and return a value if the test is True or False
FORMULAS IF If average number is greater than or equal to How to test if an average number from a range of cells is greater than or equal to a specific number and return a value if the test is True or False
FORMULAS IF If average number is less than or equal to How to test if an average number from a range of cells is less than or equal to a specific number and return a value if the test is True or False
FORMULAS IF If average number is equal to How to test if an average number from a range of cells is equal to a specific number and return a value if the test is True or False
FORMULAS IF If average number doesn't equal to How to test if an average number from a range of cells doesn't equal to a specific number and return a value if the test is True or False
FORMULAS IF If maximum number is greater than How to test if the largest number from a range of cells is greater than a specific number and return a value if the test is True or False
FORMULAS IF If maximum number is less than How to test if the largest number from a range of cells is less than a specific number and return a value if the test is True or False
FORMULAS IF If maximum number is greater than or equal to How to test if the largest number from a range of cells is greater than or equal to a specific number and return a value if the test is True or False
FORMULAS IF If maximum number is less than or equal to How to test if the largest number from a range of cells is les than or equal to a specific number and return a value if the test is True or False
FORMULAS IF If maximum number is equal to How to test if the largest number from a range of cells is equal to a specific number and return a value if the test is True or False
FORMULAS IF If maximum number doesn't equal to How to test if the largest number from a range of cells doesn't equal to a specific number and return a value if the test is True or False
FORMULAS IF If smallest number is greater than How to test if the smallest number from a range of cells is greater than a specific number and return a value if the test is True or False
FORMULAS IF If smallest number is less than How to test if the smallest number from a range of cells is less than a specific number and return a value if the test is True or False
FORMULAS IF If smallest number is greater than or equal to How to test if the smallest number from a range of cells is greater than or equal to a specific number and return a value if the test is True or False
FORMULAS IF If smallest number is less than or equal to How to test if the smallest number from a range of cells is less than or equal to a specific number and return a value if the test is True or False
FORMULAS IF If smallest number is equal to How to test if the smallest number from a range of cells is equal to a specific number and return a value if the test is True or False
FORMULAS IF If smallest number doesn't equal to How to test if the smallest number from a range of cells doesn't equal to a specific number and return a value if the test is True or False
FORMULAS IF If a date is between two dates How to test if a specific date falls between two dates and return a value if the test is True or False
FORMULAS IF If a date is not between two dates How to test if a specific date doesn't fall between two dates and return a value if the test is True or False
FORMULAS IF If a date is greater than How to test if a date is greater than another date and return a value if the test is True or False
FORMULAS IF If a date is less than How to test if a date is less than another date and return a value if the test is True or False
FORMULAS IF If a date is greater than or equal to How to test if a date is greater than or equal to another date and return a value if the test is True or False
FORMULAS IF If a date is less than or equal to How to test if a date is less than or equal to another date and return a value if the test is True or False
FORMULAS IF If a date is equal to How to test if a date is equal to another date and return a value if the test is True or False
FORMULAS IF If a date doesn't equal to How to test if a date doesn't equal to another date and return a value if the test is True or False
FORMULAS IF If a date falls on a weekend How to test if a date falls on a weekend and return a value if the test is True or False
FORMULAS IF If range of dates contains weekend How to test if a range of dates contain at least Saturday or Sunday and return a value if the test is True or False
FORMULAS IF If first numeric value in a range is equal to How to test if the first number in a range is equal to a specific number and return a value if the test is True or False
FORMULAS IF If last numeric value in a range is equal to How to test if the last number in a range is equal to a specific number and return a value if the test is True or False
FORMULAS IF If first text value in a range is equal to How to test if the first text value in a range is equal to a specific text and return a value if the test is True or False
FORMULAS IF If last text value in a range is equal to How to test if the last text value in a range is equal to a specific text and return a value if the test is True or False
FORMULAS IF If cell contains one of many values How to check if a cell contains at least one of many items and return a value
FORMULAS IF If range contains one of many values How to check if a range contains at least one of many items and return a value
FORMULAS COUNT Count cells that contain text To count cells that contain text you can apply an Excel or a VBA method through the use of an Excel COUNTIF function
FORMULAS COUNT Count cells that contain a specific value To count cells that contain a specific value you can apply an Excel or a VBA method using the Excel COUNTIF function
FORMULAS COUNT Count cells that do not contain a specific value To count cells that do not contain a specific value you can apply an Excel or a VBA method using the Excel COUNTIF function
FORMULAS COUNT Count cells that are blank To count cells that are blank you can apply the Excel COUNTBLANK function
FORMULAS COUNT Count cells that are not blank To count cells that are not blank you can apply the Excel COUNTA function
FORMULAS COUNT Count cells if greater than To count cells that are greater than a specific value you can apply an Excel or a VBA method using the Excel COUNTIF function
FORMULAS COUNT Count cells if less than To count cells that are less than a specific value you can apply an Excel or a VBA method using the Excel COUNTIF function
FORMULAS COUNT Count cells if greater than or equal to To count cells that are greater than or equal to a specific value you can apply an Excel or a VBA method using the Excel COUNTIF function
FORMULAS COUNT Count cells if less than or equal to To count cells that are less than or equal to a specific value you can apply an Excel or a VBA method using the Excel COUNTIF function
FORMULAS COUNT Count only positive numbers To count only positive numbers in a specified range you can apply the Excel COUNTIF function
FORMULAS COUNT Count only negative numbers To count only negative numbers in a specified range you can apply the Excel COUNTIF function
FORMULAS COUNT Count cells if begins with To count cells that begin with a specific value you can apply an Excel or a VBA method using the Excel COUNTIF function
FORMULAS COUNT Count cells if ends with To count cells that end with a specific value you can apply an Excel or a VBA method using the Excel COUNTIF function
FORMULAS COUNT Count cells from entire column that contain value To count cells from a single column that contain a value you can apply an Excel or a VBA method using the Excel COUNTA function
FORMULAS COUNT Count cells from entire column that contain numbers To count cells from a single column that contain numbers (cells that are numeric values) you can apply an Excel or a VBA method using the Excel COUNT function
FORMULAS COUNT Count cells from entire column that contain text To count cells from a single column that contain text (cells that are text values) you can apply an Excel or a VBA method using the Excel COUNTIF function
FORMULAS COUNT Count cells from multiple columns that contain value This tutorial shows how to count all cells that have a weekday through the use of an Excel formula or VBA
FORMULAS COUNT Count cells from entire row that contain value To count cells from entire row that contain value you can apply an Excel or a VBA method using the Excel COUNTA function
FORMULAS COUNT Count cells that contain odd numbers To count cells that contain odd numbers we need to use a combination of Excel SUMPRODUCT and MOD functions
FORMULAS COUNT Count cells that contain even numbers To count cells that contain even numbers we need to use a combination of Excel SUMPRODUCT and MOD functions
FORMULAS COUNT Count cells by weekdays To count cells by weekdays you can apply an Excel or a VBA method using a combination of Excel SUMPRODUCT and WEEKDAY functions
FORMULAS COUNT Count cells if weekdays To count cells that have a weekday you can apply an Excel or a VBA method using a combination of Excel SUMPRODUCT and WEEKDAY functions
FORMULAS COUNT Count cells by weekends To count cells by weekends you can apply an Excel or a VBA method using a combination of Excel SUMPRODUCT and WEEKDAY functions
FORMULAS COUNT Count cells if weekends To count all cells that have a weekend you can apply an Excel or a VBA method using a combination of Excel SUMPRODUCT and WEEKDAY functions
FORMULAS COUNT Count cells with values in odd rows To count cells with values in odd rows you need to apply a combination of Excel SUMPRODUCT, MOD and ROW functions
FORMULAS COUNT Count cells with values in even rows To count cells with values in even rows you need to apply a combination of Excel SUMPRODUCT, MOD and ROW functions
FORMULAS COUNT Count cells with values in odd columns To count cells with values in odd columns you need to apply a combination of Excel SUMPRODUCT, MOD and COLUMN functions
FORMULAS COUNT Count cells with values in even columns To count cells with values in even columns you need to apply a combination of Excel SUMPRODUCT, MOD and COLUMN functions
FORMULAS COUNT Count cells with specific value in odd rows To count cells with specific value in odd rows you need to apply a combination of Excel SUMPRODUCT, MOD and ROW functions
FORMULAS COUNT Count cells with specific value in even rows To count cells with specific value in even rows you need to apply a combination of Excel SUMPRODUCT, MOD and ROW functions
FORMULAS COUNT Count cells with specific value in even columns To count cells with specific value in even columns you need to apply a combination of Excel SUMPRODUCT, MOD and COLUMN functions
FORMULAS COUNT Count cells with specific value in odd columns To count cells with specific value in odd columns you need to apply a combination of Excel SUMPRODUCT, MOD and COLUMN functions
FORMULAS COUNT Count number of rows in a range To count the total number of rows in a range you can apply the Excel ROWS Function
FORMULAS COUNT Count number of columns in a range To count the total number of columns in a range you can apply the Excel COLUMNS Function
FORMULAS COUNT Count number of cells in a range To count the total number of cells in a range you need to use a combination of Excel ROWS and COLUMNS functions
FORMULAS COUNT Count number of characters in a cell To count the total number of characters, including spaces, in a cell we need to apply the Excel LEN function
FORMULAS COUNT Count number of characters in a cell excluding spaces To count the total number of characters in a cell, excluding spaces, we need to apply a combination of Excel LEN and SUBSTITUTE functions
FORMULAS COUNT Count number of characters in a range To count the total number of characters in a range, including spaces, we need to apply a combination of Excel LEN and SUMPRODUCT functions
FORMULAS COUNT Count number of characters in a range excluding spaces To count the total number of characters in a range, excluding spaces, we need to apply a combination of Excel LEN and SUMPRODUCT functions
FORMULAS COUNT Count numeric characters in a cell To count the total number of numeric characters in a cell we need to apply a combination of Excel LEN, SUMPRODUCT and SUBSTITUTE functions
FORMULAS COUNT Count numeric characters in a range To count the total number of numeric characters in a range we need to apply a combination of Excel LEN, SUMPRODUCT and SUBSTITUTE functions
FORMULAS COUNT Count number of specific characters in a cell To count the total number of specific characters in a cell we need to apply a combination of Excel LEN and SUBSTITUTE functions
FORMULAS COUNT Count number of specific characters in a range To count the total number of specific characters in a range we need to apply a combination of Excel LEN, SUBSTITUTE and SUMPRODUCT functions
FORMULAS COUNT Count numeric cells in a range This tutorial shows how to count cells that contain numeric values in a specific range and can be achieved through the use of Excel formulas or VBA
FORMULAS COUNT Count duplicate values To count duplicate values in a range we need to apply the Excel COUNTIF function
FORMULAS COUNT Count duplicate values in order How to count duplicate values in order using an Excel formula, with the COUNTIF function, or VBA
FORMULAS COUNT Count by cell color To count cells that are colored we need to create a new function in Excel, with the use of VBA, that can then be applied as any other Excel function
FORMULAS COUNT Count by font color TTo count cells that have a specific font color we need to create a new function in Excel, with the use of VBA, that can then be applied as any other Excel function
FORMULAS COUNT Count number of occurrences with multiple criteria To count the number of occurrences in range that meeting multiple criteria we need to apply an Excel COUNTIFS function
FORMULAS COUNT Count cells that equal to a specific value To count cells that are equal to a specific value you can apply an Excel or a VBA method using the Excel COUNTIF function
FORMULAS COUNT Count cells that do not equal to a specific value To count cells that do not equal to a specific value you can apply an Excel or a VBA method using the Excel COUNTIF function
FORMULAS COUNT Count dates if greater than specific date To count the number of dates that are greater than another date you can apply an Excel or VBA method
FORMULAS COUNT Count dates if less than specific date To count the number of dates that are less than another date you can apply an Excel or VBA method
FORMULAS COUNT Count dates that equal to a specific date To count the number of dates that are equal to another date you can apply an Excel or VBA method
FORMULAS COUNT Count most frequently occurring text To count the most frequently occurring text you can use a combination of the Excel COUNTIF, INDEX, MODE, MATCH and IF functions that can be applied into Excel or VBA
FORMULAS COUNT Count least frequently occurring text How to count the least frequently occurring text
FORMULAS COUNT Count by month and year How to count number of occurrences by month and year through the use of an Excel formula or VBA
FORMULAS COUNT Count by month How to count number of occurrences by month through the use of an Excel formula or VBA
FORMULAS COUNT Count by year How to count number of occurrences by year through the use of an Excel formula or VBA
FORMULAS COUNT Count by day How to count number of occurrences by day through the use of an Excel formula or VBA
FORMULAS COUNT Count number of specific substrings in a cell How to count the number of specific substrings (which can be a specific word or number) in a cell through the use of Excel formulas or VBA
FORMULAS COUNT Count number of spaces in a string How to count the number of spaces in a string
FORMULAS COUNT Count number of line breaks in a cell How to count the number of line breaks in a cell
FORMULAS COUNT Count number of spaces in a range How to count the number of spaces in a range
FORMULAS COUNT Count total number of words in a string How to count the total number of words in a string
FORMULAS COUNT Count total amount of words in a range How to return the total count of words from a range
FORMULAS COUNT Count number of decimal places How to count the number of decimal places
FORMULAS COUNT Count cells between two numbers How to count the cells between two numbers
FORMULAS COUNT Count cells with errors How to count the number of cells in a specified range that contain errors
FORMULAS COUNT Count cells that do not have errors How to count the number of cells in a specified range that do not contain errors
FORMULAS COUNT Count cells with #N/A error How to count the number of cells in a specified range that contain an #N/A error
FORMULAS COUNT Count cells with #NAME? error How to count the number of cells in a specified range that contain an #NAME? error
FORMULAS COUNT Count cells with #DIV/0! error How to count the number of cells in a specified range that contain an #DIV/0! error
FORMULAS COUNT Count cells with #VALUE! error How to count the number of cells in a specified range that contain an #VALUE! error
FORMULAS SUM Sum values if greater than To sum values that are greater than a specific value you can apply an Excel or a VBA method using the Excel SUMIF function
FORMULAS SUM Sum values if less than To sum values that are less than a specific value you can apply an Excel or a VBA method using the Excel SUMIF function
FORMULAS SUM Sum values if greater than or equal to To sum values that are greater than or equal to a specific value you can apply an Excel or a VBA method using the Excel SUMIF function
FORMULAS SUM Sum values if less than or equal to To sum values that are less than or equal to a specific value you can apply an Excel or a VBA method using the Excel SUMIF function
FORMULAS SUM Sum values if contains specific value To sum values if corresponding cells contain a specific value you can apply an Excel or a VBA method using the Excel SUMIF function
FORMULAS SUM Sum values if begins with To sum values if corresponding cells begin with a specific value you can apply an Excel or a VBA method using the Excel SUMIF function
FORMULAS SUM Sum values if ends with To sum values if corresponding cells end with a specific value you can apply an Excel or a VBA method using the Excel SUMIF function
FORMULAS SUM Sum values if cells are blank To sum value if cells are blank you can apply the Excel SUMIF function
FORMULAS SUM Sum values if cells are not blank To sum value if cells are not blank you can apply the Excel SUMIF function
FORMULAS SUM Sum values if cells contain text To sum value if corresponding cells contain text you can apply the Excel SUMIF function
FORMULAS SUM Sum only positive numbers To sum only positive numbers in a specified range you can apply the Excel SUMIF function
FORMULAS SUM Sum only negative numbers To sum only negative numbers in a specified range you can apply the Excel SUMIF function
FORMULAS SUM Sum values if cells are equal to To sum values if corresponding cells equal to a specified value you can apply the Excel SUMIF function
FORMULAS SUM Sum values if cells are not equal to To sum values if corresponding cells are not equal to a specified value you can apply the Excel SUMIF function
FORMULAS SUM Sum entire column To sum all values in a single column you can apply an Excel or a VBA method using the Excel SUM function
FORMULAS SUM Sum multiple columns To sum all values in multiple columns you can apply an Excel or a VBA method using the Excel SUM function
FORMULAS SUM Sum entire row To sum all values in a single row you can apply an Excel or a VBA method using the Excel SUM function
FORMULAS SUM Sum multiple rows To sum all values in multiple rows you can apply an Excel or a VBA method using the Excel SUM function
FORMULAS SUM Sum values by weekdays To sum values by weekdays you can apply an Excel or a VBA method using a combination of Excel SUMPRODUCT and WEEKDAY functions
FORMULAS SUM Sum values if weekdays To sum all of the values that are on a weekday you can apply an Excel or a VBA method. The formula used to sum all of the values that are on a weekday is driven by a combination of Excel SUMPRODUCT and WEEKDAY functions
FORMULAS SUM Sum values by weekends To sum values by weekends you can apply an Excel or a VBA method using a combination of Excel SUMPRODUCT and WEEKDAY functions
FORMULAS SUM Sum values if weekends To sum all of the values that are on a weekend you can apply an Excel or a VBA method using a combination of Excel SUMPRODUCT and WEEKDAY functions
FORMULAS SUM Sum cells that contain odd numbers To sum cells that only contain odd numbers we need to use a combination of Excel SUMPRODUCT and MOD functions
FORMULAS SUM Sum cells that contain even numbers To sum cells that only contain even numbers we need to use a combination of Excel SUMPRODUCT and MOD functions
FORMULAS SUM Sum cells with values in odd rows To sum cells with values in odd rows you need to apply a combination of Excel SUMPRODUCT, MOD and ROW functions
FORMULAS SUM Sum cells with values in even rows To sum cells with values in even rows you need to apply a combination of Excel SUMPRODUCT, MOD and ROW functions
FORMULAS SUM Sum cells with values in odd columns To sum cells with values in odd columns you need to apply a combination of Excel SUMPRODUCT, MOD and COLUMN functions
FORMULAS SUM Sum cells with values in even columns To sum cells with values in even columns you need to apply a combination of Excel SUMPRODUCT, MOD and COLUMN functions
FORMULAS SUM Sum largest n numbers To sum the largest n numbers in a range we can apply two methods, one which requires a manual input in the formula of the n numbers to be summed and the other can be referenced to a cell
FORMULAS SUM Sum smallest n numbers To sum the smallest n numbers in a range we can apply two methods, one which requires a manual input in the formula of the n numbers to be summed and the other can be referenced to a cell
FORMULAS SUM Sum by cell color To sum cells that have a specific color we need to create a new function in Excel, with the use of VBA, that can then be applied as any other Excel function
FORMULAS SUM Sum by font color To sum cells that have a specific font color we need to create a new function in Excel, with the use of VBA, that can then be applied as any other Excel function
FORMULAS SUM Sum values by year To sum the values by year we can apply multiple Excel and VBA methods
FORMULAS SUM Sum values if greater than a specific year To sum the values if greater than a specific year we can apply multiple Excel and VBA methods
FORMULAS SUM Sum values if less than a specific year To sum the values if less than a specific year we can apply multiple Excel and VBA methods
FORMULAS SUM Sum values by month To sum the values by month we can apply multiple Excel and VBA methods
FORMULAS SUM Sum values if greater than a specific month To sum the values if greater than a specific month we can apply multiple Excel and VBA methods
FORMULAS SUM Sum values if less than a specific month To sum the values if less than a specific month we can apply multiple Excel and VBA methods
FORMULAS SUM Sum values by day To sum the values by day we can apply multiple Excel and VBA methods
FORMULAS SUM Sum values if greater than a specific day To sum the values if greater than a specific day we can apply multiple Excel and VBA methods
FORMULAS SUM Sum values if less than a specific day To sum the values if less than a specific day we can apply multiple Excel and VBA methods
FORMULAS SUM Sum values by month and year How to sum values by month and year through the use of an Excel formula or VBA
FORMULAS SUM Dynamically change sum range How to dynamically change sum range using the Excel SUMIF, INDEX and MATCH functions
FORMULAS SUM Dynamically change multiple sum ranges How to dynamically change multiple sum ranges using the Excel SUMIF, INDEX and MATCH functions
FORMULAS SUM Sum values associated with most frequently occurring text How to sum values associated with most frequently occurring text
FORMULAS SUM Sum first n values in a column How to sum the first n values in a column
FORMULAS SUM Sum first n values in a row How to sum the first n values in a row
FORMULAS SUM Sum last n values in a column How to sum the last n values in a column
FORMULAS SUM Sum last n values in a row How to sum the last n values in a row
FORMULAS SUM Sum last n columns How to add up the last n columns from a specific range
FORMULAS SUM Sum last n rows How to add up the last n rows from a specific range
FORMULAS SUM Sum first n columns How to add up the first n columns from a specific range
FORMULAS SUM Sum first n rows How to add up the first n rows from a specific range
FORMULAS SUM Sum range of cells and ignore errors How to sum cells and ignore errors
FORMULAS SUM Sum absolute values How to sum absolute values from a range
FORMULAS SUM Sumif with multiple criteria in same column How to use the SUMIF function with multiple criteria in one column
FORMULAS SUM If total is greater than How to test if a sum of numbers from a range of cells is greater than a specific number and return a value if the test is True or False
FORMULAS SUM If total is less than How to test if a sum of numbers from a range of cells is less than a specific number and return a value if the test is True or False
FORMULAS SUM If total is greater than or equal to How to test if a sum of numbers from a range of cells is greater than or equal to a specific number and return a value if the test is True or False
FORMULAS SUM If total is less than or equal to How to test if a sum of numbers from a range of cells is less than or equal to a specific number and return a value if the test is True or False
FORMULAS SUM If total is equal to How to test if a sum of numbers from a range of cells is equal to a specific number and return a value if the test is True or False
FORMULAS SUM If total doesn't equal to How to test if a sum of numbers from a range of cells doesn't equal to a specific number and return a value if the test is True or False
FORMULAS SUM Sum time by week and task How to sum the time by week and project
FORMULAS SUM Sum time by month and task How to sum the time by month and project
FORMULAS SUM Sum time by year and task How to sum the time by year and project
FORMULAS SUM Sum values by week How to sum values by week
FORMULAS SUM Sum values by week and task How to sum values by week and task
FORMULAS SUM Sum values by month and task How to sum values by month and task
FORMULAS SUM Sum values by year and task How to sum values by year and task
FORMULAS SUM Sum by group How to sum by group
FORMULAS SUM Sum by group in a table How to sum by group in a table
FORMULAS AVERAGE Average values if greater than To average numbers that are greater than a specific value you can apply an Excel or a VBA method using the Excel AVERAGEIF function
FORMULAS AVERAGE Average values if less than To average numbers that are less than a specific value you can apply an Excel or a VBA method using the Excel AVERAGEIF function
FORMULAS AVERAGE Average values if greater than or equal to To average values that are greater than or equal to a specific value you can apply an Excel or a VBA method using the Excel AVERAGEIF function
FORMULAS AVERAGE Average values if less than or equal to To average values that are less than or equal to a specific value you can apply an Excel or a VBA method using the Excel AVERAGEIF function
FORMULAS AVERAGE Average values if contains specific value To average values if contains a specific value you can apply an Excel or a VBA method using the Excel AVERAGEIF function
FORMULAS AVERAGE Average values if begins with To average values if begins with a specific value you can apply an Excel or a VBA method using the Excel AVERAGEIF function
FORMULAS AVERAGE Average values if ends with To average values if ends with a specific value you can apply an Excel or a VBA method using the Excel AVERAGEIF function
FORMULAS AVERAGE Average values if cells are blank To average values if cells are blank you can apply an Excel or a VBA method using the Excel AVERAGEIF function
FORMULAS AVERAGE Average values if cells are not blank To average values if cells are not blank you can apply an Excel or a VBA method using the Excel AVERAGEIF function
FORMULAS AVERAGE Average values if cells contain text To average value if corresponding cells contain text you can apply the Excel AVERAGEIF function
FORMULAS AVERAGE Average only positive numbers To average only positive numbers you can apply the Excel AVERAGEIF function
FORMULAS AVERAGE Average only negative numbers To average only negative numbers you can apply the Excel AVERAGEIF function
FORMULAS AVERAGE Average values if cells are equal to To average values if cells are equal to specific value you can apply the Excel AVERAGEIF function
FORMULAS AVERAGE Average values if cells are not equal to To average values if cells are not equal to specific value you can apply the Excel AVERAGEIF function
FORMULAS AVERAGE Average entire column To average an entire column you can apply the Excel AVERAGE function
FORMULAS AVERAGE Average multiple columns To average multiple columns you can apply the Excel AVERAGE function
FORMULAS AVERAGE Average entire row To average an entire row you can apply the Excel AVERAGE function
FORMULAS AVERAGE Average multiple rows To average multiple rows you can apply the Excel AVERAGE function
FORMULAS AVERAGE Average largest n numbers To average the largest n numbers in a range you will need to manual input into the formula the largest n numbers to be averaged
FORMULAS AVERAGE Average smallest n numbers To average the smallest n numbers in a range you will need to manual input into the formula the smallest n numbers to be averaged
FORMULAS AVERAGE Average first n values in a column How to average the first n values in a column
FORMULAS AVERAGE Average first n values in a row How to average the first n values in a row
FORMULAS AVERAGE Average last n values in a column How to average the last n values in a column
FORMULAS AVERAGE Average last n values in a row How to average the last n values in a row
FORMULAS AVERAGE Average numbers and ignore zeros How to average numbers in a range and ignore zeros
FORMULAS AVERAGE Average ignoring errors How to average values in a range ignoring cells with errors
FORMULAS DATE & TIME Convert date to day name To convert a date into a day name you can apply the Excel TEXT function
FORMULAS DATE & TIME Convert date to month name To convert a date into a month name you can apply the Excel TEXT function
FORMULAS DATE & TIME Convert number in ddmmyyyy order to date To convert number in ddmmyyyy order to date you need to apply a combination of the Excel DATE, RIGHT, MID and LEFT functions
FORMULAS DATE & TIME Convert number in yyyymmdd order to date To convert number in yyyymmdd order to date you need to apply a combination of the Excel DATE, LEFT, MID and RIGHT functions
FORMULAS DATE & TIME Show current date To show the current date you can apply the Excel TODAY Function
FORMULAS DATE & TIME Show current date and time To show the current date and time you can apply the Excel NOW Function
FORMULAS DATE & TIME Add years to date To add years to a date you can apply the Excel DATE function
FORMULAS DATE & TIME Subtract years from date To subtract years from a date you can apply the Excel DATE function
FORMULAS DATE & TIME Add days to date To add days to a date you can directly add the number of days to the formula or apply the Excel DATE function
FORMULAS DATE & TIME Subtract days from date To subtract days from a date you can directly add the number of days to the formula or apply the Excel DATE function
FORMULAS DATE & TIME Add months to date To add months to a date you can apply the Excel EDATE or DATE functions
FORMULAS DATE & TIME Subtract months from date To subtract months from a date you can apply the Excel EDATE or DATE functions
FORMULAS DATE & TIME Add weeks to date To add weeks to a date you can directly add the number of weeks to the formula, by multiplying by the number of days in a week, or apply the Excel DATE function
FORMULAS DATE & TIME Subtract weeks from date To subtract weeks from a date you can directly subtract the number of weeks from the formula, by multiplying by the number of days in a week by the number of weeks you want to subtract, or apply the Excel DATE function
FORMULAS DATE & TIME Add quarters to date To add quarters to a date you can directly add the number of quarters to the formula, by multiplying by the number of months in a quarter, or apply the Excel DATE function
FORMULAS DATE & TIME Subtract quarters from date To subtract quarters from a date you can apply the Excel EDATE or DATE function
FORMULAS DATE & TIME Difference in months between two dates To calculate the difference in months between two dates you can apply the Excel DATEDIF function
FORMULAS DATE & TIME Difference in days between two dates To calculate the difference in days between two dates you can apply the Excel DATEDIF function
FORMULAS DATE & TIME Difference in years between two dates To calculate the difference in years between two dates you can apply the Excel DATEDIF function
FORMULAS DATE & TIME Convert month name to number How to convert a month's name into a number using an Excel and VBA method
FORMULAS DATE & TIME Convert number to month name How to convert a number, from 1 to 12, into a month's name using an Excel and VBA method
FORMULAS DATE & TIME Return previous month based on current month How to return the previous month based on the current month through the use of Excel formulas or VBA
FORMULAS DATE & TIME Return next month based on current month How to return the next month based on the current month through the use of Excel formulas or VBA
FORMULAS DATE & TIME Return previous month based on a date How to return the previous month based on a specific date through the use of Excel formulas or VBA
FORMULAS DATE & TIME Return next month based on a date How to return the next month based on a specific date through the use of Excel formulas or VBA
FORMULAS DATE & TIME Return previous day based on current day How to return the previous day based on the current day through the use of an Excel formula or VBA
FORMULAS DATE & TIME Return next day based on current day How to return the next day based on the current day through the use of an Excel formula or VBA
FORMULAS DATE & TIME Return previous day based on a date How to return the previous day based on a specific date through the use of an Excel formula or VBA
FORMULAS DATE & TIME Return next day based on a date How to return the next day based on a specific date through the use of an Excel formula or VBA
FORMULAS DATE & TIME Return previous year based on current year How to return the previous year based on the current year through the use of an Excel formula or VBA
FORMULAS DATE & TIME Return next year based on current year How to return the next year based on the current year through the use of an Excel formula or VBA
FORMULAS DATE & TIME Return number of days in a month How to return the number of days in a specific month through the use of an Excel formula or VBA
FORMULAS DATE & TIME Return last day of a month How to return the last day of a specific month through the use of an Excel formula or VBA
FORMULAS DATE & TIME Return first day of a month How to return the first day of a specific month through the use of an Excel formula or VBA
FORMULAS DATE & TIME Return number of days in a current month How to return the number of days in a current month through the use of an Excel formula or VBA
FORMULAS DATE & TIME Return last day of a current month How to return the last day of a current month through the use of an Excel formula or VBA
FORMULAS DATE & TIME Return last day of next month How to return the last day of next month through the use of an Excel formula or VBA
FORMULAS DATE & TIME Combine date and time How to combine a date and time in one cell through the use of an Excel formula or VBA
FORMULAS DATE & TIME Return next working day How to return the next work day (business day) using an Excel formula or VBA
FORMULAS DATE & TIME Return next working day 6 months in the future How to return the next work day (business day) six months in the future using an Excel formula or VBA
FORMULAS DATE & TIME Return next working day 6 months back How to return the next work day (business day) six months back using an Excel formula or VBA
FORMULAS DATE & TIME Return next working day 1 week in the future How to return the next work day (business day) one week in the future using an Excel formula or VBA
FORMULAS DATE & TIME Return next working day 1 week back How to return the next work day (business day) one week back using an Excel formula or VBA
FORMULAS DATE & TIME Return previous working day How to return the previous work day (business day) using an Excel formula or VBA
FORMULAS DATE & TIME Return previous working day 6 months in the future How to return the previous work day (business day) six months in the future using an Excel formula or VBA
FORMULAS DATE & TIME Return previous working day 6 months back How to return the previous work day (business day) six months back using an Excel formula or VBA
FORMULAS DATE & TIME Return previous working day 1 week in the future How to return the previous work day (business day) one week in the future using an Excel formula or VBA
FORMULAS DATE & TIME Return previous working day 1 week back How to return the previous work day (business day) one week back using an Excel formula or VBA
FORMULAS DATE & TIME Return workdays in a month How to return the number of working days in a month using an Excel formula or VBA
FORMULAS DATE & TIME Return remaining workdays in a month How to return the remaining number of working days in a month using an Excel formula or VBA
FORMULAS DATE & TIME Return elapsed workdays in a month How to return the elapsed number of working days in a month using an Excel formula or VBA
FORMULAS DATE & TIME Return workdays between dates How to return the number of working days (business days) between two dates using an Excel formula or VBA
FORMULAS DATE & TIME Return work hours between dates How to return the work hours that exist between two dates using an Excel formula or VBA
FORMULAS DATE & TIME Combine day, month and year to create date How to combine the day, month and year values that are separately captured to derive with a date using an Excel formula or VBA
FORMULAS DATE & TIME Add workdays to date How to add workdays to a date
FORMULAS DATE & TIME Subtract workdays from date How to subtract workdays from a date
FORMULAS DATE & TIME Add days excluding specific days of week How to add days excluding specific days of a week
FORMULAS DATE & TIME Add hours to time How to add hours to time
FORMULAS DATE & TIME Subtract hours from time How to subtract hours from time
FORMULAS DATE & TIME Add minutes to time How to add minutes to time
FORMULAS DATE & TIME Subtract minutes from time How to subtract minutes from time
FORMULAS DATE & TIME Add seconds to time How to add seconds to time
FORMULAS DATE & TIME Subtract seconds from time How to subtract seconds from time
FORMULAS DATE & TIME Return date overlap in days How to return date overlap in days
FORMULAS DATE & TIME Return days remaining as of today How to return days remaining as of today
FORMULAS DATE & TIME Return days remaining between two dates How to calculate the remaining days between two dates
FORMULAS DATE & TIME Return date from date and time string How to extract only the date from a date and time string
FORMULAS DATE & TIME Return time from date and time string How to extract only the time from a date and time string
FORMULAS DATE & TIME Convert hours to time How to convert hours into time
FORMULAS DATE & TIME Convert minutes to time How to convert minutes into time
FORMULAS DATE & TIME Convert seconds to time How to convert seconds into time
FORMULAS DATE & TIME Return first day of a current year How to calculate the first day of a current year
FORMULAS DATE & TIME Return last day of a current year How to calculate the last day of a current year
FORMULAS DATE & TIME Return first Monday of a month How to find the first Monday of a month
FORMULAS DATE & TIME Return first day of a year How to get the first day of a year
FORMULAS DATE & TIME Return last day of a year How to get the last day of a year
FORMULAS DATE & TIME Return task end date How to get the task end date
FORMULAS DATE & TIME Return task start date How to get the task start date
FORMULAS DATE & TIME Return task midpoint date How to get the task midpoint date
FORMULAS DATE & TIME Return latest date in a range How to get the latest date in a range
FORMULAS DATE & TIME Return earliest date in a range How to get the earliest date in a range
FORMULAS DATE & TIME Return latest date for a specific year in a range How to get the latest date for a specific year in a range
FORMULAS DATE & TIME Return earliest date for a specific year in a range How to get the earliest date for a specific year in a range
FORMULAS TEXT Remove characters from left To remove character from the left of the selected string you need to apply a combination of Excel RIGHT and LEN functions
FORMULAS TEXT Remove characters from right To remove character from the right of the selected string you need to apply a combination of Excel LEFT and LEN functions
FORMULAS TEXT Remove specific characters from string To remove specific characters from a string you need to apply the Excel SUBSTITUTE function
FORMULAS TEXT Remove first character from string To remove the first character from a selected string you need to apply a combination of Excel RIGHT and LEN functions
FORMULAS TEXT Remove last character from string To remove the last character from a selected string you need to apply a combination of Excel LEFT and LEN functions
FORMULAS TEXT Convert numbers to text To convert numbers to text you need to apply the Excel TEXT function
FORMULAS TEXT Remove leading and trailing spaces and extra spaces between words To remove leading and trailing spaces of the text and extra spaces between words and numbers, leaving only a single space between words and numbers we need to apply the Excel TRIM function
FORMULAS TEXT Remove leading and trailing spaces in a cell To remove only the leading and trailing spaces from text in a cell we need to use the VBA TRIM function
FORMULAS TEXT Remove leading spaces in a cell To remove only the leading spaces from text in a cell we need to use the VBA LTrim function
FORMULAS TEXT Remove trailing spaces in a cell To remove only the trailing spaces from text in a cell we need to use the VBA RTrim function
FORMULAS TEXT Remove leading zeros To remove the leading zeros in a string we need to apply the Excel VALUE function
FORMULAS TEXT Change lowercase to uppercase To change the lowercase into uppercase for a specific text sting we need to apply the Excel UPPER function
FORMULAS TEXT Change uppercase to lowercase To change uppercase into lowercase for a specific text sting we need to apply the Excel LOWER function
FORMULAS TEXT Return most frequently occurring text To return the most frequently occurring text you can use a combination of the Excel INDEX, MODE, MATCH and IF functions that can be applied into Excel or VBA
FORMULAS TEXT Return most frequently occurring text if begins with specific value How to get the most frequently occurring text which begins with specific a value
FORMULAS TEXT Return least frequently occurring text How to extract the least frequently occurring text
FORMULAS TEXT Return first word from a string How to return the first word from a string using an Excel formula or VBA
FORMULAS TEXT Return last word from a string How to return the last word from a string using an Excel formula or VBA
FORMULAS TEXT Return substring How to return a substring using an Excel formula or VBA
FORMULAS TEXT Insert double quotes into a formula How to add double quotation marks into a formula
FORMULAS TEXT Insert a value before each word How to insert a value before each word
FORMULAS TEXT Insert a value after each word How to insert a value after each word
FORMULAS TEXT Insert a comma after each word How to insert a comma after each word
FORMULAS TEXT Insert a comma before each word How to insert a comma before each word
FORMULAS TEXT Insert a comma after first word How to insert a comma after the first word
FORMULAS TEXT Insert full stop to end of a cell How to add a full stop (.) to the end of a cell
FORMULAS TEXT Insert comma to end of a cell How to add a comma (,) to the end of a cell
FORMULAS TEXT Insert a comma before first number How to insert a comma (,) before the first number in a cell
FORMULAS TEXT Insert a comma after first number How to insert a comma (,) after the first number in a cell
FORMULAS TEXT Combine value in cells with a comma How to combine values in separate cells with a comma (,)
FORMULAS TEXT Insert brackets around value in a cell How to insert brackets around values captured in a cell
FORMULAS TEXT Insert brackets around values in a range How to insert brackets around all values captured in a range
FORMULAS TEXT Combine date and text How to combine a date and text
FORMULAS TEXT Repeat a value n times in a cell How to repeat a value n number of times in a cell
FORMULAS TEXT Insert apostrophe in front of numbers How to add an apostrophe (') in front of a numeric cell
FORMULAS TEXT Insert a value after first nth character How to insert a value after the first nth character
FORMULAS TEXT Insert a value before first nth character How to insert a value before the first nth character
FORMULAS TEXT Insert a value before last nth character How to insert a value before the last nth character
FORMULAS TEXT Insert a value after last nth character How to insert a value after the last nth character
FORMULAS TEXT Return nth character How to extract the nth character
FORMULAS TEXT Return all characters after and including nth character How to extract all characters after and including the nth character from a string
FORMULAS TEXT Return all characters after nth character How to extract all characters after the nth character from a string
FORMULAS TEXT Add leading zero to a number How to add a leading zero (0) to a number
FORMULAS TEXT Add trailing zero to a number How to add a trailing zero (0) to a number
FORMULAS TEXT Add trailing zeros to a number to make number certain length How to add a trailing zeros (0) to a number to make number certain length
FORMULAS TEXT Insert value in middle of a cell How to add value in middle of a cell
FORMULAS TEXT Capitalize first letter of each word How to uppercase the first letter of each word from a string
FORMULAS TEXT Capitalize only first letter How to uppercase only the first letter in a string
FORMULAS TEXT Capitalize only first letter and lowercase the rest How to lowercase all letters and uppercase only the first letter in a string
FORMULAS TEXT Capitalize all letters except for the first letter How to uppercase all letters except for the first letter in a string
FORMULAS TEXT Lowercase only first letter and capitalize the rest How to lowercase only the first letter and capitalize the rest in a string
FORMULAS TEXT Move first word to the end How to move the first word to the end of a string
FORMULAS TEXT Move last word to the front How to move the last word in a string to the end
FORMULAS TEXT Return nth value from a string How to get the nth value from a string
FORMULAS TEXT Combine values from different cells How to concatenate values from different cells into one cell
FORMULAS TEXT Combine values from different cells with a space How to concatenate values from different cells into one cell separated by a single space
FORMULAS TEXT Combine values from different cells with line break How to concatenate values from different cells into one cell separated by line breaks for each combined value
FORMULAS LOOKUP Return last numeric value in a column To return the last numeric value in a column we can apply two methods using an Excel VLOOKUP function or a combination of an Excel INDEX and MATCH functions
FORMULAS LOOKUP Return last numeric value in a row To return the last numeric value in a row we can apply two methods using an Excel HLOOKUP function or a combination of an Excel INDEX and MATCH functions
FORMULAS LOOKUP Return row number of a specific value To return a row number of a specific value we need to apply the Excel MATCH function
FORMULAS LOOKUP Return column number of a specific value To return a column number of a specific value we need to apply the Excel MATCH function
FORMULAS LOOKUP Return column name of a specific value To return a column name of a specific value we need to apply a combination of Excel SUBSTITUTE, ADDRESS and MATCH functions
FORMULAS LOOKUP Return column name of a cell where the formula is written To return a column name of a cell where the formula is written we need to apply a combination of Excel SUBSTITUTE, ADDRESS and COLUMN functions
FORMULAS LOOKUP Return column name of a specific cell To return a column name of a specific cell we need to apply a combination of Excel SUBSTITUTE, ADDRESS and COLUMN functions
FORMULAS LOOKUP Return first column number in a range To return the first column number from a selected range using an Excel formula or VBA
FORMULAS LOOKUP Return nth column number in a range To return the nth column number from a selected range using an Excel formula or VBA
FORMULAS LOOKUP Return nth row number in a range To return the nth row number from a selected range using an Excel formula or VBA
FORMULAS LOOKUP Return first column name in a range To return the first column name from a selected range using an Excel formula or VBA
FORMULAS LOOKUP Return first row number in a range To return the first row number from a selected range using an Excel formula or VBA
FORMULAS LOOKUP Return last column number in a range To return the last column number from a selected range using an Excel formula or VBA
FORMULAS LOOKUP Return last row number in a range To return the last row number from a selected range using an Excel formula or VBA
FORMULAS LOOKUP Return last column name in a range To return the last column name from a selected range using an Excel formula or VBA
FORMULAS LOOKUP Return highest number How to return the highest value from a range of values using Excel formulas, with the LARGE or MAX functions, or VBA
FORMULAS LOOKUP Return lowest number How to return the lowest value from a range of values using Excel formulas, with the SMALL or MIN functions, or VBA
FORMULAS LOOKUP Lookup nth largest value To lookup the nth largest value in a range we need to apply the Excel LARGE function
FORMULAS LOOKUP Lookup nth smallest value To lookup the nth smallest value in a range we need to apply the Excel SMALL function
FORMULAS LOOKUP Lookup nth largest value with criteria To lookup the nth largest value in a range with criteria we need to apply the Excel LARGE function
FORMULAS LOOKUP Return maximum number ignoring errors How to find the maximum number from a specified range ignoring errors
FORMULAS LOOKUP Return minimum number ignoring errors How to find the minimum number from a specified range ignoring errors
FORMULAS LOOKUP Lookup nth smallest value with criteria To lookup the nth smallest value in a range with criteria we need to apply the Excel SMALL function
FORMULAS LOOKUP Two dimensional lookup with VLOOKUP and HLOOKUP This tutorial shows how to apply a two dimensional lookup using a combination of an Excel VLOOKUP and HLOOKUP functions
FORMULAS LOOKUP Two dimensional lookup with VLOOKUP and MATCH This tutorial shows how to apply a two dimensional lookup using a combination of an Excel VLOOKUP and MATCH functions
FORMULAS LOOKUP Two dimensional lookup with HLOOKUP and MATCH This tutorial shows how to apply a two dimensional lookup using a combination of an Excel HLOOKUP and MATCH functions
FORMULAS LOOKUP Two dimensional lookup with INDEX and MATCH This tutorial shows how to apply a two dimensional lookup using a combination of an Excel INDEX and MATCH functions
FORMULAS LOOKUP Find duplicate values in a range This tutorial shows how to find duplicate values in a range using the Excel IF and COUNTIF functions
FORMULAS LOOKUP Find first duplicate in a range This tutorial shows how to find the first duplicate value in a range using the Excel and VBA
FORMULAS LOOKUP Find nth duplicate in a range This tutorial shows how to find the nth duplicate value in a range using the Excel and VBA
FORMULAS LOOKUP Return value of first non-blank cell in a range This tutorial shows how to return the value of the first non-blank cell in a range by using the INDEX and MATCH functions
FORMULAS LOOKUP Display current sheet name To display the current/active sheet name in a cell in Excel we can use two different formulas or use VBA
FORMULAS LOOKUP Display workbook name To display the workbook name in a cell we can use two different Excel methods formulas or use VBA
FORMULAS LOOKUP Display workbook file path To display the current/active workbook file path in a cell we can use an Excel or a VBA method
FORMULAS LOOKUP Display workbook file path, name and active sheet name To display a workbook's file path, name and active sheet name in a single cell we can use the Excel CELL function
FORMULAS LOOKUP Return row number of an active cell To return a row number of an active cell we need to use an ActiveCell.Row function in VBA
FORMULAS LOOKUP Return column number of an active cell To return a column number of an active cell we need to use an ActiveCell.Column function in VBA
FORMULAS LOOKUP Return text before a specific character To return text before a specific character we can apply a combination of Excel LEFT and FIND functions
FORMULAS LOOKUP Return text after a specific character To return text after a specific character we can apply a combination of Excel MID and FIND functions
FORMULAS LOOKUP Return row number of the last non-blank cell in a column To return the row number of the last non-blank cell in a single column you will need to use VBA
FORMULAS LOOKUP Return column number of the last non-blank cell in a row To return the column number of the last non-blank cell in a single row you will need to use VBA
FORMULAS LOOKUP Extract text string between two characters To extract a text string between two characters you can use a combination of Excel MID, SEARCH, FIND and LEN functions
FORMULAS LOOKUP Return address of active cell To get the address of an active cell you can use a combination of Excel ADDRESS, ROW and COLUMN functions
FORMULAS LOOKUP Return address of a specific cell How to get the address of a specific cell
FORMULAS LOOKUP Return address of first cell in a range How to get the address of a first cell in a range
FORMULAS LOOKUP Return address of last cell in a range How to get the address of a last cell in a range
FORMULAS LOOKUP Return only decimal part of a number How to return only the decimal component of a number
FORMULAS LOOKUP Return only integer part of a number How to return only the integer component of a number
FORMULAS LOOKUP Use SUMIF as VLOOKUP How to use the the SUMIF function as a VLOOKUP function
FORMULAS LOOKUP Return first decimal number How to extract the first decimal number
FORMULAS LOOKUP Return last decimal number How to extract the last decimal number
FORMULAS LOOKUP Return nth decimal number How to extract the nth decimal number
FORMULAS LOOKUP Return most frequently occurring number How to get the most frequently occurring number from a list
FORMULAS LOOKUP Return first entry by month and year How to get the first entry by month and year
FORMULAS LOOKUP Return first entry by month How to get the first entry by month
FORMULAS LOOKUP Return first entry by year How to get the first entry by year
FORMULAS LOOKUP Return last entry by month and year How to get the last entry by month and year
FORMULAS LOOKUP Return last entry by month How to get the last entry by month
FORMULAS LOOKUP Return last entry by year How to get the last entry by year
FORMULAS LOOKUP Return largest number with criteria How to get the largest number from a list with a specific criteria
FORMULAS LOOKUP Return smallest number with criteria How to get the smallest number from a list with a specific criteria
FORMULAS LOOKUP Return value associated with nth occurrence How to get the value associated with the nth occurrence in a range, with criteria
FORMULAS LOOKUP Return value associated with first occurrence How to get the value associated with the first occurrence in a range, with criteria
FORMULAS LOOKUP Return value associated with last occurrence How to get the value associated with the last occurrence in a range, with criteria
FORMULAS ROUND Round to the nearest thousand To round a number to the nearest thousand we need to apply the Excel ROUND function
FORMULAS ROUND Round to the nearest million To round a number to the nearest million we need to apply the Excel ROUND function
FORMULAS ROUND Round up a number To round up a number we need to apply the Excel ROUNDUP function
FORMULAS ROUND Round down a number To round down a number we need to apply the Excel ROUNDDOWN function
FORMULAS ROUND Round a number To round a number we need to apply the Excel ROUND function
FORMULAS ROUND Round a number to two decimal places How to round a number to two decimal places
FORMULAS ROUND Round to the nearest hundred How to round a number to the nearest hundred
FORMULAS ROUND Round to the nearest ten How to round a number to the nearest ten
FORMULAS ROUND Round if greater than How to round a number if it is greater than a specific number
FORMULAS ROUND Round if less than How to round a number if it is less than a specific number
FORMULAS ROUND Round if equal to How to round a number if it is equal to a specific number
FORMULAS ROUND Round if greater than or equal to How to round a number if it is greater than or equal to a specific number
FORMULAS ROUND Round if less than or equal to How to round a number if it is less than or equal to a specific number
FORMULAS ROUND Round if doesn't equal to How to round a number if it doesn't equal to a specific number
FORMULAS ROUND Round if decimal number is equal to How to round if a decimal number is equal to a specific number
FORMULAS ROUND Round if decimal number is greater than How to round if decimal number is greater than a specific number
FORMULAS ROUND Round if decimal number is less than How to round if decimal number is less than a specific number
FORMULAS ROUND Round if decimal number is greater than or equal to How to round if a decimal number is greater than or equal to a specific number
FORMULAS ROUND Round if decimal number is less than or equal to How to round if a decimal number is less than or equal to a specific number
FORMULAS ROUND Round if decimal number doesn't equal to How to round if a decimal number doesn't equal to a specific number
FORMULAS ROUND Round if decimal number ends with How to round if a decimal number ends with a specific number
FORMULAS ROUND Round if last decimal number is greater than How to round if last decimal number is greater than a specific number
FORMULAS ROUND Round if last decimal number is less than How to round if last decimal number is less than a specific number
FORMULAS ROUND Round if last decimal number is greater than or equal to How to round if last decimal number is greater than or equal to a specific number
FORMULAS ROUND Round if last decimal number is less than or equal to How to round if last decimal number is less than or equal to a specific number
FORMULAS ROUND Round if decimal number doesn't end with How to round if decimal number doesn't end with a specific number
FORMULAS ROUND Round if first decimal number is equal to How to round if the first decimal number is equal to a specific number
FORMULAS ROUND Round if first decimal number is greater than How to round if the first decimal number is greater than a specific number
FORMULAS ROUND Round if first decimal number is less than How to round if the first decimal number is less than a specific number
FORMULAS ROUND Round if first decimal number is greater than or equal to How to round if the first decimal number is greater than or equal to a specific number
FORMULAS ROUND Round if first decimal number is less than or equal to How to round if the first decimal number is less than or equal to a specific number
FORMULAS ROUND Round if first decimal number doesn't equal to How to round if the first decimal number doesn't equal to a specific number
FORMULAS ROUND Round if nth decimal number is equal to How to round a number if the nth decimal number is equal to a specific number
FORMULAS ROUND Round if number of decimal places is equal to How to round a number if the number of decimal places is equal to a specific number
FORMULAS RANDOM Generate random numbers How to generate random numbers between 0 and 1
FORMULAS RANDOM Generate random number between two numbers How to generate a random number between two specific numbers
FORMULAS RANDOM Generate random number between two numbers with decimals How to generate a random number between two numbers with decimals
FORMULAS RANDOM Generate random number between two numbers with two decimal places How to generate a random number between two numbers with 2 decimal places
FORMULAS RANDOM Generate random values from a column How to generate a random value from a specific range in a single column
FORMULAS RANDOM Generate random values from a row How to generate a random value from a specific range in a single row
FORMULAS RANDOM Generate random values from a range How to generate random values from a range
FORMULAS RANK Rank list of value How to rank a list of values
FORMULAS RANK Rank list of value in ascending order How to rank a list of values in ascending order
FORMULAS RANK Rank only positive numbers How to rank only positive numbers
FORMULAS RANK Rank only negative numbers How to rank only negative numbers
FORMULAS RANK If ranked first How to test if a value in a cell is ranked first and return a value if the test is True or False
FORMULAS RANK If ranked last How to test if a value in a cell is ranked last and return a value if the test is True or False
FORMULAS RANK Find largest n numbers How to find the n largest numbers from a specific range
FORMULAS RANK Rank by group How to rank a number by group
FORMULAS RANK Rank if greater than zero How to rank a number if it is greater than zero (0)
FORMULAS RANK Rank if greater than or equal to zero How to rank a number if it is greater than or equal to zero (0)
FORMULAS RANK Rank ignoring zeros How to rank numbers ignoring zeros (0)
FORMULAS RANK Rank ignoring blank cells How to rank numbers whilst ignoring blank cells
FORMULAS RANK Find smallest n numbers How to find the n smallest numbers from a specific range
FORMULAS RANK Rank by alphabetical order How to rank text by alphabetical order
FORMULAS RANK Rank list without ties How to rank a range of numbers without ties
FORMULAS RANK Rank if list contains more than n entries How to rank a set of numbers if a list contains more than n entries
FORMULAS RANK Rank if list contains more than or equal to n entries How to rank a set of numbers if a list contains more than or equal to n entries
FORMULAS RANK Rank if list contains less than n entries How to rank a set of numbers if a list contains less than n entries
FORMULAS RANK Rank if list contains less than or equal to n entries How to rank a set of numbers if a list contains less than or equal to n entries
FORMULAS RANK Rank without ties ignoring zeros How to rank a range of numbers without ties whilst ignoring zeros (0)
FORMULAS RANK Rank top n numbers How to rank the top n numbers only from a list
FORMULAS RANK Rank bottom n numbers How to rank the bottom n numbers only from a list
FORMULAS RANK Rank top n numbers without ties How to rank the top n numbers only, without ties, from a list
FORMULAS RANK Rank bottom n numbers without ties How to rank the bottom n numbers only, without ties, from a list
EXPLANATION OVERVIEW What is Excel? Explanation of what is Excel
EXPLANATION OVERVIEW What is VBA? Explanation of what is VBA
EXPLANATION OVERVIEW What is the VBA Editor? Explanation about the VBA Editor
EXPLANATION OVERVIEW What is the Title Bar? Explanation about the Title Bar
EXPLANATION OVERVIEW What is the Formula Bar? Explanation about the Formula Bar
EXPLANATION OVERVIEW What is the Quick Access Toolbar? Explanation about the Quick Access Toolbar
EXPLANATION OVERVIEW What is the Developer tab? Explanation about the Developer tab
OTHER CONVERT Convert negative numbers to positive How to convert negative numbers to positive numbers
OTHER CONVERT Convert positive numbers to negative How to convert positive numbers to negative numbers
OTHER CONVERT Convert text to numbers To convert text to number you can apply the Excel VALUE function
OTHER CONVERT Change only negative numbers to zero How to change only the negative numbers to zero
OTHER CONVERT Change only positive numbers to zero How to change only the positive numbers to zero
OTHER MULTIPLY Multiply a range of cells by same number How to multiply a range of cells by the same number
OTHER DIVIDE Divide a range of cells by same number How to divide a range of cells by the same number
OTHER ADD Add same number to a range of cells How to add the same number to a range of cells
OTHER ADD Add value to beginning of a cell How to concatenate a value to the beginning of a cell
OTHER ADD Add value to end of a cell How to concatenate a value to the end of a cell
OTHER SUBTRACT Subtract same number from a range of cells How to subtract the same number from a range of cells
OTHER WEBSITE Open a web page How to open a web page using VBA
OTHER WEBSITE Return domain name from URL How to return a domain name from a url using Excel and VBA
OTHER VBA Create a Message Box How to create a message box using VBA
OTHER VBA Message Box referencing to a cell How to create a message box and display a value that is captured in a specific cell using VBA
OTHER VBA Add a new line in a Message Box How to add a new line in a message box using VBA
OTHER VBA Change Message Box title How to change the title in the message box through the use of VBA
OTHER VBA Check if workbook is open How to check if a specific workbook is open through the use of VBA
OTHER VBA Check if workbook is open, if closed open workbook How to check if a specific workbook is open and if it's closed then open the workbook through the use of VBA
OTHER VBA Assign a macro to a button How to assign a macro to a button
OTHER VBA Delete all Pictures and Objects in a workbook How to delete all pictures and objects from an entire workbook at once through the use of VBA
OTHER VBA Delete all Pictures in a sheet How to delete only pictures in a specific sheet at once through the use of VBA
OTHER VBA Delete all Pictures in a workbook How to delete only pictures from an entire workbook at once through the use of VBA