MICROSOFT EXCEL

After an introduction to spreadsheet terminology and Excel’s window components, students will learn how to use the Help system and navigate worksheets and workbooks. Then they will enter and edit text, values, formulas, pictures and they will save workbooks in various formats.

Students will learn how to use multiple worksheets and workbooks efficiently, and they will start working with more advanced formatting options including styles, themes, backgrounds and watermarks. They will also learn how to create outlines and subtotals, how to create and apply cell names and how to work with lists and tables. Students will learn about data validation and database functions such as DSUM. They will learn how to work with PivotTables and Pivot Charts, how to import and export data, and how to query external databases.