emPOWER!Hour - Microsoft Excel: Analyzing Tables of Data
Microsoft started out as a financial tool, but did you know it can also manage large data sets? In Excel, these are known as "Tables" (aka "Lists"). Come learn the magic of using tables and what they can do for you in Excel.
Description
Excel 2019/365is Microsoft’s easy-to-use spreadsheet and data management application. In our emPOWER Hours for Microsoft Excel we will explore basic spreadsheet functionality and then take a deep dive into specific areas to further the knowledge of our participants in using this powerful tool.
In this session we will focus on creating and customizing tables used to manage data in Excel.
Learning Content
- Ranges vs Tables
- Working with Data Ranges
- Creating Named Ranges
- Creating a Table
- Sorting and Filtering Data
- Customizing Table Options
- Formatting Your Table
- Applying Conditional Formatting
Prerequisites
All participants will be required to have either a personal or business account in Office 365. To ensure success, participants should understand the basics of using a Windows-based computer and be comfortable using the keyboard, mouse, Windows operating system and an internet browser.
Cancellation Policy
All pre-paid registrations are final and non-refundable. Should the participant need to cancel within 48-hours of the scheduled session, one (1) rescheduling code will be issued to be used toward a future emPOWER!Hour session.