Helpful Tips Blog

Excel Tips

Conditional Statistics in Excel

If you're an Excel user, you've probably used the SUM function. It's fairly simple. The following formula returns the sum of all values in the range of cells in Column A from rows 4 through 1799: =Sum(A4:A1799) Sometimes you need to sort your data before you can get...

read more

Excel Legacy Shortcuts

The following table is a list of Alt-Key shortcuts that still work with current versions of Excel. File Menu Alt+F New Alt+F-N Open Alt+F-O Close Alt+F-C Save Alt+F-S Save As Alt+F-A Print Preview Alt+F-V Print Alt+F-P Send To Alt+F-D Edit Menu Alt+E Undo Alt+E-U Cut...

read more

How Can You Sort Data In Excel?

Arranging your data alphabetically, from smallest to largest numerically, or using other criteria can help you find the information you're looking for more quickly. Select a cell in the column you want to sort and on the Data tab, in the Sort & Filter group,...

read more