Coronavirus (COVID-19) information: All courses at all locations are available as live online classes. Limited in-person classes in some locations. Our offices remain open. Learn more.

×

Microsoft Excel Class Online October 21, 2020 Introduction

Microsoft Excel Training Class - Introduction

Wed, Oct 21 2020
10:00 am to 5:00 pm
American Graphics Institute American Graphics Institute
Online Training
American Graphics Institute AGI Training Online Online

2012-06-25 16:58:26 $249.00

Learn Excel and 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.

Download Course Description (PDF)     See all Excel Classes

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.