Excel ll – Fill Downs, Sorting, Functions, and More
1
TABLE OF CONTENTS
Number Formats ........................................................................................................................................................4
Auto Fill and Flash Fill .................................................................................................................................................5
Simple Repeat .........................................................................................................................................................5
Fill Down Common Series .......................................................................................................................................5
Fill Down Custom Series .........................................................................................................................................5
Flash Fill Series ........................................................................................................................................................5
Sorting ........................................................................................................................................................................7
Basic Sorting – Single Column ................................................................................................................................7
Sort Multiple Columns ............................................................................................................................................7
Sort Custom Order ..................................................................................................................................................7
Filtering .......................................................................................................................................................................8
Filtering by Value ....................................................................................................................................................8
Multiple Filters .......................................................................................................................................................8
Conditional Filtering ...................................................................................................................................................9
Basic Functions and Formula Development ............................................................................................................ 10
Formula Basics ..................................................................................................................................................... 10
Formula Syntax .................................................................................................................................................... 10
Referencing Cell Ranges in Formulas .................................................................................................................. 10
Common Functions .................................................................................................................................................. 11
Sum ...................................................................................................................................................................... 11
Average ................................................................................................................................................................ 11
Min....................................................................................................................................................................... 11
Max ...................................................................................................................................................................... 11
CountIF, CountIFS ................................................................................................................................................ 11
Formulas - Absolute Cell Referencing ..................................................................................................................... 12
Formulas and Autofill .......................................................................................................................................... 12
Formulas with Absolute Referencing .................................................................................................................. 12
Paste Special ............................................................................................................................................................ 13
Pasting Individual Attributes ............................................................................................................................... 13
Formats ................................................................................................................................................................ 13
Values .................................................................................................................................................................. 13
Formulas .............................................................................................................................................................. 13