Newest blog posts about Excel

­
  • excel match function

How to Use The Excel Function MATCH for Excel 2016

How to Use The Excel Function MATCH for Excel 2016 If you have ever needed the position of an item in a range rather than the actual item itself, you could use the ‘MATCH’ function. This can be very useful, for instance, when you need the ‘row_num’ parameter for the ‘INDEX’ function. ‘MATCH’ is [...]

  • RIGHT, LEFT, MID, LEN (Spreadsheeto)

The Text Functions: LEFT, RIGHT and MID (also LEN!)

The Excel Text Functions: LEFT, RIGHT and MID (also LEN!) Have you ever needed to pull just the first several digits or characters from a string in a particular cell? Maybe you needed just the last 4 characters in a column of cells.  Maybe you needed neither, but rather the characters or digits right [...]

  • VLOOKUP Featured Blog Image

The Last Guide to VLOOKUP You’ll Ever Need

VLOOKUP is one of the most well-known Excel functions – and not without reason. VLOOKUP’s ease of use and simplicity when “looking up” data is unparalleled in Excel. In this tutorial you'll learn how to create and troubleshoot a VLOOKUP.

  • Drop Down Featured Blog Image

The 1 Minute Drop-Down: How To Easily Create A Drop-Down List in 60 seconds (or less)

The drop-down list is a great way to look like a superuser and impress your co-workers and boss. At the same time, it’s a very user-friendly asset in almost all custom-made Excel sheets. In this tutorial, we're going to show you the 5 steps to create a drop-down in 1 minute or less. We call it the “1 Minute Drop-Down”.

  • 69 excel bloggers featured image

Top 69 Blogs In The World For Learning Excel

These Are The 69 World's Best Excel Blogs That Will Teach You Everything About Spreadsheets If you are looking for practical, in-depth educational blogs about Excel, you've come to the right place. Here are the top 69 best blogs to learn everything about Excel. As you already know, there's no shortage of awesome [...]

  • 6 New Charts in Excel Featured Blog Image

6 New Amazing Charts in Excel 2016 That Will Make You Look Like a Pro (infographic)

With the release of Excel 2016, several new features were added. Among these 6 new charts! We've created an infographic, showcasing each of the new charts and how you can benefit from using them.

  • Conditional Formatting Featured Blog Image

Conditional Formatting: 15 Easy Tips To Make Your Data Beautiful

Conditional formatting takes the layout and design options for your Excel sheet to the next level. Not only does it make your spreadsheet look awesome, it also enables you to make sense of your data and spot important cues in the blink of an eye. In this tutorial, we'll show you 15 step-by-step tips to conditional formatting.

  • Index Match with Multiple Criteria Featured Blog Image

How to Use INDEX+MATCH With Multiple Criteria in 5 Easy Steps

In this tutorial, you'll learn to use the MATCH INDEX functions with multiple criteria by following 5 easy steps. In the end, you'll have built a tool to search through your spreadsheet for information that you define. Don't miss this one!