No-Cost Microsoft
Excel Training

for TAUW Partner Agencies

Learning Lab Dates and Times:

•  Basic Excel - Tuesday, January 15th, 9:00 AM - Noon
                               - OR -
•  Basic Excel - Wednesday, January 16th, 9:00 AM - Noon

•  Intermediate Excel - Tuesday, January 15th, 1:00 PM - 4:00 PM
                                - OR - 
•  Intermediate Excel - Wednesday, January 16th, 1:00 PM - 4:00 PM

 

•  Advanced Formulas in Excel - Tuesday, January 22nd, 9:00 AM - Noon
                                - OR - 
•  Advanced Formulas in Excel - Wednesday, January 23rd, 9:00 AM - Noon

•  Pivot Tables in Excel - Tuesday, January 22nd, 1:00 PM - 4:00 PM
                                - OR - 
•  Pivot Tables in Excel - Wednesday, January 23rd, 1:00 PM - 4:00 PM

Click Here to RSVP!

Basic Excel

  • •  Excel Math Basics - formulas &
       functions
  • •  Autofill, AutoComplete
  • •  Formatting Text
  • •  Formatting Numbers
  • •  Borders and Fill Colors
  • •  Conditional Formatting
  • •  Explore Excel Online & Office 365

Intermediate Excel

  • •  Sparklines
  • •  Intro to Pivot Tables,
       Pivot Charts and Macros
  • •  Transpose Data from Rows
       to Columns
  • •  Checking for Duplicates
  • •  Grouping and Subtotals
  • •  Explore Excel Online & Office 365

Advanced Formulas

  • •  Relative vs. Absolute References
  • •  Nested Functions
  • •  3D Formulas and referencing cells on
       other worksheets
  • •  Using Names in Formulas
  • •  Common and Not-So-Common
       Functions
  • •  Concatenate - joining data from
       multiple cells
  • •  Changing the case of text
  • •  Comparing columns of data
  • •  Removing extra spaces
  • •  IF Functions
  • •  VLOOKUP
  • •  Using Tables
  • •  Timesaving Tips

Pivot Tables

  • •  Managing Pivot Table Data
    • •  Transposing Data from Rows to
         Columns
    • •  Using the Text to Columns Feature
    • •  Data Validation
    • •  Consolidating Data
  • •  Grouping and Outlining Data
  • •  Creating Pivot Tables
    • •  Inserting a Pivot Table
    • •  Applying a Styles to Pivot Table
  • •  Creating a Pivot Chart

(Space is limited - register today!)