Program Type:
TechnologyProgram 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.