EBP Plat{a|e}form{a|e}

These Excel functions just made PivotTables obsolete for me www.makeuseof.com/groupby-and-pivotby-versus-pivot-tables/ GROUPBY the one-axis wonder – Because who actually needs bells and whistles for basic summaries PIVOTBY the two-axis power move – The overachiever of data summaries Most Excel users are still using Pivot Tables, but this new function is faster www.makeuseof.com/pivotby-instead-of-pivot-tables/

Freeze Panes and Focus Cell. Never lose track of where you are Split View. Compare distant parts of your sheet side-by-side without scrolling Watch Window. Track the values that matter without jumping between sheets

We need to talk about the LAMBDA function in Excel www.makeuseof.com/we-need-to-talk-about-the-lambda-function-in-excel/

This tiny symbol in Excel changes everything (and most people ignore it): @ www.makeuseof.com/tiny-symbol-in-excel-changes-everything/

My 6 favorite Excel features that almost nobody talks about www.makeuseof.com/favorite-excel-features-that-almost-nobody-talks-about/ F4 to repeat your last action. The fastest way to apply formatting without touching your mouse The Filled Map. Turn location data into a real map in two clicks  Show All Formulas (Ctrl + `). One shortcut to audit a