- Ways to Train:
- Live Classroom Class is delivered at a Centriq location with a live instructor actually in the classroom.
- Live Virtual Class Class is delivered live online via Centriq's Virtual Remote technology. Student may attend class from home or office or other location with internet access.
- HD Class Class is delivered via award winning HD-ILT at Centriq's facility. Students view the live instructor utilizing a 60'' HD monitor.
- Ways to Buy:
- Retail Class can be purchased directly via check, credit card, or PO.
- CV Centriq Vouchers Class is available for students using Centriq Vouchers.
- CP Centriq Choice Pass Eligible Class is available to students utilizing Centriq Choice Pass program.
|Start Date||End Date||Duration||Days||Start Time||End Time||Time Zone||Location||Ways to Train||Ways to Buy||Price|
|Request a Date|
Excel is an electronic spreadsheet program that is part of the Microsoft Office suite. You use Excel to organize, calculate, and analyze data.
In Excel, you work with worksheets, which consist of rows and columns that intersect to form cells. Cells contain various kinds of data that you can format, sort, and analyze. An Excel file is called a workbook, which contains several blank worksheets.
*Note - This course is delivered on the 2019 version of the product & prepares students for the Microsoft Office Specialist and Expert exams for Excel 2019. Using an older version of Office today? There is 10% difference between 2013, 2016 and 2019.
AudienceStudents will get the most out of this course if their goal is to become proficient in using advanced Microsoft Excel skills to create worksheets and charts for data tracking and reporting. Students should have some experience using Microsoft Excel basic and intermediate features.
*Note – If you are unsure what course level you should take, you might consider taking a short self-assessment available.
In order to be successful in this course, a learner should have completed the following course:
Microsoft Excel 2019: Level 1 (Basic) and Level 2 (Intermediate)
In addition, students should be comfortable using a personal computer and Microsoft Windows 10 and be able to multitask, as the structure of this class will require you to listen, watch, read, type, and write often all at the same time.
After completing this course, students will know how to:
- Use functions to make decisions
- Find and trap errors, control formula options, and use array formulas and functions
- Perform calculations on dates, manipulate text, and use some statistical and financial functions
- Use Power Pivot and cube functions to access information in the Power Pivot Data Model, and export Excel worksheets to other formats
- Perform what-if analyses using a watch window, scenarios, and the Goal Seek utility
- Record and run macros, and create a simple form
View the Microsoft Office Excel: Level 3 Training Course Outline
Lesson 1: Working with Multiple Worksheets and Workbooks
Topic A: Use Links and External References
Topic B: Use 3-D References
Topic C: Consolidate Data
Lesson 2: Sharing and Protecting Workbooks
Topic A: Collaborate on a Workbook
Topic B: Protect Worksheets and Workbooks
Lesson 3: Automating Workbook Functionality
Topic A: Apply Data Validation
Topic B: Search for Invalid Data and Formulas with Errors
Topic C: Work with Macros
Lesson 4: Using Lookup Functions and Formula Auditing
Topic A: Use Lookup Functions
Topic B: Trace Cells
Topic C: Watch and Evaluate Formulas
Lesson 5: Forecasting Data
Topic A: Determine Potential Outcomes Using Data Tables
Topic B: Determine Potential Outcomes Using Scenarios
Topic C: Use the Goal Seek Feature
Topic D: Forecast Data Trends
Lesson 6: Creating Sparklines and Mapping Data
Topic A: Create Sparklines
Topic B: Map Data