Management Development Center Banner

Introduction & Intermediate Excel

Not currently scheduled

Intro to Excel

Overview:

This workshop will help participants boost productivity, simplify data management and streamline everyday tasks using Microsoft Excel. During this session, participants who are beginners in Excel will take a tour of all the basics before learning how to build a worksheet from scratch utilizing formulas and functions. Upon completion of this half day workshop, participants will have mastered the ABCs of using charts, graphs, fonts, borders, shading and more. This training is in a computer lab and provides hands-on instruction and practice.

Learning Outcomes:

  • Navigate basic Excel Spreadsheets
  • Build basic formulas
  • Utilize basic functions
  • Build simple charts/graphs

Intermediate Excel

Overview:

During the afternoon session, participants will pick up where the morning session left off and learn when to use a macro, how to debug a macro and how to create and manage a PivotChart while utilizing key code shortcuts, linking and data exchange operations.

Learning Outcomes:

  • Create What-If Statements
  • Use logical statements
  • Sort and filter data
  • Create PivotTables and PivotCharts
Back to top

Original text