Microsoft Office Excel is the premiere multifunctional spreadsheet program used by millions of people globally.  This program allows the user to create documents from the most complex data spreadsheets required to operate international businesses to weekly grocery lists for the family. Microsoft Excel is a powerful program in the suite of Microsoft Office products, to include Office 365 and MS Office 2019. 


Microsoft Excel 2016 contains most of the same functions found in the Office 365 and Microsoft Excel 2019 versions, is the primary spreadsheet creation program used by the South Carolina Department of Education, and is a standard program on all SCDE computer systems.


Hone your Microsoft Excel 2016 skills with these instructive training courses, designed to help you take advantage of the application’s abundant features and tools for producing professional-quality documents. In this Professional Development program, training is offered in three different levels: Beginner, Intermediate, and Expert. Each part of this course is designed to build on the last task learned, eventually taking you through every step and function the program offers, doing so in an easy to understand, demonstrative fashion to assist the learner in mastering the program.


Each course is self-paced, and can be paused and navigated to allow the learner to re-play instruction and demonstrations to gain a better grasp of the concepts. It is HIGHLY recommended that the learner download the training documents available in each training module, and use them to follow along with the instruction. The learner may also open their own Microsoft Excel 2016 program on their computer and manipulate documents as they are covered in the training.

Microsoft Office Excel 2016: Part 1 (Beginner) introduces you to the basic functions of Excel 2016, allowing you to create worksheets and effectively calculate and present your data. You’ll start by getting familiar with the Excel interface, and then learn how to create worksheets and enter data. You’ll learn how to create simple formulas to perform calculations and explore the difference between relative and absolute cell reference, a critically important understanding in Excel. You’ll discover the many options available for modifying and formatting your worksheets, along with learning how to apply conditional formatting to easily improve the readability of your data. You’ll also gain tips on how to manage your worksheets and workbooks, and how to print your documents without difficulty.


This course is the first part of our Microsoft Office Excel 2016 series, will help you prepare for the Microsoft Office Specialist exams. It features easy-to-follow visual instructions, practice files, and in-class quizzes to test your comprehension.


To learn even more advanced concepts and functions, consider taking the Excel 2016 Intermediate and Expert Level courses.


Microsoft Office Excel 2016: Part 2 (Intermediate) builds on your knowledge of the basic functionality of Excel by teaching you to perform more advanced calculations and specialized actions. To begin, you’ll develop a deeper understanding of the complex formulas and functions that allow you to extract important information from your data. You’ll discover how to sort, filter, and query data to increase the readability of your worksheets. You’ll see how to create and manipulate sophisticated tables and charts. You’ll also discover how to create PivotTables and PivotCharts to analyze and present your data with a high level of flexibility, and you'll discover helpful ways of filtering data using Timelines and Slicers.


This course is the second part of our Microsoft Office Excel 2016 series and takes approximately 2 hours and 30 minutes to complete. It features easy-to-follow visual instructions, practice files, and a final quiz to test your comprehension.


To brush up on your Excel basics, consider also taking the Excel 2016 Beginner Level course. 


To learn even more advanced concepts and functions, consider taking the Excel 2016 Expert Level course.



Microsoft Office Excel 2016: Part 3 (Expert) teaches you advanced ways of collaborating with others, automating complex tasks, and predicting future potential outcomes. To begin, you’ll learn how to track, retrieve, and consolidate data in different worksheets or workbooks. You’ll master advanced auditing tools to verify data, and you will see how to evaluate formulas to correct errors. You’ll learn how to collaborate with others while protecting the integrity of your documents. You’ll advance your understanding of macros to automate tasks and practice using Sparklines to visualize data. Lastly, you’ll learn how to utilize the power of Excel to help you predict a variety of potential outcomes.


The third part of our Microsoft Office Excel 2016 series, this course is 1 hour and 40 minutes in length and will help you prepare for the Microsoft Office Specialist exams. It features easy-to-follow visual instructions, practice files, and a final quiz to advance your skills and abilities.


To grasp a better understanding of the advanced concepts and functions discussed in this course, consider taking the Excel 2016 Basic and Intermediate Level courses first.