Please note: Class offered In-Person at Great Bay Community College

Macros Pivot Tables Logical Functions Objectives for the experienced spreadsheet user.  Automate worksheets with macros. Participants will analyze data using pivot tables.

For more information:  Macros Pivot Tables Logigal Funtions Objectives

Computers provided

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.