fbpx
Loading Events

« All Events

  • This event has passed.

Excel Level 2 ( 4/20)

April 20, 2021 @ 9:00 am - 5:00 pm

This course is being held online with a live instructor.  Students will have access to training labs after the course as well.

Contact us for additional dates held monthly!

 

WORKING WITH FUNCTIONS

  • Define Cell Ranges and Reference Them in Formulas
  • Perform Conditional Calculations
  • Carry Out Logical and Specialized Functions
  • Work with Date and Time Functions
  • Understand and Execute Text Functions

2 – WORKING WITH LISTS

  • Sort and Filter Data
  • Learn the Capabilities of Database Functions
  • Query Data with Database Functions
  • Outline and Subtotal Data

3 – ANALYZING DATA

  • Build and Modify Tables
  • Create Formatting Rules
  • Apply Conditional Formatting to Alter Groups of Cells

4 – VISUALIZING DATA WITH CHARTS

  • Organize and Represent Data with Charts
  • Modify and Format Charts
  • Discover and Implement Advanced Chart Features

5 – ANALYZING DATA WITH PIVOTTABLES AND PIVOTCHARTS

  • Create a PivotTable
  • Analyze PivotTable Data
  • Present Data with PivotCharts
  • Filter Data Using Timelines and Slicers

Date: April 20
Times:  9 am – 5 pm
Cost (member): $265
Cost (non-member):$325

CLASS REGISTRATION

  • Hidden
  • Can not be the same as the person registering unless PO# is provided
  • Hidden
    PO # must be emailed to Training@mascpa.org if not available at registration, before the 1st day of class.
  • PO # must be emailed to Training@mascpa.org if not available at registration.
  • All self pays must be paid in advance of attendance.
  • Hidden
  • Hidden

 

Details

Date:
April 20, 2021
Time:
9:00 am - 5:00 pm
Event Categories:
,