Excel 2016 – Part 1
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 Objectives
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
Agenda
- 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
- Build Custom Worksheet Formulas
- Insert Built-In Functions to Your Data
- Save and Reuse Formulas
- Insert, Delete and Resize Cells, Columns and Rows
- Search for and Replace Data
- Use Proofing and Research Tools
- Format Text and Numbers
- Align Cell Data
- Apply Styles, Themes and Basic and Conditional Formatting
- Create and Select Worksheet Templates
- Preview and Print a Workbook
- Set Up the Page Layout
- Configure Headers and Footers
- Manage Worksheets and Workbook Properties
- Create, Apply or Delete Workbook and Worksheet Views
FREE
Interested in course?
Course Type: Instructor Led