Full Intermediate Course on MS Excel 2013

COURSE DESCRIPTION

This course focuses on the intermediate experience one needs to perform professional official tasks. By completing this course, one will be able to perform tasks professionals in data science and entry fields do. In our first course, Introduction To MS Excel, we introduced all students who enrolled in the course to the basic methods of using this program. Data Entry jobs are one of the most professions that are given more income to workers who master this software.

CERTIFICATION

Again this is level two of the main designed course. Although this, in addition, makes two completed courses, the certificate will be awarded to a student who has successfully completed the three stages of studies so far as this data entry software is concerned. All students will have to pass all assessments in every stage of the courses related to the program.

LEARNING OUTCOMES

• Create Charts
• Gridlines, Labels, and Data Tables
• Modify Chart Data
• Print Titles, Gridlines, and Headings
• Layout and Style
• Build intermediate formulas using absolute & relative cell references.
• Share & protect workbooks to collaborate with others.
• Add conditional formatting to highlight data that meets your criteria.
• CONCAT Function
• PMT and NPER Functions
• Data Validation
• Flash Fill
• Table Styles
• Structured References
• Create and Modify Cell Styles
• Share Workbooks
• Co-author Workbooks
• Protect a Worksheet
• Protect Workbook Structure
• Password Protection