0 reviews

Excell 2016 Expert

Instructor

Dr. Samer Sowidan

Excel 2016 Expert

Participants will gain an advanced level of understanding for the Microsoft Excel environment, and the ability to guide others to the proper use of the program’s full features – critical skills for those in roles such as accountants, financial analysts, and commercial bankers.
Participants will create, manage, and distribute professional spreadsheets for a variety of specialized purposes and situations. They will customize their Excel 2016 environments to meet project needs and increase productivity. Expert workbook examples include custom business templates, multi-axis financial charts, amortization tables, and inventory schedules.

Course Objectives

Save a workbook as a template, with colors, fonts, cell styles and themes
Reference data using structured references or data in another workbook
Protect a workbook from further editing
Prepare a workbook for internationalization
Apply custom data formats and validation
Apply advanced conditional formatting and filtering
Use form controls
Work with macros

The passing Mark to get a Certificate is 50 / 100

After you complete the course, go to my certificate section to download your certificate
In order to get your first name and last name on the certificate, please add or include those in your profile with correct spelling and as you want them to appear on the certificate. i.e. go to my profile to add your first or last name. if you already included them from the initial log-in, then no need.

Why the course contains no separate lessons?

The course is designed with a technology called scorm package where all the lessons are contained in the same course screen. You press the menu button at the top right section of the screen where a drop menu pop up and all the lessons with the case studies and tests will appear and you can select directly to go a specific lesson if you don't want to watch the lessons sequentially

Will there be a Certificate at the end of the course?

YES. there will be after getting at least 50 marks in all tests of the modules

What about the assessment questions of the course?

Every course is composed of 10 Modules. Each module has assessment questions. You must answer all of them and get a cumulative grade of at least 50% to get the Certificate of completion. The assessment questions are of different forms, such as multiple choice, fill-in-the-blank, etc.. Each module has on average 10 questions