Microsoft Excel

14 In Classroom Hours

General Information:

Call for details for the school of your choice.  - Classes start soon!  Flexible schedules.

Course Description:

Excel 2013 Complete provides the concepts and skills to be productive with Microsoft Excel 2013, starting with fundamentals and working up to advanced tools and techniques. This course maps to the objectives of the Microsoft Office Specialist and Expert exams for Excel 2013.

You will benefit most from this course if you want to use Excel 2013 to perform real-world tasks, from common workplace tasks to complex operations with large amounts of data. If you intend to take a Microsoft Office Specialist or Expert exam for Excel, this course offers complete coverage of all the objectives for both exams.

Recommended Prerequisites:  High School Graduate or GED holder. Know how to use a computer, and familiar with Microsoft Windows.

Topics Covered:

  • Chapter 1: Fundamentals
  • Chapter 2: Creating worksheets
  • Chapter 3: Formatting
  • Chapter 4: Manipulating data
  • Chapter 5: Charts
  • Chapter 6: Output
  • Chapter 7: Settings and templates
  • Chapter 9: Named ranges
  • Chapter 10: Tables
  • Chapter 11: Summarizing data
  • Chapter 12: PivotTables
  • Chapter 13: Presentation features
  • Chapter 14: Advanced charts
  • Chapter 15: Collaboration
  • Chapter 16: Logical and Lookup Functions
  • Chapter 17: Advanced Formulas
  • Chapter 18: Special functions
  • Chapter 19: Importing and Exporting
  • Chapter 20: Analysis
  • Chapter 21: Macros and Forms

Instructional Strategies:

  • Self-Directed Study
  • Skills Demonstration
  • Simulation
  • Online Activities

Methods of Evaluation:

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

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.

No Refund Policy:

No refund for course, once the first class has been concluded. If extenuating circumstances exist, case by case situations will be reviewed by ProTrain. If refund is issued, refunded amount 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.