Back
Information Technology
Excel 2016 - Part 1
What You'll Learn
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
Description
Are you looking to become a proficient Excel user? Professional Excel training from New Horizons can get you on the path to mastering this popular data spreadsheet software.
Through completing the introductory Excel 2016 training course, you’ll develop foundational data manipulation knowledge and skills that you can build upon through additional training and use. With the Excel 2016 - Part 1 course under your belt, you’ll feel confident using one of the world’s most powerful applications.
Who Should Attend
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.
Course Overview
Are you looking to become a proficient Excel user? Professional Excel training from New Horizons can get you on the path to mastering this popular data spreadsheet software.
Through completing the introductory Excel 2016 training course, you’ll develop foundational data manipulation knowledge and skills that you can build upon through additional training and use. With the Excel 2016 - Part 1 course under your belt, you’ll feel confident using one of the world’s most powerful applications.
Course Prerequisites
No results found.
Course Agenda
6 Title
Course Agenda
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
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
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
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
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
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
Create, Apply or Delete Workbook and Worksheet Views