Excel with Excel: Intermediate

Primary tabs

Program Type:

Technology

Age Group:

Teens, Adults
Please note you are looking at an event that has already happened.
Registration for this event is no longer open.

Program Description

About This Program

Excel is a powerful tool for working with spreadsheets, but can be daunting to learn. Register for this 6-session class to go over basic Excel functionality, including conditional logic, working with multiple worksheets, and formula auditing to get you on your way to becoming an Excel master. For professionals and casual learners. Presented with GPRIN.

Topics Covered
•    Working with Multiple Worksheets & Workbooks
•    Text and Date Functions
•    Named Ranges
•    Summarising Data
•    Tables
•    Pivot Tables, Charts and Slicers
•    Data Validation
•    Conditional Logic
•    Automating Lookups
•    Formula Auditing and Protection
•    Data Modelling
•    Recording Macros

Learning Outcomes
•    Learn how to combine data and perform calculations across multiple worksheets
•    Learn how to extract information from data
•    Learn how to work with Named Ranges to improve your calculations
•    Learn how to use functions on Excel to extract information from data and graph the data
•    Learn how to work with Data Validation
•    Learn the concept of conditional logic and logic tests.
•    Learn how to check for errors, resolve circular references, and protect your worksheets from further harm.