How-To Geek on MSN

Document formulas in Excel like code with N() function

The simplest way to start documenting Excel formulas like a coder is by using the N () function. Although its primary job is to convert non-numeric values into numbers, it has a hidden quirk: because ...
How-To Geek on MSN

6 time-saving Excel UI tips I wish I knew sooner

Alt > A > P > T: Open the Power Query window with data from the selected Excel table. Constants: This is the fastest way to ...