Select Page

## Excel Shortcut Keys to Speed up Your Work

Navigation Shortcuts CTRL + LEFT/RIGHT/UP/DOWN: Move to the next populated cell CTRL + END: Move to the last populated cell CTRL + HOME: Return to Cell A1 CTRL + G: Go to a specific cell by entering the address CTRL + PAGE DOWN: Go to the next spreadsheet CTRL + PAGE...

## Count number of words in cell

Here is a quick solution for counting number of words in given cell. There is picture with example and belov is formula that you can paste into your Sheet, and just change cell that you want to count words. Example for getting number of words in cell A2:...

## Number of Saturdays in Month or Given Period

Number of Saturdays in Month or Given Period Here are a quick example how to determinate number of Saturdays for month or given period of time with excel formula. First in one cell, in our example it will be A1, put start time for desired period of time, then in...

## Get Current Workbook Path With Excel Formula

Get Current Workbook Path With Excel Formula If you have open Workbook and cant remember where it is on your HDD there are excel formula that can help you fast. =CELL(“filename”)...

## Generate a set of unique numbers in random order

Generate a set of unique numbers in random order To generate random numbers in Excel between 1 to 20, where none of the numbers repeat, we can use the excel function RAND(). In cell A1 type formula =RAND() and drag formula to cell A20. You will get a list of random...

## Split Text With Excel Formula Into Two Columns

Split Text With Excel Formula Into Two Columns To split text with excel function, you can use combination of four excel function. Here are list of function that we will use: LEFT RIGHT LEN FIND In cell A1 type text “Fuel+Car”. So we want to split text...