What Will I Learn?

  • Spreadsheet creation and formatting techniques.
  • Formulas and functions.
  • Absolute and relative references.
  • Charting and conditional formatting.
  • Manipulation of data and structured tables.
  • Pivot tables and charts.

Description

Over 75% of jobs require digital skills such as Excel and word-processing. Your ability to create spreadsheets, utilize basic formulas and work with datasets could advance your career or help you land your next job.

 In Excel Sessions 1-5, you will start by learning to create basic spreadsheets, enhancing the look and readability of those spreadsheets and practicing the most common and useful formulas and functions. Then training will take you to chart features and the most common charts including mini Sparkline charts and conditional formatting. Moving to the next level, work alongside the instructor to discover how to manipulate data and quickly extract data while discovering the subtotal command and creation of structured tables. Finally, you will learn how to create a pivot table and analyze large sets of data then present your data pictorially with the use of a pivot chart. Enroll in the series and save $45. 

Walk Away With:

  • Training notes including shortcuts and tips/tricks to increase productivity, to use during the course and on the job site.
  • Certification of Completion provided by CSI Workforce Development and Training.

Who Should Attend?

This course is recommended for anyone who wants to be an Excel user, unleash the true potential of this application and efficiently automate your business processes.

Instructor Bio

Julia Rietdorf