Excel 2016 is the latest version of the most popular computing and organizing application. To know more about the new tools and features of this application, this course is created for you and other professionals who want to know more about Excel 2016.
The main objective of this [course_title] is to teach you different techniques in utilizing the application. You will be fully equipped with knowledge and skills in Excel 2016 after taking this course.
Assessment
This course does not involve any written exams. Students need to answer 5 assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Each answer needs to be 200 words (1 Page). Once the answers are submitted, the tutor will check and assess the work.
Certification
Edukite courses are free to study. To successfully complete a course you must submit all the assignment of the course as part of the assessment. Upon successful completion of a course, you can choose to make your achievement formal by obtaining your Certificate at a cost of £49.
Having an Official Edukite Certification is a great way to celebrate and share your success. You can:
- Add the certificate to your CV or resume and brighten up your career
- Show it to prove your success
Course Credit: Edukite
Course Curriculum
Apply Range Names | 00:30:00 | ||
Use Specialized Functions | 00:30:00 | ||
Use Text Functions | 00:30:00 | ||
Use Logical Functions | 00:30:00 | ||
Use Lookup Functions | 00:30:00 | ||
Use Date Functions | 00:30:00 | ||
Use Financial Functions | 00:30:00 | ||
Create and Modify Tables | 00:30:00 | ||
Sort and Filter Data | 00:30:00 | ||
Use Subtotal and Database Functions to Calculate Data | 00:30:00 | ||
Create Charts | 00:30:00 | ||
Modify and Format Charts | 00:30:00 | ||
Create a Trendline | 00:30:00 | ||
Create Advanced Charts | 00:30:00 | ||
Create a PivotTable | 00:30:00 | ||
Filter Data by Using Slicers | 00:30:00 | ||
Analyze Data with PivotCharts | 00:30:00 | ||
Insert and Modify Graphic Objects | 00:30:00 | ||
Layer and Group Graphic Objects | 00:30:00 | ||
Incorporate SmartArt | 00:30:00 | ||
Customize Workbooks | 00:30:00 | ||
Manage Themes | 00:30:00 | ||
Create and Use Templates | 00:30:00 | ||
Protect Files | 00:30:00 | ||
Preparing a Workbook for Multiple Audiences | 00:30:00 | ||
Activities | |||
Activities and Exercise Files – Microsoft Excel 2016 Intermediate | 00:00:00 | ||
Assessment | |||
Submit Your Assignment | 00:00:00 | ||
Certification | 00:00:00 |
Course Reviews
No Reviews found for this course.