35 Excel Tips That Could Save You from Working All Night - Version 2.0 - Cuong Do, Berthold Trenkel-Bögle February 1 , 2001 INTRODUCTORY NOTE What is it: The following material was developed for the Seoul office training program.
Cuong Do, Berthold Trenkel-Bögle
Split screen icons1. SPLIT WINDOWS AND FREEZE PANES
Can sort by up to 3 categories, use drop lists to select fields, specify A-Z or Z-A
Number the columns to easily check your formulas
Define a name for cells in your data Range
Need to sort in ascending order for VLOOKUP function to work properly
Step 2: Select the relevant data area
Step 1: Microsoft Excel list
…or create your own icons!
Auto filter off – show all