Microsoft Office Excel 2016 Foundation

Request more details:

Description:
This course aims to provide a foundation for Excel 2016 knowledge and skills, which you can build upon to eventually become an expert in data manipulation.
Prerequisites:
To ensure success, participants 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 environment and be able to use Windows to manage information on their computers.
Course Objectives:
Upon successful completion of this course, you will be able to create and develop Excel worksheets and workbooks in order to work with and analyze the data that is critical to the success of your organization.

You will:
Get started with Microsoft Office Excel 2016.
Perform calculations.
Modify a worksheet.
Format a worksheet.
Print workbooks.
Manage workbooks.
Getting Started with Microsoft Office Excel 2016 :
Navigate the Excel User Interface
Use Excel Commands
Create and Save a Basic Workbook
Enter Cell Data
Use Excel Help
Performing Calculations :
Create Worksheet Formulas
Insert Functions
Reuse Formulas and Functions
Modifying a Worksheet:
Insert, Delete, and Adjust Cells, Columns, and Rows
Search for and Replace Data
Use Proofing and Research Tools
Formatting a Worksheet :
Apply Text Formats
Apply Number Formats
Align Cell Contents
Apply Styles and Themes
Apply Basic Conditional Formatting
Create and Use Templates
Printing Workbooks :
Preview and Print a Workbook
Set Up the Page Layout
Configure Headers and Footers
Managing Workbooks :
Manage Worksheets
Manage Workbook and Worksheet Views
Manage Workbook Properties