COM4222 - MS Excel 365 using 2019 platform (Easy as 1,2,3)
Validation error
You must correct the following errors to continue:
Course Description
By the end of this course, users should be comfortable with: creating a new spreadsheet, working with basic formulae, making a spreadsheet look professional and presentable, and saving and printing a spreadsheet.
We will cover how to create and use advanced formulas, analyze data, organize worksheet data with tables, visualize data with charts, insert graphics, and enhance workbooks.
We will cover how to automate worksheet functionality, audit worksheets, analyze data, work with multiple workbooks, export Excel data, as well as import and export XML data.
Course Outline
This first part of the course is intended to help all users become familiar with the more advanced selection of features of Excel. We will cover how to create and use advanced formulas, analyze data, organize worksheet data with tables, visualize data with charts, work with graphical objects, and enhance workbooks.
This second part of the course is intended to cover different features including creating a new spreadsheet, working with basic formulas and functions, making a spreadsheet look professional and presentable, and saving and printing a spreadsheet.
This third part of our Microsoft 35 Excel courseware is intended to help all users get up to speed quickly on the advanced features of Excel. By the end of this course, students should be comfortable in both the online and desktop environments, using automating functions, analyzing and presenting data, auditing and error checking their work, working in multiple workbooks, and accessing and distributing data.
Prerequisites
This manual assumes that the user understands the basics of using a Windows-based computer. Students should be comfortable using the keyboard, mouse, and Start menu. Understanding and experience with printing and using a web browser is an asset, but not required. No previous experience with other versions of Excel is necessary.