Excel Essentials

TOPICS COVERED IN THIS TRAINING WILL BE

Creating Worksheets & Formulas

Modifying & Formatting Worksheets

Printing & Managing Workbook Content

Customizing the Excel Environment

OPAC Testing Included

Tuedays February 11, 18 & 25, 2025

1:00 PM - 4:30 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 Avenue

Building A, Room 214

Clovis, CA 93611

View on map

Instructor

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

Getting to Know Excel:

• Introduction to Excel interface elements (e.g., ribbons, cells, columns, rows).
• Basic worksheet creation: entering data, formatting cells.
• Getting help in Excel

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