Skip to content
Loading...
UPCOMING EVENTM365 Governance in highly regulated Industries - Exclusive Webinar Event Learn More
Get a Free Assessment

Essentials of Excel – Intensive Executive Assistant Workshop

Gain the skills required to analyze data using pivot tables and other tools in Excel. This workshop is great for for an executive assistant who is often tasked with crunching salary or project-code numbers from multiple spreadsheets.

audience (1).png Audience Intermediate
Technology-1.png Technology Excel
type-1.png Type Workshop
service-category-1 Service Category Adoption
Duration-1 Duration 2 hrs
skills-1 Skill Set

Excel

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.

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

  • 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

Manual tasks can be automated by using -built-in functionality in Excel.