This tutorial explains the basics of the Excel HYPERLINK function and provides a few tips and formula examples to use it most efficiently.

Topics include:

• Excel HYPERLINK function - syntax and basic uses.
• How to use HYPERLINK in Excel - formula examples.
• Create hyperlinks to different items.
• VLOOKUP and insert a hyperlink to the first match.
• How to edit multiple HYPERLINK formulas at a time.
• Excel HYPERLINK not working - reasons and solutions.

New in Excel 2016 (for Office 365 subscription users only) are Map Charts.

Excel map charts can display your data encoded by:

• Values with a 2-color scale.
• Values with a 3-colour diverging scale.
• By category.

This article shows some examples of how to create and format Excel map charts.

This post poses a problem: create a unique list in Excel based on criteria. Rather than just presenting a solution, the author helpfully walks us through how to understand the complicated formula that solves the problem.

The key point is that if you find a formula online and simply copy / paste it without understanding how it works, you limit yourself from the power it has, and therefore, you limit the power that you have.

Here is a simple checklist to double check your Excel formulas work:

• Are you mixed up?
• Roughly know what your answer should be.
• Check the order of precedents or operations.
• Switch your view to show formulas.
• Ensure all formula arguments are accounted for.

This article provides a comprehensive guide to Excel's custom number formatting feature.

Topics include: creating and applying custom number formats, structure of custom number formats, placeholders, colors, text/labels, repeating text, and using symbols in custom number formats.

Understanding the order and precedence of operations in mathematical formulas or in an Excel Formula is very important.

Excel has a total 17 operators that you can use to build complex Excel formulas. Which operator will be evaluated first depends on the precedence of the operator.

This article describes the order of precedence for each of the Excel operators, including how to control the order using parentheses.

Dan Bricklin changed the world forever when he codeveloped VisiCalc, the first electronic spreadsheet and grandfather of programs you probably use every day like Microsoft Excel and Google Sheets.

Join the software engineer and computing legend as he explores the tangled web of first jobs, daydreams and homework problems that led to his transformational invention.

One of the nice features of Excel Tables is the banded row formatting, which makes it easier to read and scan your data.

Unfortunately Excel Tables aren't efficient with large data sets (over 100k rows), but we can replicate the banded rows with Conditional Formatting, and we can toggle it on and off at the click of a button, as shown in this blog.