Microsoft Excel for Professional Users

Hours: 16 / Access Length: 3 Weeks / Delivery: Monthly, Mentor Supported
Retail Price: $210.00

Course Overview:

Students will advance their Microsoft Excel skills by exploring more advanced topics in Excel. Students will learn to create three-dimensional workbooks, and to link workbooks. Students will create financial forecast spreadsheets using the Excel financial functions. Students will learn to work with the workgroup features of Excel. Students will learn to import data into an Excel spreadsheet and will work with the data using the data management functions of Excel. Students will create Excel macros and will learn the basics of VBA. Students will need a basic understanding of Excel to complete this class. Students will need a copy of Office. A 60-day trial version is available.

ATTENTION: This course has a strict start and end date.  When a student enrolls into this course, they will need to work with one of our Training Assessment Managers (TAMs) to choose a start date before they can be enrolled in their course.

Course Outline:

• Students will demonstrate what they have done with Excel
• Students will link data in other workbooks, define and summarize multiple data sets and group them.  Students will also use tools to summarize and find solutions to problems as well as analyze statistical data.
• Students will learn to create PivotTables, Charts and Graphs.
• Students will learn to create macros and to use special printing tools.
• Students will learn to share information across other programs and to use tools to collaborate with others.
• Students will use Microsoft Excel to build a final project using what they have learned in this class.

All necessary materials are included.

System Requirements:

• Cable and DSL internet connections are recommended for the best experience.

• CPU: 1 GHz or higher
• RAM: 2 GB or higher
• Resolution: 1280 x 720 or higher
• Speakers / Headphones
• Microphone (Webinar / Live Online sessions)

• Microsoft Windows 7 or 10 (Home, Pro)
• Mac OSX 10 or higher.
• Latest Chrome OS
• Latest Linux Distributions

NOTE: While we understand that our courses can be viewed on Android and iPhone devices, we do not recommend the use of these devices for our courses. The size of these devices do not provide a good learning environment for students taking online or live online based courses.

• Latest Google Chrome is recommended for the best experience.
• Latest Mozilla FireFox
• Latest Microsoft Edge
• Latest Apple Safari

• Office suite software (Microsoft Office, OpenOffice, or LibreOffice)
• PDF reader program (Adobe Reader, FoxIt)
• Courses may require other software that is denoted in the above course outline.