Excel Level 4 - APHL (Private Class)

CLASS TIME

12:00 PM – 5:00 PM (EASTERN TIME)

APPROXIMATE BREAK TIMES

2:00 PM – 2:15 PM
3:45 PM – 3:55 PM

Method of Delivery

This class will be held online using GoToMeeting.  Class participants will receive a PDF of the book and will be able to access the class files online.

When you register, be sure to use the email that you would like your GoToMeeting invitation sent to.  The meeting invitation will be sent no later than 1 hour prior to the class. Check your junk mail if you do not receive an invitation, especially if you have a Gmail or Hotmail account.  You do not have to have a GoToMeeting subscription to participate.  

The web browser client will download automatically when you start or join your first GoToMeeting meeting and is also available for manual download here.

https://www.gotomeeting.com/

It is a good idea to download this prior to the online meeting.

COURSE DESCRIPTION

This class is designed for the intermediate to advanced users that want to expand their knowledge of Excel data management features such as sorting, filtering, tables and PivotTables. This class will also give a quick overview of Power Query and Power Pivot.

EXCEL'S DATA FEATURE

• uidelines and Best Practices for setting up your data
• Sort data alphabetically, numerically, chronologically, by colors, by icons and by custom sorts.
• Use the Data Subtotal Feature
• Use Filters
• Filter using Single and Multiple Columns
• Clear Filters
• Advanced Filters
• Use a Table
• Basic Table Features such as banded rows and columns, filtering, and locking headings
• Apply and Clear Table Styles
• Use the Total Row
• Add rows/columns in the middle or the end of a table
• How Tables Create Database like functions called Structured References
• Convert a Table to a Normal Range

PIVOTTABLES

• Create and modify a PivotTable
• Change PivotTable Options
• Drilldown into the PivotTable Data
• Change the Data Source
• Refresh the PivotTable Data
• Use Slicers and Timelines
• Work with PivotTable Design Options

BRIEF OVERVIEW OF POWER QUERY AND POWER PIVOT

• What is Power Pivot and Power Query?
• Work through a basic example of using Power Query to clean up the data
• Work through of basic example of using the Power Pivot Data Model to relate data and create a PivotTable on multiple data sets.
• Use Power Query to combine multiple data sets.

PREREQUISITES: Excel Level 1, 2 and 3 or equivalent knowledge.