Skip to content
Add Visio Visuals to Power BI Reports  (Expire on Thu, Aug 22) Learn More
Get a Free Assessment

MicrosoftTeams-image (133)
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.

Want to know more about this course?

Call us: +1 (929) 257-1581

Contact Us