High School

Excel

0.5 Credits
18 weeks
Open

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.

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

Course Materials

Required Materials:

  • Microsoft Office Excel 2019, or an Office 365 Subscription

Competencies

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.

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.

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.

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.”

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 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.

Excel in the Workplace

Students will demonstrate an understanding of Excel in the workplace by describing ways to increase efficiency when using Excel, describing common uses of Excel in the workplace, and describing other applications within the Microsoft Office Suite.

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.