Profile cover photo
Profile photo
Exceljet
331 followers -
Learn Excel faster with visually rich training resources
Learn Excel faster with visually rich training resources

331 followers
About
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.
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
Photo
Add a comment...

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

Post has attachment
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
#Excel formula: Simple currency conversion with VLOOKUP | Exceljet http://bit.ly/2wLGqMi
Add a comment...

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

Real-life examples of Excel formula errors + simple fixes. 4 min video.
Photo
Add a comment...

Post has attachment
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.
Photo
Add a comment...

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

Post has attachment
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
Photo
Add a comment...

Post has attachment
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.
Photo
Add a comment...
Wait while more posts are being loaded