learning — Blog — Excellency

All Posts - Office Guides - Skills & Tools

Posts tagged learning

XLOOKUP: Just One More Reason Microsoft365 Is Worth The Cost!

XLOOKUP is a new function Microsoft has begun to integrate into their 365 subscription platform. This function looks to replace the likes of VLOOKUP and the INDEX/MATCH format. How does it hold up in comparison? Is it worth upgrading to Microsoft365? Download a free Excel workbook to test out the differences between all three functions!

Office GuidesMatthew Di MinnoJuly 20, 2020analysis, data, Problems, datasets, Excel, Efficiency, formatting, guides, Guides, improvement, skills, Learning, learning, tool, reporting, software, tools, Analytics, xlookupComment

Watch Window: Save Yourself the CTL + Page Up/Down

One hidden gem of a tool in Excel allows you to see the formulas and outputs of cells across sheets, making work and validation easier than ever before!

Office GuidesMatthew Di MinnoApril 27, 2020Excel, 365, watch, window, tool, efficiency, audit, data, manipulation, learning, Efficiency, Guides, improvementComment

Nested IF(S): A Guide to Decision Tree Logic in Excel

The IF function is one of the first that many people learn. It can be even more powerful when used with a more intricate decision logic structure!

Office GuidesMatthew Di MinnoMarch 23, 2020Excel, improvement, Guides, tools, conditional, data, Efficiency, formatting, learning, skills, manipulation, Problems, AnalyticsComment