COURSE BREAK DOWN
UNIT ONE
Preparing and Formatting Worksheets
Week 1 9/3: Preparing an Excel Workbook
You will learn how to navigate through Excel and create a basic workbook.
Week 2 9/9: Inserting Formulas in a Worksheet
You will learn how to create simple formulas and insert functions in a worksheet.
Week 3 9/16: Formatting a Worksheet
You will learn how to apply additional types of formatting including themes to a worksheet.
Week 4 9/23: Enhancing a Worksheet
You will learn how to enhance and control the formatting of a worksheet.
UNIT TWO
Enhancing the Display of Workbooks
Week 5 9/30: 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/7: 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/14: Mid-Term - Review and Practices