Microsoft Excel Comprehensive

Hours: 32 / Access Length: 7 Weeks / Delivery: Monthly, Mentor Supported

Retail Price: $375.00

Course Overview:

This class will give you a working knowledge of electronic spreadsheets, what they are and how to use them. You will be able to create and format professional looking Excel spreadsheets that include charts and multiple worksheets. You will be able to create and execute formulas, Excel functions, perform data sorting, import data, and create linked workbooks.  You will create Excel macros and will learn the basics of VBA.  The skills learned in this class are ones valued by employers.  Students will need a copy of Office.

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 learn the purpose of using spreadsheets for business as well as personal use.
• Students will create and modify workbooks and customize the program window.
• Students will learn to quickly enter, edit and move data as well as proof it and organize it using tables.
• Students will learn to use formulas and functionas as well as dress up the appearance of their spreadsheets.
• Students will learn to filter, manipulate, sort, subtotal and look up list data.
• 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:

Internet Connectivity Requirements:

• Cable, Fiber, DSL, or LEO Satellite (i.e. Starlink) internet with speeds of at least 10mb/sec download and 5mb/sec upload are recommended for the best experience.

NOTE: While cellular hotspots may allow access to our courses, users may experience connectivity issues by trying to access our learning management system.  This is due to the potential high download and upload latency of cellular connections.   Therefore, it is not recommended that students use a cellular hotspot as their primary way of accessing their courses.

Hardware Requirements:

• CPU: 1 GHz or higher
• RAM: 4 GB or higher
• Resolution: 1280 x 720 or higher.  1920x1080 resolution is recommended for the best experience.
• Speakers / Headphones
• Microphone for Webinar or Live Online sessions.

Operating System Requirements:

• Windows 7 or higher.
• 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.

Web Browser Requirements:

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

Basic Software Requirements (These are recommendations of software to use):

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