Posts

Post has attachment

INDEX and MATCH | Exceljet http://bit.ly/2kAmlbk

Combining functions is the key to more advanced formulas in #Excel, and INDEX + MATCH is a great example. Lots of links and examples included.

Combining functions is the key to more advanced formulas in #Excel, and INDEX + MATCH is a great example. Lots of links and examples included.

Add a comment...

Post has attachment

A simple guide to #Excel custom number formats. Custom number formats are a powerful way to change how numbers look without actually changing any data. They are the key to automatic formatting in Excel. http://bit.ly/2ilHa9U

Add a comment...

Post has attachment

Public

How to make a floating bar chart. Like so many things in Excel, this chart needs a clever approach. http://bit.ly/2yfQGBe

Add a comment...

Post has attachment

Public

A good example of how to construct a more complicated formula step-by-step with helper columns and nesting. Features 4 functions: RAND, RANK, CEILING, and COUNTIF. Video is short, 4 minutes. http://bit.ly/2xZZd8Q

Add a comment...

Post has attachment

Public

#Excel formula: Simple currency conversion with VLOOKUP | Exceljet http://bit.ly/2wLGqMi

Add a comment...

Post has attachment

Public

Excel video: Excel formula errors and fixes | Exceljet http://bit.ly/2xLSceK

Real-life examples of Excel formula errors + simple fixes. 4 min video.

Real-life examples of Excel formula errors + simple fixes. 4 min video.

Add a comment...

Post has attachment

Public

How to make dependent dropdown lists in Excel http://bit.ly/2wJme1b

Dropdown lists are a special kind of data validation in Excel to let users choose from a list of predefined choices. They are easy to set up, and a good way to capture higher quality data in spreadsheets. By adding formulas, you can make the items in the dropdown change dynamically to suit the context - these are called "dependent dropdowns". This guide shows you how to set things up with a simple formula based on named ranges + the INDIRECT function.

Dropdown lists are a special kind of data validation in Excel to let users choose from a list of predefined choices. They are easy to set up, and a good way to capture higher quality data in spreadsheets. By adding formulas, you can make the items in the dropdown change dynamically to suit the context - these are called "dependent dropdowns". This guide shows you how to set things up with a simple formula based on named ranges + the INDIRECT function.

Add a comment...

Post has attachment

Public

New Data Validation Guide with a bunch of formula examples. DV = better data in Excel + dropdown menus.

Add a comment...

Post has attachment

Public

A short video (4 min) that shows how to build a dynamic chart that automatically adds new data, and highlights top and bottom values. This is an easy way to make a cool interactive chart for a dashboard or report. | Exceljet http://bit.ly/2tQEzYv

Add a comment...

Post has attachment

Public

Excel Chart Types | Exceljet http://bit.ly/2sH70rZ

Working on a new resource for Excel charts. Still rough around the edges, but it's a start.

Working on a new resource for Excel charts. Still rough around the edges, but it's a start.

Add a comment...

Wait while more posts are being loaded