Course Offerings

Introduction to Microsoft Excel 365

Excel is a powerful tool and indispensable for business, personal and academic use. In this course, you gain a strong foundation in Microsoft Excel 365, equipping you with the skills to confidently navigate Excel's features. Whether organizing data, creating professional spreadsheets or generating insightful visualizations, this introduction to Excel course provides the tools and techniques to maximize your efficiency with this industry-leading spreadsheet software program.

Beginning with the basics of how to enter labels and numeric data, you learn ways to structure and format your worksheets for clarity and efficiency. This intro to Excel course shows you how to modify a worksheet's structure by inserting, deleting and formatting rows and columns and explores formatting options to make your data visually appealing and easy to interpret. From applying number formats to text styling, you gain the skills to transform plain data into professional-grade spreadsheets.

Next, dive into calculation capabilities, starting with simple formulas and progressing to aggregate functions. You practice using references to cells and ranges, troubleshoot formula errors and explore tools like autofill and quick analysis to save time and streamline your workflow. You also learn how to apply headers, footers and themes to give your worksheets a polished, cohesive appearance, as well as how to prepare your spreadsheets for printing.

In addition to foundational skills, this course introduces advanced techniques like working with multiple sheets and referencing data across workbooks. You create and format tables, sort and filter data, and generate dynamic charts to visualize trends and insights. Next, explore statistical and financial functions essential for analyzing data in a business context. Finally, practice creating business forms, using templates and designing workbooks that maximize efficiency and usability.

Course Objectives

Gain a solid understanding of Excel's core features and advanced capabilities

Use hands-on practice and real-world examples to boost your ability to successfully learn Excel online and enable you to tackle various tasks confidently

Outline of Instruction

Getting to Know Excel

Modifying a Worksheet's Structure

Using Formulas and Functions

Formatting Cells and Their Content

Formatting and Printing a Worksheet

Referring to Cells, Ranges and Formulas

Using Multiple Sheets and Workbooks

Working with Tables

Charting Data

Using Aggregate, Statistical and Financial Functions

Creating Business Forms

Working with Templates

Contact Hours

CEUs

Industry Standard, State or National Certification

Certification

None

Website

None

Certification Learning Outcomes/Requirements

CE or CU Articulation

Prerequisites

N/A

Learning Supplies Needed

Hardware requirements:
This course can be taken on either a PC or a Mac.

Software requirements:
PC: Windows 10 or later
Mac: macOS 12 or later
Browser: The latest version of Google Chrome or Mozilla Firefox is preferred. Microsoft Edge and Safari are also compatible.
Microsoft Excel 365 for Windows or Microsoft Excel for Mac. Excel 365 Online can be used to study the features it includes, but you will not be able to practice certain skills. For the best experience, use Excel 365 for Windows or Word for Mac to complete this course. If that software isn't available, some exercises can be completed using Excel 365 Online in a web browser on Windows, MacOS or ChromeOS.
Adobe Acrobat Reader
Software must be installed and fully operational before the course begins.

Other:
Email capabilities and access to a personal email account

Instructional material requirements:
The instructional materials required for this course are included in enrollment and will be available online.

Clinical Site/Special Facilities

N/A

Requirements for Successful Completion

90% attendance
Students must pass 10 quizzes with a minimum grade of 70% by the second quiz attempt. If all quizzes are not passed with 70% or better by the second attempt, the final exam score must be 70% or higher on the first attempt. The final exam must be taken by the Wake Tech course end date.