Courses

Objective

• Explain how the Excel software is used;
• Start Excel;
• Identify the components of the Excel window;
• Describe a workbook and a worksheet;
• Navigate and select in a worksheet;
• Modify user options or preferences;
• Create and save a workbook;
• Enter, edit, and format text and numbers;
• Create basic formulas and use functions;
• Work in different worksheet views;
• Preview and print a worksheet;
• Work in Backstage view; and
• Use the Quick Access Toolbar, the ribbon, Excel Help, the Tell Me feature, the Smart Lookup feature, shortcut menus, and keyboard shortcuts to perform tasks.

Highlights

• Lesson 1: identify ways to start Excel, recognize Excel Start screen elements including the Blank Workbook template, recognize Excel window elements, select Backstage view to open an existing workbook, identify worksheet navigation methods, select worksheet cells, rows, and columns, identify and select Excel user preferences, identify ways to get help in Excel, select methods to save and close a workbook, select methods to create a new workbook, select methods to close one or more workbooks, and select methods to close Excel
• Lesson 2: identify ways to insert, reposition, select, delete, and rename worksheets, recognize ways to enter, edit, and format cell contents, select ways to create formulas, identify functions, identify ways to apply Accounting and Percent Style formatting, and select Flash Fill for data entry
• Lesson 3: identify ways to show and hide worksheet elements, select methods to undo and redo an action, recognize ways to switch between Normal view, Page Layout view and Page Break Preview, and select page setup options, preview and print options

Designed For

Prerequisite

Advanced Preparation