Back to Learning Catalog

Status

Open

Estimated Completion Time

18 weeks

Enroll/Extend in Adult Education Excel click here

Overview

Discover the real-world uses of Microsoft Excel and its impact upon business, academic, and personal applications. Move from inserting and manipulating data, to working with tables, charts, graphs, and calculations. Content of this course will also be applicable to the Microsoft Office Suite certification exam.

During this course, you will learn career-related skills and earn a badge for this accomplishment. A badge is a digital certification of your career-related learning that you can share on social media and higher education platforms, or with colleges, potential employers, peers, and colleagues. Select this link to learn more about badges.

Course Requirements

Required Materials:

  • Microsoft Office Excel 2019, or an Office 365 Subscription

Major Topics and Concepts

Unit 1: Using Excel

  • Explain how Excel can help both businesses and individuals meet their management information needs
  • Download, create, and save an Excel workbook
  • Open, save, and enter data into an Excel workbook
  • Plan appropriate uses of Excel within a business setting
  • Make basic changes to formatting and location of data within a worksheet and utilize data ranges to perform basic calculations

Unit 2: Customizing and Configuring

  • Configure and customize views for Excel worksheets, as well as page options and formatting
  • Sort and filter data, including default and custom options
  • Print data from an Excel workbook efficiently
  • Utilize the Quick Access Toolbar and change the available options

Unit 3: A Range of Data

  • Use advanced techniques to enter or change data in Excel
  • Format content using advanced formatting tools such as number or date formatting
  • Edit content effectively utilizing visual tools and graphs
  • Create a successful ePortfolio

Unit 4: Creating and Managing Tables

  • Apply advanced styling tools, such as banding, to tables
  • Manage intermediate Excel functions such as conversions and calculations
  • Analyze the direction Excel as software is headed in
  • Create and manage advanced tables and options

Unit 5: Fun with Formulas and Functions

  • Utilize the most common functions in Excel
  • Set up and manipulate formulas
  • Explain common uses of formulas and functions in a business context
  • Perform advanced calculations through the use of formulas and functions

Unit 6: Organization Essentials: Charts and Data

  • Create and set up different types of charts
  • Edit, update, and manipulate all kinds of visual tools
  • Use visualization tools in order to present data to a non-expert audience
  • Work with new tools and charts in Excel

Week 7: Excel at Work

  • Use Excel to record, edit, and maintain data in the workplace
  • Work with advanced PivotTables and PivotCharts
  • Describe how Excel works with other Microsoft Office products
  • Utilize Excel for practical tasks at work

Week 8: Pulling It All Together

  • Identify the correct tool for a complex task in Excel
  • Switch between different tools and skillsets while working
  • Properly prepare an Excel file for distribution and presentation in a business environment
  • Share and collaborate on a workbook, track changes and accept or reject them

Credits .5

Competencies

  • Customizing Excel
    Students will demonstrate an understanding of Excel customization by describing how to configure display preferences, explaining the organization of information, and summarizing various ways to protect information.
  • Excel Basics
    Students will demonstrate an understanding of Excel basics by summarizing the basic functions and features of Excel, describing the data-formatting process, and explaining common uses of Excel in business.
  • Excel in the Workplace
    Students will demonstrate an understanding of Excel basics by summarizing the basic functions and features of Excel, describing the data-formatting process, and explaining common uses of Excel in business.
  • Functions in Excel
    Students will demonstrate an understanding of functions in Excel by explaining the use of functions, explaining various syntax rules, and describing the use of advanced functions.
  • How to Display Data
    Students will demonstrate an understanding of data display by explaining the operation of data formatting functions and describing the importance of an ePortfolio.
  • How to Work with Charts
    Students will demonstrate an understanding of how to work with charts by describing ways to manipulate information within charts and describing the functions of various types of charts.
  • Table Management
    Students will demonstrate an understanding of table management by explaining the features of a pivot table, describing ways to customize tables, and describing the basic principles of using “totals.”
  • Using Excel Tools
    Students will demonstrate an understanding of the use of Excel tools by describing special tools in Excel and explaining the procedures for collaborating in an Excel file.

Pre-Requisites

None
Enroll Now

Attend a virtual open house

We offer regular online open house webinars where VLACS staff members provide parents and students with an overview of our programs and answer questions about online learning.

Register Today