You don't want to miss this.

Excel Essentials


Creating Worksheets & Formulas

Modifying & Formatting Worksheets

Printing & Managing Workbook Content

Customizing the Excel Environment

OPAC Testing Included

Thursdays, April 4, 11 & 18, 2024

1:00 PM - 5:00 PM

Fee: $269*

*Qualifying companies can send employees for a discounted rate of $119 - for 3-days of training through the Employment Training Program (ETP) funded by the Employment Training Tax. Program Information...

Herndon Campus @ Clovis Community College

390 W Fir Ave, Bldg A Room 105, Clovis, CA 93611

View on map

Untitled Design


Brandon Moody

  • Boost your EXCEL skills with a half-day workshop
  • Become more productive and efficient with your spreadsheets
  • Strengthen the visual impact of your numerical data
  • Learn new things about EXCEL that you didn't know were even possible

Creating Worksheets and Formulas:

  • Introduction to Excel interface elements (e.g., ribbons, cells, columns, rows).
  • Basic worksheet creation: entering data, formatting cells.
  • Understanding formulas and operators (e.g., addition, subtraction, multiplication, division).
  • Inserting functions (e.g., SUM, AVERAGE, COUNT, MAX, MIN).
  • Utilizing AutoSum for quick calculations.

Modifying and Formatting Worksheet:

  • Tools for modifying rows and columns (e.g., insert, delete, resize).
  • Font options and formatting (e.g., bold, italic, underline, font size).
  • Using Format Painter to apply formatting quickly.
  • Introduction to the mini toolbar.
  • Exploring conditional formatting for data visualization.

Printing and Managing Workbook Content:

  • Printing workbooks and worksheets (default settings, custom print settings).
  • Page layout options (margins, orientation, scaling).
  • Print options (gridlines, headers/footers, page breaks).
  • Managing worksheets and workbooks (rename, move, copy, delete).
  • Working with data across multiple worksheets/workbooks (linking, consolidating).

Customizing the Excel Environment:

  • Ribbon customization (adding/removing tabs, groups, commands).
  • Quick Access Toolbar (customizing, adding frequently used commands).
  • Enabling add-ins for extended functionality.
  • Exploring version control features (e.g., track changes, compare workbooks).
  • Personalizing interface elements for efficient workflow.

Bringing It All Together (Class Project & OPAC Testing)

  • Integrating skills from previous sessions into a comprehensive project.
  • Task-based project to apply formatting, formulas, printing, and customization.
  • Troubleshooting common issues and applying learned techniques.
  • OPAC Testing


Celia Zamora

[email protected]