Completion for Microsoft Excel A-Z هذه الدورة تدرس باللغة الإنجليزية

تفاصيل الدورة

Overview

Completion for Microsoft Excel A-Z

This beginner to expert course is designed to give students, not just the basic understanding of excel but also to teach them the various functions of excel, which will immensely benefit them at work. These include pivot tables, formulas, macros and VBA data analysis. Our objective is to make you an excel expert.

This course will fully prepare you for any Excel related career path, plus those that require advanced skills with this software. Once you complete the course, you’ll have access to the full functionality of Excel, and will know how to use all formulas, functions, and capabilities.

It doesn’t matter if you are new to excel or are just looking to improve your excel skills- this course caters to both and after the completion of this course you will have full knowledge of the functionality of excel.

Why You Should Consider Taking this Course at Study365?
Study365 is a leading online provider for several accrediting bodies, and provides learners the opportunity to take this accredited iAP course. At Study365, we give our fullest attention to our learners’ needs and ensure they have the necessary information required to proceed with the training.

Learners who register will be given excellent learning support, discounts for future purchases and be eligible for a TOTUM Discount card and Student ID card with amazing offers and access to retail stores, the library, cinemas, gym memberships and their favourite restaurants.

Description

Learning Outcome

• Learn to master Excel from A-Z
• How to save hours of time and boost your productivity in Excel
• How to use math, statistical, logic and text functions
• How to create basic and advanced formulas

Curriculum

[Module 01]Excel From A-Z Course Introduction

[Module 02]Getting Started With Excel

[Module 03]Values Referencing And Formulas

[Module 04]Introduction To Excel Functions

[Module 05]Adjusting Excel Worksheets

[Module 06]Visually Pleasing Cell Formatting

[Module 07]How To Insert Images And Shapes!

[Module 08]Visualize Data With Charts

[Module 09]Excel’s Printing Options

[Module 10]Benefits Of Using Excel Templates

[Module 11]Working With Excel Datasets

[Module 12]Excel Database Functions

[Module 13]Excel Data Validation

[Module 14]Excel Pivot Tables

[Module 15]Excel’s powerpivot add-in

[Module 16]Excel Conditional Functions

[Module 17]Excel’s Lookup Functions

[Module 18]Text Based Functions In Excel

[Module 19]Auditing Formulas & Custom Views In Excel

[Module 20]Excel’s “What If?” Tools

[Module 21]Welcome To Excel VBA!

[Module 22]The VBA Language

[Module 23]Writing VBA Code

[Module 24]Important VBA Tools And Logic

[Module 25]Excel VBA Loops

[Module 26]Triggering Macros

[Module 27]Excel User Forms

[Module 28]Starting A Career In Excel

Method of assessment
This is a knowledge-based course, and thus, will contain no method of assessment.

Certification
Upon the successful completion of the course, learners will be awarded an accredited Certificate of 'Completion for Microsoft Excel A-Z' by iAP.

Awarding Body
The International Awards for Professionals (iAP) is an awarding body established in 1999 that aims to promote a high educational standard. They hope to create online education that is trustworthy and credible. They are focused on raising the standards of online education, and ensuring it is accessible to all. The iAP provides accreditation for a range of educational establishments, and monitors and continually develops the educational standards of such institutions. Their globally recognised certifications allow learners to acquire the skills and knowledge needed to gain employment in the chosen fields. تحديث بتاريخ 01 March, 2024