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

Your Excel skills could land you your next job. Over three-quarters of jobs require digital skills like Excel and word-processing. Attend all five classes and gain the skills you need — and save with a series discount.

This course will start you will at creation of basic spreadsheets and enhancing look and readability of those spreadsheets to teaching the most common and useful formulas and functions. Then training will take you to charting 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.

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