Excel 2016 - Part 1
Duration
1 Day
Price
190,00 €
Course Type
No Location
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.
Learning 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
-
-
-
Course Outline
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
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.