MS Excel 2013 Intermediate Level

MS Excel 2013 Intermediate Level

Course Description:

Microsoft Excel is the most commonly used spreadsheet application. Learning how to use Excel is an investment in both your personal and professional life. Excel makes it easy to monitor financial performance, such as business profit or loss, calculate payments on large purchases, plan a budget, or stay organised with checklists. This course is intermediate level, so will be helpful for those who have basic knowledge of Microsoft Excel.

Our online courses offer you the opportunity to study 24/7 wherever you are in the world. These intensive on line courses are open to anyone with an interest in the topic and give you access to world-class learning led by IAP.

Course Curriculum Total Units : 11
1: Apply Range Names
2: Use Specialized Functions
3: Analyzing Data with Logical and Lookup Functions
4: Insert and Modify Graphic Objects
5: Layer and Group Graphic Objects
6: Customizing Workbooks
7: Manage Themes
8: Create and Use Templates
9: Protect Files

What skills will I gain?

• Learn how to manage cell contents in a worksheet
• Learn how to create financial reports
• Understand accounting formulas, functions & specialised functions
• Learn cell attributes & cell formatting
• Gain a full understanding of printing excel sheets
• Logging in to this course, you’ll learn how to insert & modify graphic objects
• Learn conditional formatting and data validations
• Learn how to export, import & integrate data with other sources

What is the target audience?

• Job hunters & School leavers
• College or University students, graduates & Teachers
• Personal assistant & Receptionist
• Assistant for company director
• Office Administrators & Office managers
• Office clerk, Marketing assistant & Administration Assistant
• Secretary or Executive
• Account assistance, Bookkeeper & Accountant
• IT professionals & Businessman

How will I be assessed?

• At the end of the course learners will take an online multiple choice question assessment test. This online multiple choice question test is marked automatically so you will receive an instant grade and know whether you have passed the course.
• Those who successfully pass this course will be awarded a free e-certificate, and only need to pay £19 for your printed certificate.

What Certification am I going to receive?

If you pass the exam successfully then you will be awarded a Microsoft Excel 2013 Intermediate Level Training Certificate.