Online Class: Excel 2016

Dive into the world of spreadsheets with Excel 2016, as this course teaches you everything from data entry to advanced financial functions, with simple step-by-step instructions. The lessons are designed for beginners, making complex Excel operations intuitive and accessible.

COURSE CLOSED

We're sorry, this course is no longer open for enrollment.
 
  • 20
    Lessons
  • 41
    Exams &
    Assignments
  • 12
    Hours
    average time
  • 1.2
    CEUs
 
 
 

Course Description

Microsoft Excel is a spreadsheet program that comes packaged with the Microsoft Office family of software products.  Just like the other programs by Microsoft, Excel can be used for a wide variety of purposes such as creating an address book, grocery lists, tracking expenses, creating invoices and bills, accounting, balance checkbooks and other financial accounts, as well as any other purpose that requires a spreadsheet or table. 

This course will cover the many features of Excel 2016 and will teach you how to use them, starting with the simple and working to the most complicated.  The good news is that Excel 2016 makes everything easy.  By learning how to navigate the program and where to find each feature, operating Excel can become a breeze.

This course will teach you how to:

·    Create a spreadsheet

·    Format cells, rows, columns, and entire worksheets so they fit and match your data

·    Enter data into a spreadsheet

·    Use formulas and functions for math, accounting, and totaling.

·    Create formulas and functions

·    Calculate data

·    Create charts and diagrams for your data

·    Create data lists and forms

·    Create and use pivot tables and pivot charts.

·    Work with Excel templates

·    Share and protect your worksheets and workbooks

·    Use What-If Analysis to determine possible outcomes.  For example, sales goals

·    And much more
This course was designed to teach you skills you'll need to successfully use Excel 2016.   Each lesson contains instructions and illustrations to show you how to use the features, then walks you through step-by-step so you can see how everything is done.  You don't need previous experience with Excel to be able to complete this course.  This course will start with basic skills, then move forward to more advanced features and techniques.  Although you do not need access to Excel 2016 for this course; it is highly recommended. A free trial of Excel 2016 is available on the Microsoft website. 
  • 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
 
 

Course Lessons

Lesson 1. Comprehensive Guide to Leveraging Excel 2016 for Your Needs

Excel 2016's innovative tools like Smart Lookup and Ink Equations provide versatile solutions to create and analyze spreadsheets with ease, reflecting its evolution and alignment with modern data management needs. This course makes exploring these features intuitive and accessible, regardless of your prior experience. Additional lesson topics: Three Cool Things to Try in Excel 11 Total Points
  • Lesson 1 Video
  • Lesson discussions: Reasons for Taking this Course
  • Complete: Lesson 1 Assignment
  • Assessment: Exam 1

Lesson 2. Navigating Your Excel Workbook

Become adept at Excel 2016 by familiarizing with its spreadsheet concepts including active cells and the Formula Bar, which facilitates data entry and calculations. The Backstage area simplifies file tasks, while the Quick Access Toolbar and Tell Me box empower users with quick access and guidance. Additional lesson topics: Excel from Scratch; Excel Tutorial: Using the Quick Access Toolbar in Excel 11 Total Points
  • Lesson 2 Video
  • Complete: Lesson 2 Assignment
  • Assessment: Exam 2

Lesson 3. Mastering the Basics: Worksheets vs. Workbooks

In Excel, workbooks act as containers for worksheets, each beginning with one default sheet. Users can open existing workbooks, save them frequently, and manage worksheets by adding, renaming, or deleting them as needed. Additional lesson topics: Use a shared workbook to collaborate in Excel for Windows; Move or copy worksheets or worksheet data 11 Total Points
  • Lesson 3 Video
  • Complete: Lesson 3 Assignment
  • Assessment: Exam 3

Lesson 4. Efficient Data Entry in MS Excel 2016: Mastering the Basics

Excel data entry requires a bit of planning; identifying your spreadsheet's purpose and needed headings will streamline your process. Familiarize yourself with the types of data (text, values, formulas) and how Excel recognizes and processes each. Additional lesson topics: Create a drop-down list in Excel for Mac; Change axis labels in a chart in Office ; Entering and Editing Data in Excel 11 Total Points
  • Lesson 4 Video
  • Complete: Lesson 4 Assignment
  • Assessment: Exam 4

Lesson 5. Understanding Excel's Basic Data Movement Tools

This lesson dives into Excel's cut, copy, and paste functions, explaining how to move data effortlessly across cells, rows, and columns, while introducing the Clipboard's capacity to manage multiple selections. Additionally, the need for seamless data transfer is complemented by the Paste Special feature, which provides extensive options for pasting data precisely as desired. Additional lesson topics: Select cells, ranges, rows, or columns on a worksheet; How to Freeze Rows and Columns in Excel ; Insert or delete cells, rows, and columns 10 Total Points
  • Lesson 5 Video
  • Complete: Lesson 5 Assignment
  • Assessment: Exam 5

Lesson 6. Excel Formatting Essentials

Transforming a plain worksheet with formatting tools can make data appear professional and visually appealing. By tweaking fonts, colors, and styles, you can shift from a simple gridline to an elegant presentation. Additional lesson topics: Format numbers as currency in Excel ; Guidelines for organizing and formatting data on a worksheet 11 Total Points
  • Lesson 6 Video
  • Complete: Lesson 6 Assignment
  • Assessment: Exam 6

Lesson 7. Mastering Excel's Row and Column Sizing

Control Excel 2016 column widths by setting specific character counts or auto-adjusting to fit content, ensuring consistency by matching columns if necessary. Similarly, row heights can be set in points or autofit for content, all through simple mouse actions or Format menu choices. 11 Total Points
  • Lesson 7 Video
  • Complete: Lesson 7 Assignment
  • Assessment: Exam 7

Lesson 8. Excel Basics: Editing Cells

Locking and freezing panes enable users to maintain visibility of key labels while scrolling through large datasets, ensuring important information remains accessible. This is complemented by features like Spell Check and AutoCorrect, which streamline the data entry process by dealing with common typographical errors. Additional lesson topics: How to use Find and Replace in Excel most efficiently; Find or replace text and numbers on a worksheet in Excel for Windows; Playing With Find and Replace Options Microsoft Excel Beginner Lecture 11 Total Points
  • Lesson 8 Video
  • Complete: Lesson 8 Assignment
  • Assessment: Exam 8

Lesson 9. Mastering Excel: Unlocking the Power of Automated Calculations

Excel formulas require operands, references, and operators to execute mathematical tasks such as sums, with a fundamental example being the calculation of adding two values, which assists in managing data with precision. Moreover, Excel's visual cues, like blue shading for referenced cells, enhance accuracy and user ease when dealing with cell ranges and functions like SUM. Additional lesson topics: Guidelines and examples of array formulas in Excel for Windows 11 Total Points
  • Lesson 9 Video
  • Complete: Lesson 9 Assignment
  • Assessment: Exam 9

Lesson 10. From Basics to Advanced: Navigating Excel's Functions and Formulas

Inserting functions can be done directly in a cell through the Formulas tab, offering a user-friendly interface to search and select relevant functions. Excel's AutoSum feature quickly adds numbers in a column or row, making routine calculations effortless. Additional lesson topics: Overview of formulas in Excel for Windows; Working With Simple Formula Microsoft Excel Beginner Lecture 10 Total Points
  • Lesson 10 Video
  • Complete: Lesson 10 Assignment
  • Assessment: Exam 10

Lesson 11. Effortlessly Maintaining Your Excel Worksheets

Excel offers Zoom and multiple views to improve data presentation in sizeable spreadsheets, ensuring that specific areas of interest can be easily accessed and monitored. Methods like the Zoom to Selection or Page Break view facilitate targeted data analysis. Additional lesson topics: Consolidate data from multiple worksheets in a single worksheet in Excel for Windows; View two or more worksheets at the same time 11 Total Points
  • Lesson 11 Video
  • Complete: Lesson 11 Assignment
  • Assessment: Exam 11

Lesson 12. What-If Analysis in Excel: Navigating Data Tables, Goal Seeking, and Scenarios

This lesson unveils Excel's capabilities beyond spreadsheets by introducing what-if analysis tools: data tables for changing variable properties, goal seeking for reaching targets, and scenario manager to compare different forecasts. Understanding these tools enhances your ability to manage and predict complex data scenarios effectively. Additional lesson topics: Switch between various sets of values by using scenarios 11 Total Points
  • Lesson 12 Video
  • Complete: Lesson 12 Assignment
  • Assessment: Exam 12

Lesson 13. Incorporating Graphics in Excel Sheets

Excel not only allows data entry but also empowers users to enhance their spreadsheets with images and graphics for increased visual appeal and context. Users can insert pictures from multiple sources, make precise edits like cropping, color adjustments, and apply artistic effects to enrich their dynamic presentations. Additional lesson topics: Add alternative text to a picture, shape, chart, table, or SmartArt graphic; How to Add Preset Graphic Shapes in Excel 11 Total Points
  • Lesson 13 Video
  • Complete: Lesson 13 Assignment
  • Assessment: Exam 13

Lesson 14. Chart Creation Basics: Making Data Accessible

Charts and diagrams transform worksheet data into engaging visuals, facilitating easier understanding for audiences. The lesson outlines Excel’s charting features, including smart tools like Recommended Charts, while exploring various chart types and customization techniques for enhanced data presentation. Additional lesson topics: Create a chart in Excel for Mac; Create a waterfall chart in Office ; New Charts in Excel 11 Total Points
  • Lesson 14 Video
  • Complete: Lesson 14 Assignment
  • Assessment: Exam 14

Lesson 15. Organizing Information Efficiently Using Excel

Data lists in Excel function as databases for understanding and storing important details like client information, diverging from typical worksheet calculations. By setting field names and using features such as sorting and filtering, you can tailor your data organization to fit specific visualization or reporting needs. Additional lesson topics: Create a drop-down list in Excel for Windows; Sort a list of data in Excel for Mac 10 Total Points
  • Lesson 15 Video
  • Complete: Lesson 15 Assignment
  • Assessment: Exam 15

Lesson 16. Harnessing the Power of Forms for Efficient Data Handling

Excel forms offer a streamlined approach to managing overwhelming datasets by allowing targeted data entry and manipulation. Enhance productivity by linking between Excel and Access, utilizing data forms for simple tasks, and customizing worksheet forms for advanced needs. Additional lesson topics: Using a form for data entry; Add, edit, find, and delete rows by using a data form 11 Total Points
  • Lesson 16 Video
  • Complete: Lesson 16 Assignment
  • Assessment: Exam 16

Lesson 17. The Power of Pivot: Simplifying Complex Data

The Quick Analysis tool facilitates swift pivot table creation by allowing users to select data and preview table options instantly. Formatting pivot tables and inserting slicers further refines data presentation and filtering. Additional lesson topics: How to Create a Dashboard Using Pivot Tables and Charts in Excel; Introduction to Pivot Tables, Charts, and Dashboards in Excel Part 1 has good data to download for Pivot Table practice; Create a PivotChart in Excel for Windows; Create a PivotTable in Excel for Mac 10 Total Points
  • Lesson 17 Video
  • Complete: Lesson 17 Assignment
  • Assessment: Exam 17

Lesson 18. Beyond the Basics: Header, Footer, and Printing Customization

Using Excel, you can add headers and footers for a professional touch, including details like dates and sheet names. The printing process is streamlined by extensive options in the Backstage view, allowing users to adjust settings, select pages, and customize output dimensions. Additional lesson topics: Print a worksheet in landscape or portrait orientation; Preview worksheet pages before you print; Print a sheet or workbook in Excel for Mac 11 Total Points
  • Lesson 18 Video
  • Complete: Lesson 18 Assignment
  • Assessment: Exam 18

Lesson 19. Harnessing the Power of Templates in Excel 2016

Excel's set of customizable templates serves as a powerful tool to quickly create structured and visually consistent workbooks. With the ability to edit or create personalized templates from scratch, you can ensure that your data presentation aligns perfectly with your specific needs. Additional lesson topics: Create and use your own template; Learn how to use the My Cashflow template with Excel 11 Total Points
  • Lesson 19 Video
  • Complete: Lesson 19 Assignment
  • Assessment: Exam 19

Lesson 20. Safeguarding and Streamlining Your Excel Experience

Use Excel's sheet and workbook protection to lock cells or prevent unauthorized viewing and editing, ensuring your data remains secure and unaltered. Efficiently save your workbook to your preferred destination using Save or Save As, choosing from a variety of formats and storage options, including cloud services like OneDrive. 110 Total Points
  • Lesson 20 Video
  • Lesson discussions: Let us know what you think of this course; Course Comments; Program Evaluation Follow-up Survey (End of Course); Course Comments
  • Complete: Lesson 20 Assignment
  • Assessment: Exam 20
  • Assessment: The Final Exam
315
Total Course Points
 

Learning Outcomes

By successfully completing this course, students will be able to:
  • Describe what MS Excel 2016 is and what its capabilities include.
  • Demonstrate navigating Excel 2016.
  • Summarize worksheet and workbook management.
  • Summarize working with cells, rows, and columns.
  • Demonstrate formatting data and cells.
  • Demonstrate formatting rows and columns.
  • Demonstrate editing cells, rows, columns, and worksheets.
  • Summarize working with formulas and functions.
  • Define The What-If Analysis.
  • Demonstrate adding images, charts, and diagrams.
  • Summarize creating data lists.
  • Describe working with Pivot Tables and Pivot Charts.
  • Demonstrate printing worksheets and workbooks.
  • Describe using and creating templates.
  • Demonstrate protecting, saving, and sharing workbooks.
  • Demonstrate mastery of lesson content at levels of 70% or higher.
 

Student Testimonials

  • "I don't think I realized how much there was to know about excel. This is a very thorough and well constructed course." -- Leigh-ann N.
  • "I thought this course was very informative. As someone who has never used excel before, it was very thorough with walking me through the steps. I was also happy that the course provided examples as to why someone might want to do things a certain way in excel." -- Hailey D.
  • "I thought I new some basics of Excel but this class has taught me that Excel is so much more than I thought. It has been extremely helpful and informative. I feel I am able to put what I have now learnt in my day to day work at the office thereby making my use of Excel more efficient and less time consuming. Some information will need more practice but generally it was beneficial to me. Thank you." -- Marion B.
  • "I think this course was very helpful. I discovered functions I was not aware of. This course will be a great benefit and tool to apply to my office excel spreadsheets that I use on a daily basis." -- Linda J.
  • "I think the basic break down is fantastic. Excel can be scary to a new user, and this made it less so." -- Helen kate M.
  • "This course was very helpful. I've used Excel for years and still learned several new functions." -- Michael M.
  • "Very helpful. Will be taking the next level Excel course. Thank you." -- Lisa S.
  • "This course was very informative and the video was great for visual learning." -- Ruth T.
  • "I received the feedback and comments, I appreciate the time and effort to do it." -- Ryan S.
  • "I can thank you for making all this information and training available to the public. I REALLY AND TRULY appreciate it. I have every intention of taking advantage of it, and spreading the word every chance I get." -- Margaret M.
View More Testimonials...