www.eventbrite.com Open in urlscan Pro
99.84.208.124  Public Scan

Form analysis
0 forms found in the DOM

Text Content

Skip Main Navigation
Eventbrite
Trigger search event experience
Browse Events
Organize
Help
Log InSign Up
Menu
Page Content


ACTIONS PANEL

 * Like Event
 * Share this event

Dec 19


EXCEL AGILITY: PIVOT TABLES - BEGINNERS

Live Webinar or Recording December 19, 2022, 2:00 pm - 3:40 pm Eastern Credit:
CPE: 2, ATAOP: 1.5, ATATX: 1.5 Excel expert David Ringstrom,

By Aurora Training Advantage
Follow
280 followers


WHEN AND WHERE


DATE AND TIME

Mon, December 19, 2022, 2:00 PM – 3:40 PM EST


LOCATION

Online


REFUND POLICY

Contact the organizer to request a refund.


ABOUT THIS EVENT

 * 1 hour 40 minutes
 * Mobile eTicket

Live Webinar or Recording

December 19, 2022, 2:00 pm - 3:40 pm Eastern

Credit: CPE: 2, ATAOP: 1.5, ATATX: 1.5

Excel expert David Ringstrom, CPA, introduces the basics of creating and using
Excel pivot tables in this valuable presentation. Pivot tables enable you to
easily create reports from complex data simply by using your mouse. David shows
you how to initiate a pivot table from a list of data, add fields, dig deeper
into the numbers, and much more. In addition, he points out pivot table traps
and shares tricks to help ensure your reports are accurate.

David demonstrates every technique at least twice: first, on a PowerPoint slide
with numbered steps, and second, in the Microsoft 365 version of Excel. David
draws your attention to any differences in the older versions of Excel (2019,
2016, 2013, and earlier) during the presentation as well as in his detailed
handouts. David also provides an Excel workbook that includes most of the
examples he uses during the webcast.

Topics Typically Covered:

 * Adding fields to a blank pivot table to create instant reports.
 * Determining which refresh commands will update a single pivot table versus
   all pivot tables in a workbook.
 * Filtering pivot tables to show fewer columns and/or rows of data.
 * Exploring the nuances of formatting numbers within pivot tables.
 * Resetting all filters at once within a pivot table by way of the Clear
   Filters command.
 * Creating a pivot table to transform lists of data into on-screen reports.
 * Repositioning or removing subtotals within pivot tables.
 * Contrasting sorting data within worksheets to the nuances of sorting data
   within pivot tables.
 * Presenting the largest or smallest values in chart form by way of a Top 10
   pivot chart.

Learning Objectives: 

 * Identify how to expand and collapse groups of data within a pivot table.
 * Identify the best approach for formatting numbers within pivot tables.
 * Define the default location for pivot table data when you click a checkbox
   for a given field.

Level: IntermediateFormat: Live webcastInstructional Method: Group:
Internet-basedNASBA Field of Study: Computer Software & Applications (2
hours)Program Prerequisites: NoneAdvance Preparation: None

Guest Speaker: David H. Ringstrom, CPA - Accounting Advisors Inc.

Level: Basic

Format: Live Webcast

Field of Study: Computer Software & Applications

Program Prerequisites: None



Advanced Preparation: None





Aurora Training Advantage is registered with the National Association of State
Boards of Accountancy (NASBA) as a sponsor of continuing professional education
on the National Registry of CPE Sponsors. State boards of accountancy have final
authority on the acceptance of individual courses for CPE credit. Complaints
regarding registered sponsors may be submitted to the National Registry of CPE
Sponsors through its website: www.nasbaregistry.org.

For more information regarding administrative policies such as complaint and
refund, and cancellation please contact our offices at 407-542-4317 or
training@auroratrainingadvantage.com.



Aurora Training Advantage is offering continuing education points designed to
recognize dedication to training and excellence in operations.

Aurora Training Advantage is offering continuing education points designed to
recognize dedication to training and excellence in accounting.


TAGS

 * Online Events
 * Online Classes
 * Online Business Classes


SHARE WITH FRIENDS

Share on FacebookShare on Facebook MessengerShare on LinkedinShare on
TwitterShare by Email

--------------------------------------------------------------------------------


AURORA TRAINING ADVANTAGE

Organizer of Excel Agility: Pivot Tables - Beginners



Facebook profileTwitter profileOrganizer website
 * Follow
 * Contact

--------------------------------------------------------------------------------



$219 – $599
Get tickets



SITE NAVIGATION


USE EVENTBRITE

 * How it Works
 * Eventbrite Boost
 * Pricing
 * Content Standards
 * Eventbrite Mobile Ticket App
 * Eventbrite Check-In App
 * Eventbrite App Marketplace
 * COVID-19 (Coronavirus) Resources
 * FAQs
 * Sitemap


PLAN EVENTS

 * Sell Tickets Online
 * Event Registration Software
 * Online RSVP
 * Virtual Events Platform
 * Event Planning
 * Event Payment System
 * Nonprofits & Fundraisers Events
 * Event Marketing
 * Grow your Business
 * Party Planning


FIND EVENTS

 * Browse Online Events
 * Get the Eventbrite App


CONNECT WITH US

 * Report This Event
 * Help Center
 * Terms
 * Privacy
 * CA Privacy Notice
 * Accessibility
 * Community Guidelines

Eventbrite + Ticketfly

© 2022 Eventbrite