Course Details
Course Outline
1 - Getting Started with Excel 2016
Navigate the Excel User InterfaceUse Excel CommandsCreate and Save a Basic WorkbookEnter and Edit Cell DataFill Cells with Series of Data (AutoFill and Flash Fill)Use Excel Help
2 - Performing Calculations
Create Worksheet FormulasInsert Functions and use AutocompleteReuse Formulas and FunctionsCreate an Absolute Reference
3 - Modifying a Worksheet
Insert, Delete, and Adjust Cells, Columns, and RowsMove and Copy Data between CellsSearch for and Replace DataUse Spellcheck and Proofing
4 - Formatting a Worksheet
Apply Text FormatsApply Number FormatsAlign Cell ContentsApply and Copy Cell StylesApply Basic Conditional Formatting
5 - Printing Workbooks
Preview and Print a WorkbookControlling Page LayoutAdding Headers and FootersSet Print Titles and Print Ranges
6 - Managing Workbooks
Manage WorksheetsInsert and Delete WorksheetsManage Workbook and Worksheet ViewsManage Workbook Properties
Actual course outline may vary depending on offering center. Contact your sales representative for more information.
Who is it For?
Target Audience
To ensure success, students will need to be familiar with using personal computers and should have experience using a keyboard and mouse. Students should also be comfortable working in the Windows 10 environment and be able to manage information on their computers.