top of page
Recent Posts
![How to Highlight Cells Containing a Formula in Excel](https://static.wixstatic.com/media/2d24e3_d7e2bcf7779e439eae50f1b2ab6270db~mv2.png/v1/fill/w_293,h_201,fp_0.50_0.50,q_95,enc_auto/2d24e3_d7e2bcf7779e439eae50f1b2ab6270db~mv2.webp)
How to Highlight Cells Containing a Formula in Excel
To highlight any cell that contains a formula in an Excel workbook, there is a simple conditional formatting formula that can be used....
![How to Return the File Pathway of an Excel Workbook Using a Formula](https://static.wixstatic.com/media/2d24e3_76bc7988a3004b19bd5a40d863ceb348~mv2.png/v1/fill/w_294,h_145,fp_0.50_0.50,q_95,enc_auto/2d24e3_76bc7988a3004b19bd5a40d863ceb348~mv2.webp)
How to Return the File Pathway of an Excel Workbook Using a Formula
Sometimes you'll find yourself needing to pull a file's pathway into your Excel sheet. Luckily there is a quick formula we can use to...
![How to Use the CELL Function in Excel](https://static.wixstatic.com/media/2d24e3_902bee9277144b1a9e8a79d053f02f00~mv2.png/v1/fill/w_293,h_196,fp_0.50_0.50,q_95,enc_auto/2d24e3_902bee9277144b1a9e8a79d053f02f00~mv2.webp)
How to Use the CELL Function in Excel
The CELL function is a useful tool that allows you to retrieve specific information about a cell's formatting, location, and content....
![Creating Fully Playable Yahtzee in Excel](https://static.wixstatic.com/media/2d24e3_15c50e1ec4a541a8a8cd3530079d166c~mv2.png/v1/fill/w_293,h_220,fp_0.50_0.50,q_95,enc_auto/2d24e3_15c50e1ec4a541a8a8cd3530079d166c~mv2.webp)
Creating Fully Playable Yahtzee in Excel
Contents: 1. Download 2. How to Play 3. How Does it Work? 3.1 Dice Display 3.2 Rolling & Freezing Dice 3.3 Score Keeping & Entry 3.4 Turn...
![How to Return the ASCII Number for Every Character in a Cell](https://static.wixstatic.com/media/2d24e3_4279297431fd4482a878364faeb7c54c~mv2.png/v1/fill/w_294,h_218,fp_0.50_0.50,q_95,enc_auto/2d24e3_4279297431fd4482a878364faeb7c54c~mv2.webp)
How to Return the ASCII Number for Every Character in a Cell
The formulas below will take any text input and return the ASCII value of each character that comprises that string. Contents: 1....
![How to Use the CODE Function](https://static.wixstatic.com/media/2d24e3_902bee9277144b1a9e8a79d053f02f00~mv2.png/v1/fill/w_293,h_196,fp_0.50_0.50,q_95,enc_auto/2d24e3_902bee9277144b1a9e8a79d053f02f00~mv2.webp)
How to Use the CODE Function
The CODE function will return the ASCII value of the first character from any text string. Contents: 1. Syntax 2. Explanation 3. Examples...
![How to Round a Date to the First of the Next Month](https://static.wixstatic.com/media/2d24e3_a69d729a3994476cb1104dd68d572e66~mv2.png/v1/fill/w_293,h_220,fp_0.50_0.50,q_95,enc_auto/2d24e3_a69d729a3994476cb1104dd68d572e66~mv2.webp)
How to Round a Date to the First of the Next Month
Contents: Formula Explanation Example - Rounding Dates to First of the Next Month Formula = EOMONTH(date, 0) + 1 By feeding any date into...
![How to Round a Date to the First of the Previous Month](https://static.wixstatic.com/media/2d24e3_98bb6530bcdd47378f347ada5a7e5960~mv2.png/v1/fill/w_294,h_220,fp_0.50_0.50,q_95,enc_auto/2d24e3_98bb6530bcdd47378f347ada5a7e5960~mv2.webp)
How to Round a Date to the First of the Previous Month
Contents: Formula Explanation Example - Rounding Dates to the First of the Previous Month Formula = EOMONTH(date, -2) + 1 By feeding any...
![How to use the LOG Function](https://static.wixstatic.com/media/2d24e3_d206f6bf3bb0438388e3ce980f5e1f17~mv2.png/v1/fill/w_293,h_220,fp_0.50_0.50,q_95,enc_auto/2d24e3_d206f6bf3bb0438388e3ce980f5e1f17~mv2.webp)
How to use the LOG Function
The LOG function will calculate the logarithm of any given number to a specified base. Contents: 1. Syntax 2. Explanation 3. Examples...
![How to use the LN Function](https://static.wixstatic.com/media/2d24e3_7d5fe45e93ba46e093923ea996f6a2f5~mv2.png/v1/fill/w_293,h_220,fp_0.50_0.50,q_95,enc_auto/2d24e3_7d5fe45e93ba46e093923ea996f6a2f5~mv2.webp)
How to use the LN Function
The LN function will calculate the natural logarithm of any given number. Contents: 1. Syntax 2. Explanation 3. Examples 3.1. Calculating...
![How to use the GCD Function](https://static.wixstatic.com/media/2d24e3_928d60a80b8445b597eede52b0b91cb1~mv2.png/v1/fill/w_294,h_220,fp_0.50_0.50,q_95,enc_auto/2d24e3_928d60a80b8445b597eede52b0b91cb1~mv2.webp)
How to use the GCD Function
The GCD function finds and returns the greatest common divisor (GCD) of two or more numbers. Contents: 1. Syntax 2. Explanation 3....
![How to Remove Date Data from a Time in Excel](https://static.wixstatic.com/media/2d24e3_f43987e871f04ba5901e724e768a5f2c~mv2.png/v1/fill/w_293,h_220,fp_0.50_0.50,q_95,enc_auto/2d24e3_f43987e871f04ba5901e724e768a5f2c~mv2.webp)
How to Remove Date Data from a Time in Excel
Having dates associated with times in Excel can sometimes throw off time calculations. Luckily, there is an easy way to strip out date...
![How to Remove Time from a Date in Excel](https://static.wixstatic.com/media/2d24e3_a13d982dd3e24fab93c303abe44cc987~mv2.png/v1/fill/w_293,h_220,fp_0.50_0.50,q_95,enc_auto/2d24e3_a13d982dd3e24fab93c303abe44cc987~mv2.webp)
How to Remove Time from a Date in Excel
Having time associated with dates in Excel can sometimes throw off date calculations. Luckily, there is an easy way to strip out time...
![How to use the AVERAGE Function](https://static.wixstatic.com/media/2d24e3_978b771519494299be7ca13fe9b45e90~mv2.png/v1/fill/w_294,h_220,fp_0.50_0.50,q_95,enc_auto/2d24e3_978b771519494299be7ca13fe9b45e90~mv2.webp)
How to use the AVERAGE Function
The AVERAGE function returns the arithmetic mean of any set of numbers given to it. Contents: 1. Syntax 2. Explanation 2.1. Types of...
![How to use the DELTA Function](https://static.wixstatic.com/media/2d24e3_9b898aa55a854a8c83a13332752d722d~mv2.png/v1/fill/w_293,h_220,fp_0.50_0.50,q_95,enc_auto/2d24e3_9b898aa55a854a8c83a13332752d722d~mv2.webp)
How to use the DELTA Function
The DELTA function compares two numbers and returns a 1 if they are the same, and a 0 if they are not the same. Contents: 1. Syntax 2....
bottom of page