Skip to main content
Adobe training, UX Courses, and Photoshop Classes at AGI
American Graphics Institute
Secondary
  • About
  • Contact
  • Locations
  • Books
  • All classes
  • UX Classes
  • Cart
  • Log in
Search
Search
Main menu
  • Classes & Workshops
    • Classes & Workshops
    • Column 1
      • Adobe Classes
      • Photoshop
      • InDesign
      • Illustrator
      • Premiere Pro
      • After Effects
      • Animate
      • Acrobat
      • Captivate
      • XD
      • Creative Cloud
      • All Adobe
      • Digital Marketing
      • HTML Email
      • Google Analytics
      • Google Tag Manager
      • Digital Marketing Certificate
    • Column 2
      • Elearning
      • Captivate
      • Camtasia
      • Graphic Design
      • Graphic Design Course
      • Design Thinking
      • Graphic Design Certificate
      • Graphic Design for High School Students
      • Office Skills
      • PowerPoint
      • Keynote
      • Excel
      • Access
      • Google Docs
      • Presentation Design
      • PowerPoint Design
      • Keynote Presentation Design
    • Column 3
      • UX Classes
      • UX Design
      • Information Architecture
      • Rapid Prototyping
      • UX for Mobile & Touch
      • Figma
      • Sketch
      • XD
      • UXQB CPUX Certification
      • UX Certification
      • UX Design Certificate
      • Video Editing
      • Premiere Pro
      • After Effects
      • DaVinci Resolve
      • Final Cut
      • Video Editing for High School Students
      • Video Production
      • Web Accessibility
      • Web Accessibility
      • Section 508
    • Column 4
      • Web Design
      • WordPress Classes
      • HTML
      • CSS
      • Responsive Web Design
      • Web Design Certificate
      • Web Graphics
      • Web Design for High School Students
      • Web Development
      • JavaScript
      • HTML
      • CSS
      • Drupal
      • WordPress
      • CAD & 3D Design
      • Sketchup
      • 3DS
      • Maya
      • See All Classes
  • Online Training
    • Online Training
    • Column 1
      • Adobe Classes
      • Photoshop
      • InDesign
      • Illustrator
      • Premiere Pro
      • After Effects
      • Animate
      • Acrobat
      • Captivate
      • XD
      • Creative Cloud
      • All Adobe
      • Digital Marketing
      • HTML Email
      • Google Analytics
      • Google Tag Manager
      • Digital Marketing Certificate
    • Column 2
      • Elearning
      • Captivate
      • Camtasia
      • Graphic Design
      • Graphic Design Course
      • Graphic Design Certificate
      • Design Thinking
      • Office Skills
      • PowerPoint
      • Keynote
      • Excel
      • Access
      • Google Docs
      • Presentation Design
      • PowerPoint Design
      • Keynote Presentation Design
      • Figma
    • Column 3
      • UX Classes
      • UX Design
      • Information Architecture
      • Rapid Prototyping
      • UX for Phone & Touch
      • Sketch
      • XD
      • UXQB CPUX Certification
      • UX Certification
      • UX Design Certificate
      • Video Editing
      • Premiere Pro
      • After Effects
      • DaVinci Resolve
      • Final Cut
      • Web Accessibility
      • Web Accessibility
      • Section 508
    • Column 4
      • Web Design
      • Web Design Certificate
      • WordPress
      • HTML
      • CSS
      • Responsive Web Design
      • Web Graphics
      • Web Development
      • JavaScript
      • HTML
      • CSS
      • Drupal
      • WordPress
      • CAD & 3D Design
      • Sketchup
      • 3DS
      • Maya
      • See All Classes
  • Certificate Programs
    • Certificate Programs
    • Column 1
      • Web Design Certificate
      • UX Design Certificate
      • Digital Marketing Certificate
    • Column 2
      • Graphic Design Certificate
      • Video Editing Certificate
      • Web Development Certificate
    • Column 3
      • Photoshop Certificate
      • All Certificate Programs
  • Creative Cloud Classes
    • Creative Cloud Classes
    • Column 1
      • Creative Cloud for Print & Digital
      • Creative Cloud for Video
      • Creative Cloud for Web
    • Column 2
      • Photoshop CC
      • InDesign CC
      • Illustrator CC
    • Column 3
      • Premiere Pro CC
      • After Effects CC
      • Animate CC
      • See All Classes
  • Adobe Training
    • Adobe Training
    • Column 1
      • Photoshop
      • InDesign
      • Illustrator
      • Animate
      • Acrobat
    • Column 2
      • Premiere Pro
      • After Effects
      • XD
      • Captivate
      • Connect
    • Column 3
      • Dreamweaver
      • Creative Cloud
      • LiveCycle
      • AEM Forms
      • InCopy
      • All Adobe Classes
      • See All Classes
  • Private Training

  • About
  • Contact
  • Locations
  • Books
  • All classes
  • UX Classes
  • Cart
  • Log in
Breadcrumb
  1. Home
  2. Excel Classes
  3. Microsoft Excel Class Online May 8, 2023 Introduction
See how live online training works in this brief video.

See how live online training works in this brief video.

Learn about our Online Training Center

All classes include

free retakes of courses Free retakes

Curriculum provided Detailed curriculum

Live instructor Live instructor

flexible rescheduling Flexible rescheduling

flexible rescheduling Certificate of Completion

Microsoft Excel Class Online May 8, 2023 Introduction

Excel Class - Introduction

Mon, May 8 2023
Online Training

$249.00

In the introductory Excel class learn to become more efficient with managing, organizing, presenting and evaluating data. Discover how to navigate the user interface and quickly move into data entry and calculations including averages, sums, and counts. Find out how to use autofill and the quick access tool bar to save time. Understand how to use formatting to change appearance, the case of text, or remove certain characters. Discover ways to format text and cells automatically, such as positive cells appear green and negative in red. Explore how to create charts to visualize and summarize data. Learn to manage multiple Excel sheets as well as share documents through printing and exporting. This is the perfect Excel class for beginners or those who use Excel but have no formal Excel training.

Download Course Description (PDF)
See all Excel Classes

Introductory Excel class topics covered:

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

Getting started with Excel

Understand various ways of entering data in Excel. Find out how to use multiple worksheets in Excel, and learn to organize data by creating, moving, copying, and managing Excel worksheets. Find out how to work more efficiently by using repeat actions in Excel to duplicate prior actions quickly. Find out how to save time using Excel Shortcuts as you discover keyboard shortcuts that save time and help you to work more efficiently.

Getting to know the workspace

  • Understanding the Excel interface
  • Data entry using Excel
  • Moving around a worksheet using keyboard shortcuts
  • Editing in the formula bar
  • Using AutoFill
  • Naming worksheets and saving the workbook

Creating a worksheet in Excel

Understand various ways of entering data in Excel and printing from Excel as you learn how to easily print or convert Excel content to PDF. Find out how to use multiple worksheets in Excel, and learn to organize data by creating, moving, copying, and managing Excel worksheets. Find out how to work more efficiently by using repeat actions in Excel to quickly duplicate prior actions. Find out how to save time using Excel Shortcuts as you discover keyboard shortcuts that save time and help you to work more efficiently.

  • Creating a worksheet
  • Selecting cells, ranges, collections, rows, and columns
  • Inserting/deleting rows and columns
  • Inserting, deleting, hiding, copying, and moving worksheets

Formatting in Excel

Learn about formatting Excel sheets and content. Learn to visually distinguish specific text and numbers by applying formatting. Learn how to use the Format Painter in Excel: Learn to duplicate formatting from any cell and apply it to others. Applying Conditional Formatting: Discover how to apply formatting depending upon rules relating to content.

  • Formatting text, dates, and numbers
  • Changing column width and row height
  • Editing cell alignment
  • Using cell styles
  • Applying borders and using shading
  • Using the Format Painter in Excel
  • Applying conditional formatting
  • Applying themes
  • Using text functions
  • Creating and using templates

Working with charts

Learn to create line charts and sparklines to represent data visually. Find out about various chart types, including creating Column Charts using Excel as you learn to create column charts for data visualization. Discover how to create pie charts for data visualization.

  • Understanding chart types
  • Creating a chart
  • Customizing a chart
  • Printing a chart from a chart sheet or a sheet
  • Using Sparklines

Working with formulas and functions

Learn to create Excel calculations, formulas, and functions, including using Excel formulas to perform mathematical expressions.
Use True / False in Excel to check for matching data. Find out how to use Excel Functions, including AutoSum and text functions that can modify text based on input values. Also, learn about multi-Input Functions, which require multiple inputs and Constant Cell References that can be used for calculations.

  • Creating formulas
  • Using the order of operations in formulas
  • Using functions in Excel, including SUM, AVERAGE, MAX, MIN, COUNT and IF
  • Understanding cell references
  • Using formula auditing to edit formulas and functions
  • Printing your spreadsheet
  • Protecting your workbook 
Footer
  • 781-376-6044
  • CONTACT US
  • SEE ALL AGI TRAINING LOCATIONS

© Copyright 2002 - 2023 American Graphics Institute