ONE-DAY WORKSHOP

For up to 16 participants delivered on-site or virtually

Request a Quote or More Information on this Workshop >

WORKSHOP DESCRIPTION

Microsoft Excel has become the de facto spreadsheet application for business. This versatile software package can help you manage virtually any type of data. Whether you are tracking orders, working with budgets, or analyzing a database – Excel is the powerful and flexible solution your job requires.

This hands-on course will teach you the important functions of this industry-standard software.

Courses offered for Excel 2010, 2013, 2016, 365

Other workshops on this topic: Excel – Basic | Excel – Advanced (Data Management) | Excel Advanced (Spreadsheet Analysis)

Microsoft Excel Training

WHO SHOULD ATTEND:

  • People with a basic knowledge of Excel and a desire to upgrade their skills

YOU WILL LEARN:

  • Organize, protect, and display data using various tools
  • Use the IF function to create linking formulas and to manage links
  • Manage and arrange multiple workbooks: insert and manage multiple worksheets within a workbook and consolidate data from multiple sources
  • Create, modify, customize, and enhance charts to present data effectively
  • Create, apply, and modify styles to format worksheets consistently and quickly
  • Use comments and text boxes to annotate worksheets, and use sparklines to highlight data

COURSE OUTLINE

Worksheet Organization

  • Managing range names
  • Creating and using workbook templates
  • Applying worksheet security
  • Creating and using outlines

Advanced Formulas

  • Using the IF function
  • Linking formulas
  • Modifying and restoring links

Using Multiple Workbooks and Worksheets

  • Working with multiple workbooks
  • Working with multiple worksheets
  • Consolidating data

Working with Charts

  • Creating charts
  • Changing chart data
  • Modifying chart elements
  • Creating custom charts

Applying Formatting

  • Working with styles
  • Annotating worksheets
  • Using sparklines

Summary and Evaluations

METHODOLOGY

  • Live, instructor-led training with hands-on exercises

Participants are requested to bring their computers to the session. Laptops are also available to rent for an additional fee.

Request a Quote / More Information

< Back to all Microsoft Office Courses

Course Code: MOB702

-MB-1