About Us

Excel Intensive for an Executive Assistant Workshop



A short workshop to learn the power of Excel

OUTLINE

This 2 hour in person instructor led class is designed for an executive assistant who is often tasked with crunching salary or project code numbers from multiple spreadsheets.  


PURPOSE

This hands-on session will explain the basic skills required to analyze data using pivot tables (and other tools) in Excel.     


WHAT’S COVERED

  • Formulas & functions (Overview/VLOOKUP/SUM/COUNTIF/IF/IFS/SUMIF)
  • Formatting (Number/Conditional/Align/cell/painter/hide)
  • Tables (Create/format/sort/filter/total/slicers)
    Charts (Titles/add/remove/format/legend/trendlines/analyze/update data/sparklines)
  • Pivot Tables (Create/field list/group/ungroup/filter/Pivot Chart)
  • Automation (automating data imports/exports and reports
  • Report generation for the board room

Required Skill Level:   Intermediate


END RESULT

Manual excel tasks, can be automated by using Excel functionality.


Audience

Intermediate

Technology

Excel

Type

Workshop

Location

  • On Site

Duration

  • 2 hrs

Skillset

  • Excel
Want to learn more call us +1 (929) 257-1581