MS Excel 2016 – Level 1
- Course covers basics of Excel 2016 for beginners.
- Delegates learn to create, edit worksheets and workbooks.
- Students should be familiar with using a computer.
- Objectives include exploring Excel, using formulas, formatting.
- Delegates will learn to manage worksheets and workbooks.
Overview
The Excel 2016 Training course is designed for individuals unfamiliar with Excel, aiming to teach basic functions of the application. Participants will learn to create and edit worksheets and workbooks, explore the Excel environment, use formulas and functions, format worksheets, manage files, and set up printing options. The course covers essential skills for entering data and organizing workbooks. Delegates should have basic computer knowledge and experience with a keyboard and mouse.
Who should attend
Delegates who are not familiar with Excel.
Course Content
Course Description
In this 1 day course you will create and edit basic Microsoft Excel 2016 worksheets and workbooks.
Who is this course for: Delegates who are not familiar with Excel and would like to learn the basic functions of the application.
Delegate Requirements:
Before starting this course, delegates should be familiar with using a computer and should have experience using a keyboard and mouse. Students should be comfortable with the Windows environment and be able to use Windows to manage information on their computers. Specific tasks students should be able to perform include; launching and closing applications, navigating basic file structures, and managing files and folders.
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
Description:
This Excel 2016 Level 1 (or introduction) course covers all the basics you need to start entering your data and building organised workbooks.
Delegates will be able to:
• Get started with Excel 2016
• Create a basic worksheet
• Modify a workbook
• Format an Excel worksheet
• Use formulas and functions
• Manage worksheets and workbooks
• Set up printing options
Course Content:
- Getting Started with Excel 2016
- Excel and the Excel Environment
- Back Stage view and Themes
- Navigate and Select in Worksheets
- Create a Basic Workbook
- Version History
- Open, Save and Close Workbooks
- Use Tell Me and Smart Lookup
- Modifying a Workbook
- Cut, Copy and Paste Commands
- Flash Fill
- AutoFill Options and AutoComplete
- Find and Replace
- 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
- Mixed Cell References
- AutoCalculate
- Inserting Functions
- Use AutoSum
- Copy Formulas
- Create Absolute Formulas
- Managing Worksheets and Workbooks
- Use Excel Quick Analysis Tools
- Worksheets
- View Worksheets and Workbooks
- Printing Options
- Print Pane
- Print Worksheets and Workbooks
- Page Setup
- Print Layout View
Duration:1 Day
Cost: £235 + VAT
Microsoft Excel 2016 Training Scotland, Inverness, Glasgow, Aberdeen, Edinburgh, Perth. Dunfermline and other sites throughout the UK including onsite closed company courses are available.
