In this Introduction to Microsoft Excel 2016 training course, students will create and edit basic worksheets and workbooks. This course is designed for students who want to gain the necessary skills to create, edit, format, and print basic Microsoft Excel 2016 worksheets.
In this Introduction to Microsoft Excel 2016 training course, students will create and edit basic worksheets and workbooks. This course is designed for students who want to gain the necessary skills to create, edit, format, and print basic Microsoft Excel 2016 worksheets.
Course Outline
Module 1: Creating A Microsoft Excel Workbook
This module explains how to create workbooks in Microsoft Excel.
Starting Microsoft Excel
Creating a Workbook
Saving a Workbook
The Status Bar
Adding and Deleting Worksheets
Copying and Moving Worksheets
Changing the Order of Worksheets
Splitting the Worksheet Window
Closing a Workbook
Creating a Microsoft Excel Workbook
Module 2: The Ribbon
This module explains how to work with the ribbon.
Tabs
Groups
Commands
Exploring the Ribbon
After completing this module, students will be able to:
Work with tabs.
Work with groups.
Work with commands.
Understand which groups and commands are found on which tabs.
Module 3: The Backstage View (The File Menu)
This module explains how to work with the Backstage View, aka the File menu.
Introduction to the Backstage View
Opening a Workbook
New Workbooks and Excel Templates
Printing Worksheets
Adding Your Name to Microsoft Excel
Managing Workbook Versions
Open a Workbook
Select, Open and Save a Template Agenda
Print a Worksheet
Module 4: The Quick Access Toolbar
This module explains how to work with the Quick Access Toolbar.
Adding Common Commands
Adding Additional Commands with the Customize Dialog Box
Adding Ribbon Commands or Groups
Placement
Customize the Quick Access Toolbar
Module 5: Entering Data In Microsoft Excel Worksheets
This module explains how to enter data into Excel worksheets.
Entering Text
Expand Data across Columns
Adding and Deleting Cells
Adding an Outline
Adding a Hyperlink
Add WordArt to a Worksheet
Using AutoComplete
Entering Numbers and Dates
Using the Fill Handle
Entering Text and Using AutoComplete
Entering Numbers and Dates
Module 6: Formatting Microsoft Excel Worksheets
This module explains how to format Excel worksheets.
Hiding Worksheets
Adding Color to Worksheet Tabs
Adding Themes to Workbooks
Adding a Watermark
The Font Group
The Alignment Group
The Number Group
Customize a Workbook Using Tab Colors and Themes
Working with Font Group Commands
Working with Alignment Group Commands
Working with Number Group Commands
Module 7: Using Formulas In Microsoft Excel
This module explains how to use formulas in Excel.
Math Operators and the Order of Operations
Entering Formulas
AutoSum (and Other Common Auto-Formulas)
Copying Formulas and Functions
Relative, Absolute, and Mixed Cell References
Working with Formulas
After completing this module, students will be able to:
Enter the basic formulas.
Use AutoSum to sum data with one click.
Understand absolute, relative, and mixed cell references.
Copy formulas and functions.
Module 8: Working With Rows And Columns
This module explains how to work with rows and columns.
Insert lesson titles in a bulleted list
Inserting Rows and Columns
Deleting Rows and Columns
Transposing Rows and Columns
Setting Row Height and Column Width
Hiding and Unhiding Rows and Columns
Freezing Panes
Working with Rows and Columns
Module 9: Editing Worksheets
This module explains how to edit worksheets.
Find
Find and Replace
Using the Clipboard
Managing Comments
Using Find and Replace
Using the Clipboard
Module 10: Finalizing Microsoft Excel Worksheets
This module explains how to finalize worksheets.
Setting Margins
Setting Page Orientation
Setting the Print Area
Print Scaling (Fit Sheet on One Page)
Printing Headings on Each Page/Repeating Headers and Footers
Headers and Footers
Preparing to Print
Module 11: Microsoft Excel Features That Were New In 2013
This module explains how to use some of the features that were new in the 2013 version of Excel.
One Workbook Per Window Feature
Using Flash Fill
Module 12: New Features In 2016
This module explains how to use two new features in 2016.
Tell Me
Smart Lookup
Integra offers management skills certification training that will prepare you at all career levels to achieve in-demand, industry-recognized certifications. Learn from industry experts and increase your marketability through various methodologies and best practices that are essential in today’s competitive environment.
Choosing proper training is often difficult, but our clients appreciate how Integra Computer Training customize our courses. We assess the training needs of our students based on their computer skills proficiency to assist managers in identifying the training required for their employees.
Courses are delivered by certified Microsoft Office Specialists
We can also travel to on-site classes and set-up our laptops for classroom-style training
Our flexible courses are offered for beginners, intermediate and advanced levels
Experience real-world and practical hands-on learning
Master typography essentials, like controlling font, paragraphs, page breaks, and simple typography settings in Microsoft Word. Each level is a one-day course.
Access is Microsoft's flagship database application that allows you to create and manage databases for all sorts of different purposes. Access incorporates many features and connectivity options in order to make databases more accessible to the everyday user.
Do you want to take your Microsoft Access skills to the next level? In this course, you'll master more advanced techniques for this powerful database program and build an entire database project from scratch.
???????Take the best PowerPoint training online. Most computer training companies offer two PowerPoint courses, Level 1 and Level 2, that require two separate days of training.
MS Word course is offered by Edge Skills Centre Inc. The mission of EDGE Skills Centre is to inspire, prepare and empower our clients to improve the quality of their lives and to achieve their personal goals through the provision of current and effective language
© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy