We work closely with PG&E, Sandia National Labs and other clients. Our courses are open to all of our clients and we look forward to seeing you in class.

 

Upcoming Classes

 

Loading Events

« All Events

  • This event has passed.

Excel O365 Level 3 – SYST-0005

September 15, 2021 @ 8:30 am - 4:00 pm

$219.00

Excel Level 3

$219

Course Length: 1 day

Course Objectives:

Upon successful completion of this course, you will be able to perform advanced data analysis, collaborate on workbooks with other users, and automate workbook functionality.

You will:

  • Work with multiple worksheets and workbooks.
  • Use Lookup functions and formula auditing
  • Share and protect workbooks.
  • Automate workbook functionality.
  • Create sparklines and map data.
  • Forecast data.

Course Content

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: Using Lookup Functions and Formula Auditing

Topic A: Use Lookup Functions

Topic B: Trace Cells

Topic C: Watch and Evaluate Formulas

Lesson 3: Sharing and Protecting Workbooks

Topic A: Collaborate on a Workbook

Topic B: Protect Worksheets and Workbooks

Lesson 4: Automating Workbook Functionality

Topic A: Apply Data Validation

Topic B: Search for Invalid Data and Formulas with Errors

Topic C: Work with Macros

Lesson 5: Creating Sparklines and Mapping Data

Topic A: Create Sparklines

Topic B: Map Data

Lesson 6: 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: Forecasting Data Trends

Appendix A: Microsoft Office Excel O365 Exam 77-727

Appendix B: Microsoft Office Excel O365 Expert Exam 77–728

Appendix C: Microsoft Excel O365 Common Keyboard Shortcuts

Appendix D: Cube Functions

Appendix E: Importing and Export Data

Appendix F: Internationalizing Workbooks

Appendix G: Working with Power Pivot

Appendix H: Advanced Customization Options

Appendix I: Working with Forms and Controls

This event ticket will close at 12:00 pm the day before the event.

Details

Date:
September 15, 2021
Time:
8:30 am - 4:00 pm
Cost:
$219.00
Event Tags:
,

Venue

CA United States
View Venue Website

Organizer

Jim Rose
Phone
925-847-8262
Email
Jrose@ComputerTrainingSource.com

Share Our Website