Skip to content
TutorialsForExcel

TutorialsForExcel

Excel Guides and Templates

  • Home
  • How to Guides
  • Functions and Formulas
  • Free Excel Templates

The BITOR Function: Syntax and Examples

Posted on May 28, 2020June 5, 2020 by Elora K.

The BITOR is an Excel Engineering function that returns the bitwise OR of the two numbers. If you’re new to bitwise operations, I suggest reading this Wikipedia page. Note: This function was first introduced in 2013, so it won’t be available on previous versions of Excel. Syntax BITOR(number1, number2) Required Arguments [number1]: A decimal number… Read more The BITOR Function: Syntax and Examples

The BIN2HEX Function: Syntax and Examples

Posted on May 21, 2020May 21, 2020 by Elora K.

The BIN2HEX is an Excel engineering function that converts a binary number to a hexadecimal number. It is one of the oldest Excel functions, so it can be used even with Excel 2003. Note: Other conversion functions are BIN2DEC (binary to decimal), BIN2OCT (binary to octal) and HEX2BIN (hexadecimal to binary) Syntax BIN2HEX(number, [places]) Required… Read more The BIN2HEX Function: Syntax and Examples

The COUNT Function: Syntax and Examples

Posted on December 5, 2019December 5, 2019 by Elora K.
Count function examples and syntax

The COUNT is an Excel statistical function that counts how many numbers are in a list of arguments. It is one of the oldest Excel functions, so it can be used even with Excel 2003. Note: If you want to count logical values, text, or error values, use the COUNTA function. And for numbers that meet a… Read more The COUNT Function: Syntax and Examples

How to Freeze Rows and Columns in Excel

Posted on July 2, 2019July 2, 2019 by Elora K.
Freeze Rows in Excel

This is a quick tutorial on how to freeze rows in Excel. I know that most of you don’t need pointers with this, but if you’re new to Excel, keep reading to get familiar with the basics. This feature can come in handy when you have an Excel document that is so long that you… Read more How to Freeze Rows and Columns in Excel

The AVERAGE Function: Syntax and Examples

Posted on April 30, 2019April 30, 2019 by Elora K.
Excel AVERAGE FunctioN

The AVERAGE is an Excel statistical function that calculates the average of its arguments. It is one of the oldest Excel functions, so it can be used even with Excel 2003. Note: the AVERAGE will calculate the arithmetic average (adds up all the arguments and divides it with their count). If you need a median,… Read more The AVERAGE Function: Syntax and Examples

The PROPER Function: Syntax and Examples

Posted on April 22, 2019April 22, 2019 by Elora K.
Proper Function

The PROPER is an Excel text function that capitalizes the first letter in each word of a text value. Syntax PROPER(text) Required Arguments text: Text enclosed in quotation marks, a formula that returns text, or a reference to a cell containing the text you want to partially capitalize Proper Function Examples This function can be… Read more The PROPER Function: Syntax and Examples

The MAX Function: Syntax and Examples

Posted on February 27, 2019March 11, 2019 by Elora K.
Excel MAX function

The MAX is an Excel statistical function that returns the largest number in a set of values. It will ignore logical and text values. It is one of the oldest Excel functions, so it can be used even with Excel 2003. If you want to include logical values, you’ll need to use the MAXA function.… Read more The MAX Function: Syntax and Examples

The MIN Function: Syntax and Examples

Posted on February 14, 2019February 13, 2019 by Elora K.
MIN function

The MIN is an Excel statistical function that returns the smallest number in a set of values. It will ignore logical and text values. It is one of the oldest Excel functions, so it can be used even with Excel 2003. If you want to include logical values, you’ll need to use the MINA function.… Read more The MIN Function: Syntax and Examples

Pugh Matrix Template

Posted on February 14, 2019September 9, 2019 by Elora K.
Pugh Matrix Template

The Pugh Matrix is a decision-matrix method used to determine the best option out of an option set. It will score and rank each option against a baseline. If you are already familiar with the process, you can skip to the downloadable Excel Pugh Matrix template. Overview of the Pugh Matrix The Pugh Matrix was… Read more Pugh Matrix Template

The SUM Function: Syntax and Examples

Posted on February 13, 2019February 13, 2019 by Elora K.
SUM function

The SUM is an Excel math and trigonometry function that adds values together. It is one of the oldest Excel functions, so it can be used even with Excel 2003. SUM Syntax Required Arguments number1: This is the first number that you want to add. It can be a number, a cell reference or a… Read more The SUM Function: Syntax and Examples

Posts navigation

Page 1 Page 2 Page 3 Next page>
Skip to footer

Newsletter

Get all our latest templates and Excel tips straight to your inbox.

Recent Posts

  • The BITOR Function: Syntax and Examples
  • The BIN2HEX Function: Syntax and Examples
  • The COUNT Function: Syntax and Examples
  • How to Freeze Rows and Columns in Excel
  • The AVERAGE Function: Syntax and Examples

Find an Article

Tags

#NUM! #VALUE! 2019 excel template AND bcg matrix BIN2HEX boston matrix boston matrix template CHAR chart clustered column compare CONCAT CONCATENATE conditional formatting consignment invoice duplicates formula function function examples histogram IFERROR investment invoice IRR irregular intervals kpi MATCH math function matrix template OR pivot chart pivot table rail RANK rolling action item list SEARCH slicer sort sort & filter sum template to do list vlookup XIRR
Proudly powered by WordPress | Theme: Yocto by Humble Themes.