Course Syllabus


 
 

Course Description

Mastering Microsoft Excel 2021: A Comprehensive Online Course

In the modern digital landscape, data is king. How one presents, organizes, and manipulates this data can make all the difference. Enter Microsoft Excel 2021, a part of the Microsoft 365 subscription model, hailed as a premier spreadsheet software. With a dizzying array of features, Excel 2021 offers unparalleled flexibility in crafting intricate, interactive spreadsheets that serve both functionality and aesthetics. However, as with any tool, its true potential shines when wielded with skill.

If you've ever felt overwhelmed by blank cells or baffled by complex formulas, this course is your ultimate guide. Whether you're a novice looking to grasp the basics or an experienced user aiming to delve into the software's more advanced features, this course has been tailored to cater to all levels.

Course Overview:

Start Simple:

  • Lesson 1: Dive into the world of Excel 2021 with an introduction that sets the tone.
  • Lesson 2: Familiarize yourself with the basics of workbooks and worksheets, the building blocks of any Excel project.
  • Lesson 3: Explore the myriad ways to format cells and effectively input data.

Building Complexity:

  • Lesson 4: Master advanced editing techniques to refine your worksheets.
  • Lesson 5: Unlock the true power of Excel with formulas, functions, and calculations that turn static data into dynamic stories.

Infuse Creativity:

  • Lesson 6: Learn to enhance your spreadsheets with images, illustrations, and graphics, adding a layer of visual appeal.
  • Lesson 7: Channel your inner designer with our guide to crafting effective charts and diagrams.

Deep Dives:

  • Lesson 8: Discover the 'What-If Analysis', a feature that empowers you to test and project different outcomes based on varying inputs.
  • Lesson 9: Organize large volumes of data seamlessly with data lists and forms.
  • Lesson 10: Delve into PivotTables and Charts, versatile tools for data representation and analysis.

Advanced Tactics:

  • Lesson 11: Automate repetitive tasks and custom functions by creating, recording, and executing macros.
  • Lesson 12: Integrate data from non-Excel sources, broadening your dataset.

Refining Expertise:

  • Lesson 13: Streamline and customize your data presentation with filtering, sorting, and conditional formatting.
  • Lesson 14: Become a formula wizard by employing conditional functions, IF statements, and manipulating date/time and text data.

Every lesson is structured to maximize learning. Clear instructions, vivid illustrations, and HD video tutorials ensure concepts are conveyed in a manner both engaging and easy to digest. Each module includes assignments and exams, allowing students to test and apply their newfound knowledge.

Moreover, while having access to the Excel software will undoubtedly enhance your learning experience, it isn't a mandatory requirement. The course has been designed to be comprehensive enough that even without direct software access, you can grasp concepts and techniques.

Why This Course?

The modern professional landscape demands proficiency in tools like Excel. Whether you're plotting sales data, organizing client information, or simply trying to keep track of personal expenses, Excel 2021 offers the flexibility and power to meet all these needs and more.

However, simply having the software isn't enough. Mastery comes with understanding its vast capabilities and knowing how to harness them effectively. This course is your ticket to transitioning from casual user to a true Excel aficionado.

Enroll now and take the first step towards becoming an Excel power user. Dive into a world where numbers meet narrative, and data tells a tale. Let's turn those spreadsheets into stories together!

  • Completely Online
  • Self-Paced
  • Printable Lessons
  • Full HD Video  
  • 6 Months to Complete
  • 24/7 Availability
  • Start Anytime
  • PC & Mac Compatible
  • Android & iOS Friendly
  • Accredited CEUs
Universal Class is an IACET Accredited Provider
 

Learning Outcomes

By successfully completing this course, students will be able to:
  • Demonstrate the ability to open Excel, navigate menus, and activate cells for data entry and formatting.
  • Recognize the basic layout of an Excel workbook, including rows, columns, and ribbon interface functionalities.
  • Define the difference between a worksheet and a workbook in Excel.
  • Demonstrate how to enter data and simple formulas into an Excel worksheet.
  • Demonstrate how to apply cell styles, including font changes and color highlights, to organize data visually in an Excel spreadsheet.
  • Identify the steps to format a cell with a specific numerical display, such as currency or custom formatting, in Excel.
  • Explain and apply the process of protecting worksheets and workbooks in Excel to control and manage user permissions and data security.
  • Identify and demonstrate how to accurately reference cells across multiple sheets and workbooks in Excel by utilizing appropriate syntax and formulas.
  • Define and apply Excel functions such as SUM, AVERAGE, and ROUND to perform calculations effectively within spreadsheets using appropriate syntax.
  • Demonstrate the ability to search, identify, and implement Excel functions from the function library, ensuring correct parameter input for accurate data analysis.
  • Define the steps involved in inserting an image from both local storage and online into a Microsoft Excel spreadsheet.
  • Demonstrate how to apply different formatting effects to images, such as cropping, resizing, and adding artistic effects, within Microsoft Excel.
  • Describe the steps to create a chart in Excel using the 'Recommended Charts' feature, and format it by changing color and adding a title.
  • Demonstrate mastery of lesson content at levels of 70% or higher.
 
 

Assessment Guide

Assessment Points
An Introduction 1 points
Lesson 1: Exam 16 points
Lesson 2: Exam 18 points
Lesson 3: Exam 20 points
Lesson 4: Exam 20 points
Lesson 5: Exam 20 points
Lesson 6: Exam 20 points
Lesson 7: Exam 20 points
Lesson 8: Exam 20 points
Lesson 9: Exam 20 points
Lesson 10: Exam 20 points
Lesson 11: Exam 20 points
Lesson 12: Exam 18 points
Lesson 13: Exam 20 points
Lesson 14: Exam 20 points
The Final Exam 158 points
Communications Courses
Communications Courses
How to Produce Statements in QuickBooks Online
How to Produce Statements in QuickBooks Online
How to Search Messages in Slack
How to Search Messages in Slack
How to Create VIEWs in SQL
How to Create VIEWs in SQL
Business Writing Courses
Business Writing Courses
Operations Management Courses
Operations Management Courses
Cybersecurity 101
Cybersecurity 101
Google Slides
Google Slides
QuickBooks Courses
QuickBooks Courses
Microsoft Excel Courses
Microsoft Excel Courses
Microsoft Word Courses
Microsoft Word Courses
Microsoft PowerPoint Level 1
Microsoft PowerPoint Level 1
What is Slack?
What is Slack?
Computer Literacy Level 2 - Internet Basics
Computer Literacy Level 2 - Internet Basics
How to Purchase and Enter Inventory in QuickBooks Online
How to Purchase and Enter Inventory in QuickBooks Online
Tables, Databases, and SQL...oh my!
Tables, Databases, and SQL...oh my!
Microsoft Office: Word, Excel, PowerPoint and Outlook
Microsoft Office: Word, Excel, PowerPoint and Outlook
Ultimate Excel Training Bundle
Ultimate Excel Training Bundle