MS Excel 2016 – Level 1
- Course focuses on creating and editing Excel worksheets and workbooks.
- Aims to teach basic Excel components and formula creation.
- Targeted at those needing basic Excel 2016 knowledge.
- Covers exploring Excel, basic formulas, and formatting.
- Includes managing worksheets, workbooks, and printing options.
Overview
This one-day online Microsoft Excel training course focuses on creating and editing basic Excel 2016 worksheets and workbooks. The aim is to enable participants to understand Excel components and use formulas effectively. Targeted at individuals needing fundamental Excel 2016 knowledge, the course covers exploring the Excel environment, creating worksheets, using formulas and functions, formatting worksheets, managing workbooks, and setting up printing options. Prerequisites include familiarity with using a computer in a Windows environment.
Who should attend
Anyone familiar with Windows environment.
Course Content
Course Duration: 1 day
Course
In this virtual, Instructor-Led course you will create and edit basic Microsoft Excel 2016 worksheets and workbooks. You will learn all the basics you need to start entering your data and building organised workbooks.
Course Aim
Enable delegates to examine the basic components of Excel 2016 and learn how to create and use formulas.
Target Student: Anyone requiring basic knowledge of Excel 2016.
Prerequisites:Delegates should be familiar using a computer/laptop within a Windows environment.
Objectives:
• explore the Excel Environment
• create a basic worksheet
• modify a workbook/worksheet
• use basic formulas and functions
• format an Excel worksheet
• manage worksheets and workbooks
• set up printing options
Getting Started with Excel 2016
• Excel and the Excel Environment
• Start up, Back Stage view and Themes
• Navigate and Select in Worksheets
• Create a Basic Workbook
• Open, Save and Close Workbooks
• Use Search and Smart Lookup
Modifying a Workbook
•Cut, Copy and Paste Commands
• Flash Fill
• AutoFill Options and AutoComplete
• Spelling
• Undo and Redo
• Insert and Delete Options
• Column Width and Row Height
• Hide and Unhide Options
Formatting an Excel Worksheet
•Font Group
• Add Borders and Fill Colours
• Cell Alignment
• Number Formatting
• Cell Styles and Galleries
Using Formulas and Functions
• Create Relative Formulas
• AutoCalculate
• Inserting Functions
• Use AutoSum
• Copy Formulas
• Create Absolute Formulas
Managing Worksheets and Workbooks
• Manage Worksheets
• View Worksheets and Workbooks
Printing Options
• Print Pane
• Print Worksheets and Workbooks
• Page Setup
• Print Layout View
Cost:£150 + Vat
Live Virtual Excel 2016 Training
Online Excel 2016 Training Course
Excel 2016 virtual training course.
Excel 2016 Online Training course.
MS Excel 2016 training
