Week 1 1/26: Preparing an Excel Workbook
You will learn how to navigate through Excel and create a basic workbook.
Week 2 2/2: Inserting Formulas in a Worksheet
You will learn how to create simple formulas and insert functions in a worksheet.
Week 3 2/9: Formatting a Worksheet
You will learn how to apply additional types of formatting including themes to a worksheet.
Week 4 2/16: Enhancing a Worksheet
You will learn how to enhance and control the formatting of a worksheet.
Week 5 2/23: Moving Data within and between Workbooks
You will learn how to create a workbook with several worksheets and complete tasks such as copying and pasting data within and between worksheets.
Week 6 3/2: Creating Charts and Inserting Formulas
You will learn how to create and customize charts in Excel. You will also learn how to write formulas using financial and logical functions.
Week 7 3/9: Mid-Term - Review and Practices