Excel 2016 - Level 1

Once you complete this course, you’ll be able to create and develop Excel worksheets and workbooks so you can begin to analyze critical business data.
This course empowers you to:

• Write a range of fundamental Excel commands
• Perform worksheet calculations
• Build custom formulas
• Amend elements in a worksheet
• Apply formatting changes to cells
• Manage workbook properties

1 - GETTING STARTED WITH MICROSOFT OFFICE EXCEL 2016

• Learn Your Way Around the Excel Menu
• Understand and Apply Excel Formulas
• Create and Save a Basic Workbook
• Enter Data Into Cells
• Access Excel Help

2 - PERFORMING CALCULATIONS

• Build Custom Worksheet Formulas
• Insert Built-In Functions to Your Data
• Save and Reuse Formulas

3 - MODIFYING A WORKSHEET

• Insert, Delete and Resize Cells, Columns and Rows
• Search for and Replace Data
• Use Proofing and Research Tools

4 - FORMATTING A WORKSHEET

• Format Text and Numbers
• Align Cell Data
• Apply Styles, Themes and Basic and Conditional Formatting
• Create and Select Worksheet Templates

5 - PRINTING WORKBOOKS

• Preview and Print a Workbook
• Set Up the Page Layout
• Configure Headers and Footers

6 - MANAGING WORKBOOKS

• Manage Worksheets and Workbook Properties
• Create, Apply or Delete Workbook and Worksheet Views