Microsoft Excel - From Beginner to Certified Professional

What Do His Students Have to Say?

"Scott made learning Excel fun!" | "Thank you for your videos you explain in a way which everyone can understand!!!" | "This guy has the right balance between humor and info in my opinion. Thank you!"

About The Course

Microsoft Excel is the spreadsheet program of choice for companies, governments agencies, and organizations around the world. We have specifically designed this course to help you go from beginner to a certified professional.

In this course, you will learn how to use the most recent versions of Microsoft Excel, the 2019 and constantly updated Office 365 version.

This course follows the objectives created by Microsoft and ensures that not only will you develop the knowledge, skills, and abilities (KSAs) to use Excel but you will also be prepared to take and pass the Microsoft Office Specialist 77-727 Excel Core exam.

In this course you will develop the KSAs to:

• Create worksheets and workbooks
• Navigate through worksheets and workbooks
• Format worksheets and workbooks
• Customize options and views for worksheets and workbooks
• Configure worksheets and workbooks to print or save
• Insert data in cells and ranges
• Format cells and ranges
• Summarize and organize data
• Create and manage tables
• Manage table styles and options
• Filter and sort a table
• Summarize data by using functions
• Perform conditional operations by using functions
• Format and modify text by using functions
• Create a chart
• Format graphic elements
• Insert and format objects