Learning Objectives: Excel

Introduction to Excel

• Be able to format numerical data in Excel cells as a date or as currency.
• Increment dates using addition or the DATE function.
• Use basic formulas to perform calculations on data in the Excel spreadsheet.
• Use the auto-fill and lock ($) features to perform calculations over large ranges of cells.
• Create and format basic graphs.
• Name and recreate new sheets in an Excel workbook.

Statistics in Excel

Excel Cleaning and Pivot Tables