Back to All Events

Excel 2013 Advanced


Excel 2013 Advanced

June 6 - 7, 2018
8:00 - 5:00 each day
CHL Computer Lab, 1103 Balch Blvd.
Stennis Space Center

Cost: $40

To register, contact Troy Teadt at 228-688-3113 or 985-788-3257 or by email at tteadt@prcc.edu, at least one week before the class date.

Overview
Upon successful completion of this course, students will be able to

  • customize your workbook by applying conditional formatting, adding data validation criteria, customizing menus and toolbars, creating and editing a macro, and grouping and outlining structured data.
  • work with multiple workbooks to create a workspace, consolidate data, link cells, edit links,
  • collaborate with other Excel users by protecting your workbook
  • chart non-adjacent data, modify chart items, and create a custom chart template.
  • use multiple graphic objects and diagrams to enhance your worksheet.

Course Content

Lesson 1: Customizing your Workbook

  • Apply Conditional Formatting
  • Add Data Validation Criteria
  • Customize Menus
  • Customize Toolbars
  • Create a Macro
  • Edit a Macro
  • Group and Outline Structured Data

Lesson 2: Working with Multiple Data Sources

  • Create a Workspace
  • Consolidate Data
  • Link Cells in Different Workbooks
  • Edit Links

Lesson 3: Collaborating with Others Using Workbooks

  • Protect your Worksheets
  • Protect Your Workbook

Lesson 4: Creating Charts

  • Creating a Chart Sheet
  • Creating an Embedded Chart
  • Comparing Chart Sheets with Embedded Charts

Lesson 5: Modifying Charts

  • Chart Types
  • Modifying Embedded Charts
  • Adding and Deleting Chart Items
  • Moving and Sizing Chart Items

Lesson 6: Formatting a Chart

  • Formatting Chart Text
  • Formatting Labels
  • Printing a Chart Sheet

Lesson 7: Using Graphic Objects to Enhance your Worksheets

  • Create Graphic Objects
  • Resize, Move, and Copy Graphic Objects
  • Change the Order of Graphic Objects
  • Group Graphic Objects
  • Format Graphic Objects
  • Insert Clip Art
  • Modify Clip Art
Earlier Event: May 23
Microsoft Access: Part 2