Build Faster Excel Workflows Using FILTER, IFS, XLOOKUP, and LET for Real-World Data

Learn the difference between Excel COUNT and COUNTA, plus TEXTBEFORE and TEXTAFTER tricks, so you clean text and totals with ...
How-To Geek on MSN

Stop manually hiding Excel rows and columns for meetings: Use this hidden tool instead

Excel's Custom Views tool lets you create a snapshot of your spreadsheet, allowing you to toggle between layouts.
How-To Geek on MSN

How to randomize rows in an Excel table without scrambling your data

Whether you're assigning random shifts, anonymizing a study, or shuffling a deck, randomizing rows in an Excel table manually ...
Visual Studio Magazine

Mastering SQL Server Indexing: What Every .NET Developer Needs to Know

At the upcoming Visual Studio Live! Las Vegas developer conference, SQL expert Denny Cherry will share essential indexing ...