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
Effectively use formatting techniques to present data in an Excel spreadsheet. Focus on presenting beautiful spreadsheets.
Learn a variety of Excel features through this half-day workshop. The user will be introduced to pivot tables and pivot charts, lookup functions, auto outlines, subtotals, scenarios, financial functions, filters, and advanced tips and tricks.
Learn how to use the vast array of features and functionality contained within PowerPoint to create engaging, dynamic, multimedia presentations. Gain the skills you need to organize your content, enhance it with high-impact tables, charts, and graphics, and deliver it with a punch.
The course covers from basic to advance functions and features of Access. Students will learn how to design and create databases; work with tables, fields and records; sort and filter data; and create queries, data entry forms, multilevel reports, and multi-table queries.
Introduction to Microsoft Excel training empowers participants with key skills to create and edit worksheets, implement formulas and functions, and sort and filter detailed data with tables and slicers.
© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy