Eventsize

MS Excel Level 3 Cover

MS Excel Level 3

CPTC Continuing Education Logo

CPTC Continuing Education

0 followers

Date & Time

Fri, 21 June 2024, 9:00 AM - 4:00 PM

GMT -3.00

Add to Calendar

Venue Location

Coastal Pines Technical College

3700 Glynco Parkway, 31525, Brunswick, GA, United States

View Map

About This Event

Schedule Information

  • Dec 15 = CPTC Brunswick
  • Jun 21 = CPTC Brunswick

This course is intended for students who are experienced MS Excel users and have a desire or need to advance their skills in working with some of the more advanced MS Excel features. Students will likely need to troubleshoot large, complex workbooks, automate repetitive tasks, engage in collaborative partnerships involving workbook data, construct complex MS Excel functions, and use those functions to perform rigorous analysis of extensive, complex datasets.

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, Dynamic Arrays, and Formula Auditing
  • Topic A: Use Lookup Functions
  • Topic B: Use Dynamic Arrays and Dynamic Array Functions
  • Topic C: Trace Cells
  • Topic D: 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

View Map

Coastal Pines Technical College

3700 Glynco Parkway, 31525, Brunswick, GA, United States

Event Organizer

CPTC Continuing Education Logo

CPTC Continuing Education

0 followers

CPTC Continuing Education provides individuals with hundreds of high-quality noncredit training solutions that are designed for professional and personal development including many that result with industry recognized certifications.For more information about CPTC Continuing Education, please contact us at CommunityEd@CoastalPines.Edu or 912-262-4300.

More Science & Technology Events in United States

2 DAY FUTURE NAIL TECH CLASS Cover

2 DAY FUTURE NAIL TECH CLASS

21 June @ 8014 Midlothian Tpke

ImmerseCon 24 Cover

ImmerseCon 24

22 June @ 1100 Telegraph Road, Glen Allen, VA, USA

Technology and Nature Cover

Technology and Nature

22 June @ Sally Manzara Interpretive Nature Center

Western DIGA Conference 2024 Cover

Western DIGA Conference 2024

22 June @ Joseph R. Robertson Collaborative Life Sciences Building, S Moody Ave, Portland, OR, USA

Lift Heavy Often Weightlifting Seminar with Elijah "EZ" Muhamed Cover

Lift Heavy Often Weightlifting Seminar with Elijah "EZ" Muhamed

22 June @ CrossFit Huakai, Kamehameha Avenue, Hilo, HI, USA

Choose Country

Start Selling Event Tickets

Planning an event and need to collect payments, send automated reminders, and automate check-ins? Get started by registering below:

Eventsize is a worldwide events discovery and online ticketing platform. Easily find events to attend in your city, and equip yourself with all the necessary tools to sell tickets for your events.

© 2024 Eventsize. All Rights Reserved.