Coronavirus (COVID-19) information: All courses at all locations are running as live online classes. Our offices remain open with limited staff. Learn more.

×

Microsoft Excel Training Class - Introduction

Microsoft Excel Training Class - Introduction

This Excel course starts by teaching basic Excel functionality, and core Excel formulas and techniques, including calculations, formatting, and charts. You will finish up the course with a project that pulls together all your newly learned Excel skills. This one-day Excel class provides a solid foundation to leverage Excel in your job. Attend this Excel workshop and learn:

  • Data Entry & Calculations: Discover basic Excel calculations like averages, sums, and counts.
  • Text Functions: Use functions to format and correct text such as changing the case of text automatically.
  • Formatting and Format Painter: Learn to customize formatting and quickly replicate it to other cells.
  • Conditional Formatting: Set format and appearance for cells based on specific criteria.
  • Charts: Learn the essentials of creating and formatting line charts, bar charts, and pie charts.
  • Excel efficiency tips: Learn to use Autofill & Quick Access so Excel can automate your work.

Microsoft Excel Training Class - Introduction Course Dates

All classes start at 10:00 a.m. and end at 5:00 p.m. Eastern time and are led by a live instructor.

Course Title Course Dates Course Location Fee Register
Microsoft Excel Training Class - Introduction

Online

American Graphics Institute American Graphics Institute
Online
Live instructor-led class online
1969-12-31T19:00:00-05:00 $249.00
Microsoft Excel Training Class - Introduction

Online

American Graphics Institute American Graphics Institute
Online
Live instructor-led class online
1969-12-31T19:00:00-05:00 $249.00
Microsoft Excel Training Class - Introduction

Online

American Graphics Institute American Graphics Institute
Online
Live instructor-led class online
1969-12-31T19:00:00-05:00 $249.00
Microsoft Excel Training Class - Introduction

Boston

American Graphics Institute American Graphics Institute
Boston
American Graphics Institute
AGI Training Boston
150 Presidential Way
Boston - Woburn, MA 01801
1969-12-31T19:00:00-05:00 $249.00
Microsoft Excel Training Class - Introduction

Online

American Graphics Institute American Graphics Institute
Online
Live instructor-led class online
1969-12-31T19:00:00-05:00 $249.00
Microsoft Excel Training Class - Introduction

Online

American Graphics Institute American Graphics Institute
Online
Live instructor-led class online
1969-12-31T19:00:00-05:00 $249.00
Microsoft Excel Training Class - Introduction

Boston

American Graphics Institute American Graphics Institute
Boston
American Graphics Institute
AGI Training Boston
150 Presidential Way
Boston - Woburn, MA 01801
1969-12-31T19:00:00-05:00 $249.00
Microsoft Excel Training Class - Introduction

Online

American Graphics Institute American Graphics Institute
Online
Live instructor-led class online
1969-12-31T19:00:00-05:00 $249.00

Introductory Excel Training Class Topics Covered

Topics covered in the introductory Microsoft Excel course include the following:

Getting Started with Excel

  • Getting to know the Excel Interface: learn to navigate within the Excel interface to access commands and functions.
  • Data Entry using Excel: Understand various ways of entering data into an Excel file.

Using Excel Formulas

  • Autofill in Excel: Learn to use Excel's predictive data entry
  • Excel Calculations: Use excel for mathematical expressions
  • True / False: Learn to have Excel test for matching data using true/false
  • Functions in Excel: Discover essential AutoSum functions including: Sum, Average, Max, Min, and Count Numbers
  • Excel’s Text Functions: Learn to use functions to modify text
  • Multi-Input Functions: Learn advanced functions that require multiple inputs
  • Constant (Absolute) Cell References: Learn to create constant cell references when required for calculations

Formatting Worksheets in Excel

  • Formatting Excel sheets and content: Learn to provide visual cues to those reviewing sheets with formatting.
  • Using the Format Painter in Excel: Learn to duplicate formatting from one cell to others.
  • Applying Conditional Formatting: Discover how to apply formatting depending upon rules relating to content.

Working with Charts in Excel

  • Understanding chart types
  • Creating Line Chart: Create a line charts and spark lines to represent data visually.
  • Column Charts using Excel: Learn to create column charts for data visualization.
  • Pie Charts in Excel: Discover how to create pie charts for data visualization.
  • Customizing charts: Adjusting charts to meet your design requirements.
  • Creating Tables: Understand the functionality available when data is presented as a table.

Excel Workbook Management

  • Printing & Exporting from Excel: Understand ways to easily print or convert Excel content to PDF.
  • Using Multiple Worksheets in Excel: Learn to organize data by creating, moving, copying and managing Excel worksheets.
  • Using Repeat Action: Learn to quickly duplicate prior actions in Excel.
  • Saving Time with Excel Shortcuts: Discover shortcuts that save time and help you to work more efficiently.

Course prerequisites

We recommend that you have Microsoft Excel available to use after your return from this Excel class. A computer with Excel is provided for use during the course. 

Course materials

You will receive a comprehensive Excel course manual for this class.

Available Delivery Methods For This Class

CLASSROOM
LIVE ONLINE
PRIVATE
MY LOCATION