Microsoft Excel Level 3, Mini Session 2

SUMIF: to sum data based on a particular piece of data

SUMIFS: to sum data base on two particular pieces of data

DSUM: to sum a column based on a certain identifier

COUNT: to count numbers; COUNTIF: to count items; COUNTIFS; COUNTA; 

COUNTBLANK

Database Subtotals within a sorted database

            Sum, average, count, minimum or maximum 

FUNCTIONS: DAY, MONTH, YEAR, FIND, LEFT, RIGHT, RANK

Linking Worksheets

Text functions: for dates to appear a certain way

Advanced VLOOKUP

Click here to enroll in this Zoom session.