Week 1 9/2: Preparing an Excel Workbook
You will learn how to navigate through Excel and create a basic workbook.
Week 2 9/8: Inserting Formulas in a Worksheet
You will learn how to create simple formulas and insert functions in a worksheet.
Week 3 9/15: Formatting a Worksheet
You will learn how to apply additional types of formatting including themes to a worksheet.
Week 4 9/22: Enhancing a Worksheet
You will learn how to enhance and control the formatting of a worksheet.
Week 5 9/29: 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 10/6: 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 10/13: Mid-Term - Review and Practices