Excel Series: Tips for Productivity: Excel 2

Learn and master the following tips: importing data; opening multiple worksheets; formatting different worksheets together; referencing data from another worksheet; SUMIF formulas; data validation; conditional formatting; and using pivot tables.