You must be logged in to take this course → LOGIN | REGISTER NOW
The Microsoft Excel program was designed to help people in their worksheets and spreadsheets. This course will teach you how to use SmartArt, pictures, text boxes and shapes to enhance your ability. You will learn to utilize many objects which have contextual tool tabs that appear when you select an object. Learn how to solve formula errors before they happen by using named ranges instead of cell references.
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
Microsoft Excel - Advanced Level | |||
Module One – Getting Started | 01:00:00 | ||
Module Two – SmartArt and Objects | 01:00:00 | ||
Module Three – Auditing | 01:00:00 | ||
Module Four – Creating Charts | 01:00:00 | ||
Module Five – Working with Charts | 01:30:00 | ||
Module Six – Creating Pivot Tables and Pivot Charts | 01:00:00 | ||
Module Seven – Macros | 01:00:00 | ||
Module Eight – Solving Formula Errors | 01:00:00 | ||
Module Nine – Using What If Analysis | 01:00:00 | ||
Module Ten – Managing Your Data | 02:00:00 | ||
Module Eleven – Grouping and Outlining Data | 01:00:00 | ||
Module Twelve – Wrapping Up | 00:30:00 | ||
Activities | |||
Activities-Microsoft Excel – Advanced Level | 00:00:00 | ||
Assessment | |||
Submit Your Assignment | 00:00:00 |
Course Reviews
No Reviews found for this course.