Level 3 Diploma in Microsoft Excel
193 Students
GET ACCESS TO THIS COURSE ALONG WITH 2500+ COURSES FOR A YEAR FOR JUST £49. GET NOW
14-Day Money-Back Guarantee
-
1 Year
Access -
Level 3 - Diploma
Skill Level -
Course Certificate
Certificate -
42
Units -
2
Quizzes -
1 day, 9 hours
Duration
Description:
Whether you use excel for work or study, this online course covers beginner, intermediate and advanced lessons in excel. This course is designed to enable you to analyse lots of data and tell a story quickly and interactively. Explore various time-saving Formulas, create automated reports with the press of a button, amaze your manager with professional Excel Charts and get noticed by top management & prospective employers.
Who is this course for?
- This course is perfect for individuals who are looking forward to developing their skills of using Microsoft Excel application.
- This course is for office professionals who want to nail all the meetings and projects at the workplace.
- This course will be ideal for professionals in business, finance and many other areas that need to analyse data in accounts.
Entry Requirement:
- This course is available to all learners, of all academic backgrounds. However, an education and experience in accounting is an advantage.
- Learners should be aged 16 or over to undertake the qualification.
- Good understanding of English language, numeracy and ICT are required to attend this course.
Assessment:
- At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful.
- Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam.
Certification:
- After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24.
- PDF certificate’s turnaround time is 24 hours and for the hardcopy certificate, it is 3-9 working days.
Why choose us?
- Affordable, engaging & high-quality e-learning study materials;
- Tutorial videos/materials from the industry leading experts;
- Study in a user-friendly, advanced online learning platform;
- Efficient exam systems for the assessment and instant result;
- The UK & internationally recognised accredited qualification;
- Access to course content on mobile, tablet or desktop from anywhere anytime;
- The benefit of career advancement opportunities;
- 24/7 student support via email.
Career Path:
The diploma in Microsoft Excel will be very beneficial and helpful, especially to the following professionals:
- Admin Assistant.
- PA.
- Secretary.
- Administrator.
- Account Assistant.
- Bookkeeper.
- Accountant.
- Office Manager.
-
Module One – Getting Started 00:30:00 -
Module Two – Opening Excel 01:00:00
-
Module Three – Working with the Interface 01:00:00
-
Module Four – Your First Worksheet 01:00:00
-
Module Five – Viewing Excel Data 01:00:00
-
Module Six – Building Formulas 01:00:00
-
Module Seven – Using Excel Functions 01:00:00
-
Module Eight – Using Quick Analysis 01:00:00
-
Module Nine – Formatting Your Data 01:00:00
-
Module Ten – Using Styles, Themes, and Effects 01:00:00
-
Module Eleven – Printing and Sharing Your Workbook 01:00:00
-
Module Twelve – Wrapping Up 01:00:00
-
Activities- Microsoft Excel – Beginners Level
-
Module One – Getting Started 00:30:00
-
Module Two – Working with Permissions and Options 00:30:00
-
Module Three – Sharing Workbooks 00:30:00
-
Module Four – Performing Advanced Formula and Function Tasks 00:30:00
-
Module Five – Working with Array Formulas 01:00:00
-
Module Six – Working With Macros 00:30:00
-
Module Seven – Working With Forms 00:30:00
-
Module Eight – Applying Advanced Chart Features 01:00:00
-
Module Nine – Working With Slicers and Timelines 00:30:00
-
Module Ten – Working With Multiple Tables, Relationships and External Data 00:30:00
-
Module Eleven – Working With PowerView 00:30:00
-
Module Twelve – Wrapping Up 01:00:00
-
Activities- Microsoft Excel – Intermediate 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-Microsoft Excel – Advanced Level
-
Order Your Certificates and Transcripts
What Our Students are Saying
Sam Carpenter
John Academy has helped me in my development, and I took the courses seriously and gained a qualifications certificate, which I've wanted to do for a long time. I highly recommend it, and a few friends have signed up, too. Thank you, John Academy.
Georgina Salazar
Easy to access, generous options for multiple learning and approaches. Supportive team.
Wayne Wright
The course empowers me to make my dreams come true. The course material was excellent. John Academy is good to study.
Romina
I am thankful that I have chosen John Academy for my online courses. It has given me a platform where I have learned a lot. It has so many reading materials with a handful of knowledge. Once again, thank you so much to the John Academy support team, who has cooperated & supported me throughout this journey.
Peter Gilbert
Brilliant course, with so many to choose from, very good value and a certificate at the end. Quick turnaround to receive a certificate. Very good academy I have completed several and have 2 ongoing at the moment. Never had any problems. Excellent customer service. Would recommend.
Other Students Also Bought
No course found
Certificate Code
Excellent Service
