Microsoft Office Excel 2016 (Basic, Intermediate, Advanced) - Live Online

30 Hours / Access Length: Schedule Varies / Delivery: Live Online, Instructor Led
Retail Price: $600.00

Course Overview:

Microsoft Excel is the standard spreadsheet application for both personal and business use, so staying on top of the latest version is very important for anyone considering career advancement. Regardless of your level of understanding, you will benefit from this Microsoft Excel 2016 training course because it covers basic, intermediate and advanced competency levels.  

Our Microsoft Excel 2016 training course will help arm you with the knowledge to use it more effectively whether you are using it at home or in the workplace. Understand how to manipulate data within a spreadsheet, validate and present information using the built in structure and functions of Microsoft Excel.

This course prepares students to take the Microsoft Office Specialist: Excel Associate ​certification exam.

Recommended Prerequisites:  High School Graduate or GED holder. Operating knowledge of Windows or equivalent operating system.

This course includes:

• Visual Demonstrations & Multimedia Presentations
• Quizzes & Exam Simulators
• Social Learning & Networking
• Flash Cards & Educational Games
• Enhanced Navigation and Controls

Course Outline:

Excel Beginner

• 1.1 Tabs And Ribbons Part 1
• 1.2 Tabs And Ribbons Part 2
• 1.3 Cells Part 1
• 1.4 Cells Part 2
• 1.5 Cells Part 3
• 1.6 Cells Part 4
• 1.7 Calculations Part 1
• 1.8 Calculations Part 2
• 1.9 Calculations Part 3
• 1.10 Printing Part 1
• 1.11 Printing Part 2

Excel Intermediate

• 1.1 Menus And Keyboard Shortcuts Part 1
• 1.2 Menus And Keyboard Shortcuts Part 2
• 1.3 Menus And Keyboard Shortcuts Part 3
• 1.4 Tabs Part 1
• 1.5 Tabs Part 2
• 1.6 Formulas And Calculations Part 1
• 1.7 Formulas And Calculations Part 2
• 1.8 Formulas And Calculations Part 3
• 1.9 Formulas And Calculations Part 4
• 1.10 Importing Data Part 1
• 1.11 Importing Data Part 2
• 1.12 Invoices

Excel Advanced

• 1.1 Advanced Invoice Part 1
• 1.2 Advanced Invoice Part 2
• 1.3 Advanced Invoice Part 3
• 1.4 Advanced Invoice Part 4
• 1.5 Number Crunching
• 1.6 Creating A Pivot Table From Scratch
• 1.7 Smaller Excel Components Part 1
• 1.8 Smaller Excel Components Part 2
• 1.9 Smaller Excel Components Part 3

Instructional Strategies:

• Self-Directed Study
• Skills Demonstration
• Simulation

Methods of Evaluation:

• Quizzes & Exams
• Skills Demonstration
• Learner-Centered Activities

Instructor Biography:

Coming soon!

Grading System:

Student must pass all quizzes, exams, and national exam (if applicable) at a passing rate to be eligible for a Certificate of Training Completion. If an internship is included in your course you will be required to complete the internship prior to receiving a Certificate of Training Completion.

Attendance:

Students are expected to arrive on time and participate in course discussions. Successful completion of the course of study recommends 100% attendance. If during the course period the student’s attendance level drops below 80%, they will be encouraged and given the opportunity to attend the next scheduled class for the course they enrolled in. Should materials change, student is responsible for all additional cost.

Payment Plan Policy:

Students may withdraw from the program for any reason up to 1 week prior to the start of program. In this case, the student’s payment plan agreement shall be rescinded. If the payment plan has begun a non-refundable administrative fee of $25.00 will be assessed and remaining funds will be returned to payer in check form by mail.

Refund Policy: 

There can be no refund for the course, once the first class has been concluded; or if any course material, including the eBook, is accessed. If extenuating circumstances exist, case by case situations will be reviewed by ProTrain. If a refund is issued, the refunded amount (- a $25 processing fee) will be dependent upon books being returned in excellent condition (i.e. no writing, missing pages; ripped or damage to pages and/or binding).

Re-Admission Policy:

Any student who has dropped out of the program, or has been suspended from the program for nonattendance may be readmitted within one year by completing a personal interview with the director of education and paying any applicable fees at the time of readmission. Students who were terminated due to conduct issues are not eligible to be readmitted.

Policy on Student Conduct:

Appropriate Conduct: All students are expected to conduct themselves in an orderly and professional manner. Any student not conducting themselves in an orderly and professional manner, which includes use of drugs and alcohol during school hours, dishonesty, disrupting classes, use of profanity, excessive tardiness, insubordination, violation of safety rules, improper usage of lab or classroom computers, or not abiding by the school rules will lead to either probation or dismissal from classes.

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.