Course Details
Course Outline
1 - Getting Started with Microsoft Office Excel 2016
Learn Your Way Around the Excel MenuUnderstand and Apply Excel FormulasCreate and Save a Basic WorkbookEnter Data Into CellsAccess Excel Help
2 - Performing Calculations
Build Custom Worksheet FormulasInsert Built-In Functions to Your DataSave and Reuse Formulas
3 - Modifying a Worksheet
Insert, Delete and Resize Cells, Columns and RowsSearch for and Replace Data Use Proofing and Research Tools
4 - Formatting a Worksheet
Format Text and NumbersAlign Cell DataApply Styles, Themes and Basic and Conditional FormattingCreate and Select Worksheet Templates
5 - Printing Workbooks
Preview and Print a WorkbookSet Up the Page LayoutConfigure Headers and Footers
6 - Managing Workbooks
Manage Worksheets and Workbook PropertiesCreate, Apply or Delete Workbook and Worksheet Views
Actual course outline may vary depending on offering center. Contact your sales representative for more information.
Who is it For?
Target Audience
If you’re interested in learning how to use Excel or responsible for creating spreadsheets or performing basic data manipulation, this course is perfect for you.
Prerequisites
Other Prerequisites
Your success in this course is our No. 1 concern. To get the most out of your Excel 2016 training, you should be comfortable using a personal computer, including a keyboard and mouse.
Experience in a Windows 10 environment will also set you up for success in this course. Ideally, you should know how to open and close applications, navigate basic file structures and manage files and folders.