Excel classes will be conducted via Zoom online meetings.

What you'll need:

• Computer with webcam capabilities and a microphone
• Additional Monitor (optional, but recommended)

This class covers the following excel topics:

Getting Started with Excel: Performing Calculations in an Excel Worksheet, Modifying an Excel Worksheet, Modifying the Appearance of a Worksheet, Printing Excel Workbooks, Introduction to Charts & Graphs, Managing an Excel Workbook

Performing Calculations in an Excel Worksheet: Learn How to use Basic Math in Excel, Create Formulas with Sum/Max/Min/Average, Use Formula View, Understand Relative and Absolute References

Modifying an Excel Worksheet: Edit Worksheet Data, Find and Replace Data, Manipulate Worksheet Elements

Modifying the Appearance of a Worksheet: Apply Font Properties, Add Borders and Colors to Cells, Align Content in a Cell, Apply Number Formatting, Apply Cell Styles, Insert Comments

Printing Excel Workbooks: Define the Page Layout, Learn to use Header/Footer, Add File Pathway Documentation, Print 

Introduction to Charts & Graphs: Create and Modify Charts, Use Chart Layout Tools

Managing an Excel Workbook: Manage Worksheets with Data Filters, Apply Multi-Level Sort, Use the Sub-Totals View, Discover Pivot Tables

This course is WIOA Certified.

Excel classes will be conducted via Zoom online meetings.

What you'll need:

• Computer with webcam capabilities and a microphone
• Additional Monitor (optional, but recommended)

This class covers the following excel topics:

Working with Multiple Worksheets and Workbooks Simultaneously:  Use 3-D References, Use Links and External References, Consolidate Data

Using Advanced Worksheet Functions: Conditional & Logical Functions with If / Nested If / And/OR, VLookup, Apply Cell and Range Names

Goal Seek

Conditional Formatting: Creating Rules to Highlight Cells, Using Icon Sets with Inequalities

Presenting Data with Charts:  Using Sparklines, Review Chart Basics, Evaluate Formatting Options, Combine Charts, Add Graphical Elements (Trend line) 

Analyzing Data Using PivotTables, Slicers, and PivotCharts: Create a PivotTable Report, Filter Data Using Slicers, Analyze Data Using PivotCharts

Customizing and Enhancing the Excel Environment: Customize the Excel Environment, Manage Themes, Create and Use Templates, Apply Spreadsheet Security

And More: Controlling Page Breaks, Use Page Setup to Repeat Headings (Rows/Columns), Automate Tasks with a Simple Macro

This course is WIOA Certified.