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 L3 – SYST-0005

August 12, 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:
August 12, 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

Tickets

The numbers below include tickets for this event already in your cart. Clicking "Get Tickets" will allow you to edit any existing attendee information as well as change ticket quantities.
Tickets are no longer available

Share Our Website