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 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
It’s easy to hide columns in Excel but not always that easy to reveal them. Depending on what columns or rows you have hidden, there are four different options to bring them back again. 1. Unhide All Columns This is the easiest option for you if you want to unhide all columns in your sheet.… Read more How to Unhide Columns in Excel
Excel’s VLOOKUP function is a powerful and helpful function that can help filter your data down to a desired item. It is sort of a combination of database functionality and search engine ease to refine your spreadsheet’s content to some given search item. However, VLOOKUP for all of its powerful abilities can sometimes be frustratingly… Read more 8 Most Common VLOOKUP Errors
The BCG Matrix (also know as the Boston Matrix, growth-share matrix, product portfolio matrix, Boston Box, Boston Consulting Group analysis, portfolio diagram) is a chart that helps businesses analyse different products in their portfolio. If you are already familiar with the matrix, feel free to skip right to the end where we have a download link for the… Read more BCG Matrix Template
We’ve made a simple and professional looking 2019 invoice template available for everyone free of charge. Link to the Excel file is provided below. Although we have taken extra care to make sure the template is fully accurate, you should still proofread and check for discrepancies before sending it over to any customers. Should You… Read more Excel Consignment Invoice Template
An essential tool for many businesses and project leaders is the rolling action item list aka the RAIL. It is a simple tool for managing your to do list. What sets this apart from others is the possibility to rank and sort tasks based multiple factors. The best way to manage this type of task… Read more Excel Rail Template
A slicer in Excel is a user-friendly tool which allows to filter pivot tables. It is an advanced version of the standard filter option available for pivot tables. Apart from filtering a single pivot table, slicers are often used in dashboards for filtering several pivot tables and charts together. In this article, we will cover… Read more How to use Excel Slicers with PivotTables
Excel function XIRR is a financial function which returns the internal rate of return for a series of cash flows, occurring at irregular period intervals. The XIRR function includes an initial investment and net income values. This function is derived from the IRR function which does the same calculation but works only with regular (equal)… Read more Excel XIRR Function Examples
The CONCATENATE function in Excel enables a user to join two or more cells into one. We often need to join the first and last name into a full name or street, house number and city into a full address. One of the easiest ways to complete this is using the Concatenate function. In this tutorial,… Read more Excel Concatenate function examples and common errors
