Back to Learning Catalog

Status

Open

Estimated Completion Time

18 weeks

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

  • Excel Overview
    Students will demonstrate an understanding of Excel by creating, formatting, adding data and editing worksheets, and using Excel as an information management tool.
  • Data and Tables
    Students will demonstrate an understanding of data and tables in Excel by creating tables with data, using advanced formatting techniques and styling tools, and applying advanced analysis tools.
  • Formulas, Functions, and Charts
    Students will demonstrate an understanding of Excel formulas, functions and charts by creating formulas, utilizing functions provided by Excel, and creating charts to aid in interpreting data.
  • Excel in the Workplace
    Students will demonstrate an understanding of using Excel in the workplace by investigating the use of data management in business and the use of Pivot Tables and PivotCharts.

Pre-Requisites

None

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.