In this hands-on, two-day course, you will be able to create and develop Excel worksheets and workbooks in order to work with and analyze the data that is critical to the success of your organization. You will move into more advanced features that will allow you to leverage the power of data analysis and presentation in order to make informed, intelligent organizational decisions.
Duration: 2 Days
Locations for Training:
Microsoft Office Specialist (MOS) Certification: The Microsoft Office Specialist (MOS) certification is the premier credential chosen by individuals seeking to validate their Office skills and advance their careers. If you become a Microsoft Office Specialist in Excel, consider adding our Microsoft Excel MOS Certification Pack to your training class.
Microsoft Excel for Office 365/2021 Introduction MOS Certification Pack Includes:
If you choose the Certification Pack option in the pricing dropdown upon checkout, this Includes:
✓ Microsoft Excel for Office 365/2021 Introduction (2 Day Class, Virtual Online Live Training–VOLT™)
✓ Online Test Prep Tool (Simulates actual test using your local installation of the application & provides targeted learning based on your assessed needs)
✓ Exam Voucher with 1 Free Retake (Scheduled at your convenience)
✓ Testing Proctor Fee (Only included if you take your test Online from home with ThinkB!G)
Note: This course covers the following Course Numbers:
• Excel Part 1 Course Number: 091078
• Excel Part 2 Course Number: 091079
Prerequisites: Students must have a good working knowledge of computers, operating systems, using a mouse, keyboard, standard menus and commands. Students must be able to open, save, and close applications and files, as well as navigate to other folders.
1. Getting Started with Microsoft Office Excel
Navigate the Excel User Interface
Use Excel Commands
Create and Save a Basic Workbook
Enter Cell Data
Use Excel Help
2. Performing Calculations
Create Worksheet Formulas
Insert Functions
Reuse Formulas
3. Modifying a Worksheet
Insert, Delete, and Adjust Cells, Columns, and Rows
Search for and Replace Data
Use Proofing and Research Tools
4. Formatting a Worksheet
Apply Text Formats
Apply Number Formats
Align Cell Contents
Apply Styles and Themes
Apply Basic Conditional Formatting
Create and Use Templates
5. Printing Workbooks
Preview and Print a Workbook
Set Up the Page Layout
Configure Headers and Footers
6. Managing Workbooks
Manage Worksheets
Manage Workbook and Worksheet Views
Manage Workbook Properties
7. Working with Functions
Work with Ranges
Use Specialized Functions
Work with Logical Functions
Work with Date & Time Functions
Work with Text Functions
8. Working with Lists
Sort Data
Filter Data
Query Data with Database Functions
Outline and Subtotal Data
9. Analyzing Data
Create and Modify Tables
Apply Intermediate Conditional Formatting
Apply Advanced Conditional Formatting
10. Visualizing Data with Charts
Create Charts
Modify and Format Charts
Use Advanced Chart Features
11. Using PivotTables and PivotCharts
Create a PivotTable
Analyze PivotTable Data
Present Data with PivotCharts
Filter Data by Using Timelines and Slicers
Disclaimer: All course objectives and outlines are used as a guideline and are subject to change to ensure the latest information is covered to support real world use of the technology.
Software Versions: ThinkB!G open enrollment classes are taught on the most current version of software whenever possible. To request a specific version, please Contact Us or call us at 301-362-2250.
The Microsoft Office Specialist (MOS) Certification demonstrates that you have the skills needed to get the most out of Office by earning this certification in a specific Office program.
If you choose the Certification Pack option in the pricing dropdown upon checkout, this Includes:
✓ Training Based on Exam Objectives (2 Day Class, Virtual Online Live Training–VOLT™)
✓ Online Test Prep Tool (Simulates actual test & provides targeted learning based on your assessed needs)
✓ Exam Voucher with 1 Free Retake (Scheduled at your convenience)
✓ Testing Proctor Fee (Only included if you take your test Online from home with ThinkB!G)
If you have a team of individuals, you can receive bulk discounts by doing your own Private training session & cover your specific learning objectives!
The entire process was very well-organized and the instructor used input from the class to ensure she covered the topics each student wanted to learn. Army, Elizabeth (Microsoft Excel Training & Certification Pack (Live Online Hands-On Instructor-Led Class)
This was probably one of the best training courses I’ve had. It definitely was the best Excel class. Army, Carley (Microsoft Excel Training & Certification Pack (Live Online Hands-On Instructor-Led Class)
The learning objectives were thorough and with enough detail to understand concepts. Army, Lindell (Microsoft Excel Training & Certification Pack (Live Online Hands-On Instructor-Led Class)
Instructors are friendly and thorough. I learned a lot about Excel even after using it for 15+ years! -ARMY, Wendy (PVT Microsoft Excel 365 / 2021 / 2019 / 2016 Core MOS Live Hands-On Instructor-Led Training Class & Certification Pack)
Thank you, a lot of new information, practical and very helpful. Needs to practice in each lesson specifically media. -ARMY, Shahla (PVT Microsoft Excel 365 / 2021 / 2019 / 2016 Core MOS Live Hands-On Instructor-Led Training Class & Certification Pack)
Important Notice: Please avoid accessing ThinkB!G remote student computers on devices marked as classified or containing confidential information. Opt for an alternate computer for your training requirements, and for any specific class participation needs or inquiries, don’t hesitate to get in touch with
[email protected].
