Students will learn to move and copy data, learn about absolute and relative references, and work with ranges, rows, and columns. They will also learn how to navigate worksheets and workbooks. Then they will enter and edit text, values, formulas, and pictures, and they will save workbooks. This course also covers simple functions used in formulas (including SUM, AVERAGE, and COUNT), basic conditional formatting techniques, printing, inserting screen shots, and working with large spreadsheets. Finally, students will create and modify charts.Course Content Lesson 1: Getting Started with Microsoft ExcelTopic A: Navigate the Excel User InterfaceTopic B: Use Excel CommandsTopic C: Create and Save a Basic WorkbookTopic D: Enter Cell DataTopic E: Use Excel HelpLesson 2: Performing CalculationsTopic A: Create Worksheet FormulasTopic B: Insert FunctionsTopic C: Reuse Formulas and FunctionsLesson 3: Modifying a WorksheetTopic A: Insert, Delete, and Adjust Cells, Columns, and RowsTopic B: Search for and Replace DataTopic C: Use Proofing and Research ToolsLesson 4: Formatting a WorksheetTopic A: Apply Text FormatsTopic B: Apply Number FormatsTopic C: Align Cell ContentsTopic D: Apply Styles and ThemesTopic E: Apply Basic Conditional FormattingTopic F: Create and Use TemplatesLesson 5: Printing WorkbooksTopic A: Preview and Print a WorkbookTopic B: Set Up the Page LayoutTopic C: Configure Headers and FootersLesson 6: Managing WorkbooksTopic A: Manage WorksheetsTopic B: Manage Workbook and Worksheet ViewsTopic C: Manage Workbook Properties
Overview
Taught by
Computer Training Source, Inc.
