During this workshop you will learn to:
- Procure database-list data from scratch or outside file/data source.
- Fix/normalize data with special tools and function-formulas.
- Sorting by primary, secondary and more – to compare and contrast areas of
your data.
- Perform subtotaling reports on single and grouped data.
- Filter data to focus on information that matches criteria you set.
- Advanced filters called “slicers” that make it easy to understand what
exactly is being displayed (dashboard effect).
- Insert pivot-table tool – perform the ultimate in data summarization and
formatted reporting.
- Pivot-charting based on pivot-tables.
Other Information:
- The session will be delivered on the Go To Meeting platform so all
participants will work from their own workspace and use their own computer. Go
To Meeting has video capability but, if the participant’s computer is not
equipped with a camera, audio will also work.
- To register we will need the name and email address of each
participant.
- Five (5) days before the date of the session we will send each participant
an electronic copy of the course materials. Additionally, we will provide a
link of a Meeting ID that when clicked on will allow the participant to enter
the training room. For those registering less than 5 days prior, it will be no
problem as we will immediately provide the information.
- Participants should enter the training room 15 minutes (8:45) before the
start time.
- The sessions will be limited to 20 participants to allow for, and ensure,
maximum interaction, participation and engagement.