Blog of Tips, Tricks & Resources from New Horizons Central

When VLookup doesn’t cut: Try Index/Match

The Index Function is a function that finds a value in a dataset, but it doesn’t care about Unique Identifiers.

Nicole Winn 0 240

 

If you know the row, it’s a go. If you know the Column, no problem. The Match Function finds Rows and Finds Columns. So, when their powers combine…we find values. Remember the VLookup is a function within Excel that finds a value in a Dataset by looking at a Unique Identifier and then finding the appropriate value in adjacent columns to the right.

Power BI - Ways to Drill Down Into Your Data

Power BI has become an integral part of a lot of companies trying to find out not only what their information says, but what it means, especially in relation to predicting what comes next.

Nicole Winn 0 82

 

Let’s face it: these days, people need to get their information quickly, and they need to have it summarized so that people can easily read and interpret it. Charts allow users to summarize data very quickly and efficiently. And Power BI does a fantastic job of giving users plenty of options to organize your data.

Schedule short meetings by adjusting your Calendar view in Microsoft Outlook

Schedule short meetings by adjusting your Calendar view in Microsoft Outlook  You may find it difficult to schedule a short meeting because of Outlook’s default time scale setting.

Nicole Winn 0 421

 

Schedule short meetings by adjusting your Calendar view in Microsoft Outlook  You may find it difficult to schedule a short meeting because of Outlook’s default time scale setting. Instead of...

RSS

Theme picker

Loader