Excel Diploma Course

COURSE INFORMATION

Certified Course
Accredited Course
9 Modules
Study Group Access

 

 

ACCREDITATIONS

QLSCPD
Excel Diploma Course
Buy Lifetime Access
US$161.52
Single Course Purchase
Subscribe & Save with Grow With CoE
US$33.07 per month (billed annually)
Includes access to this course and 11 additional courses of your choice from our entire library. Grow subscribers enjoy 80% discount + 10% off printed materials + 12 free audio courses per year.
Stories from the CoE Community
What Will You Learn?

This online training course uses Excel 2013 for Windows, though Excel 2016 was released at the end of 2015.

The Excel Diploma Course offers an extensive overview of Microsoft Excel, from the fundamentals to the most advanced features, and teaches by getting students to work in the software package as they progress through the course; presenting exercises related to what has been taught.

Though it has been around for over a quarter of a century, Microsoft Excel is still one of the most important and popular pieces of software used in the modern workplace. Easy to use and highly functional, it integrates easily with other Microsoft Office programmes (the suite of which itself is the most widely used programme set available) and is the spreadsheet programme of choice across the globe.

If you've never tried to learn Microsoft Excel before, then it can seem quite daunting when you first open the programme. Students will become comfortable navigating around the Excel environment easily and efficiently

The Excel Diploma Course teaches the basic skills needed to use the programme, and lays the foundations for further knowledge imparted throughout the course

You will learn how to format spreadsheets, not just for aesthetic reasons (though good formatting can certainly have that affect) but to ensure data is organised in a clear and comprehensible way, so that it is immediately accessible to other users. You will be guided through the various formatting tools; being shown how to work effectively with fonts, colours, borders and patterns, as well as managing the size and content of your cells

Students will learn how to carry out easy calculations before delving deeper into more sophisticated methods of calculation then you will move onto MS Excel’s more advanced functions, and the use of formulas and functions; unlocking the power of the programme and enhancing the abilities and proficiency of students.

By the end of this course, you will be an Excel guru!

PLEASE NOTE: This course is based on Microsoft Excel 2013 Edition.

Course Syllabus

What will I learn on the course?

Certified Course
Accredited Course
  • Introduction
  • Part 1: The Beginnings of MS Excel
  • Part 2: Common areas of business that use MS Excel
  • Test Your Knowledge
  • Key Learning Points Exercise
  • Module 1 Assessment
  • Part 1: The Excel Worksheet
  • Part 2: How to Use and Customize the Quick Access Toolbar
  • Part 3: Spreadsheet
  • Test Your Knowledge
  • Key Learning Points Exercise
  • Module 2 Assessment
  • Part 1: Introduction to Cells
  • Part 2: Sharing, Saving & Exporting Workbooks
  • Test Your Knowledge
  • Key Learning Points Exercise
  • Module 3 Assessment
  • Part 1: Formatting Fonts
  • Part 2: Text alignment
  • Part 3: Applying Colours, Borders and Patterns
  • Part 4: Modifying Columns and Rows
  • Test Your Knowledge
  • Key Learning Points Exercise
  • Module 4 Assessment
  • Part 1: Understanding Formulas
  • Part 2: Benefit of Cell References
  • Test Your Knowledge
  • Key Learning Points Exercise
  • Module 5 Assessment
  • Part 1: More about Operators
  • Part 2: Nesting Functions
  • Test Your Knowledge
  • Key Learning Points Exercise
  • Module 6 Assessment
  • Part 1: Sorting
  • Part 2: Filtering
  • Test Your Knowledge
  • Key Learning Points Exercise
  • Module 7 Assessment
  • Part 1: Understanding Charts
  • Part 2: How To Modify Your Chart
  • Part 3: Pivot Tables
  • Part 4: Sparklines
  • Test Your Knowledge
  • Key Learning Points Exercise
  • Module 8 Assessment
  • Part 1: Viewing
  • Part 2: Page Layout, Orientation and Formatting
  • Test Your Knowledge
  • Key Learning Points Exercise
  • Conclusion
  • Module 9 Assessment
Who Would Benefit from This Course?

With its comprehensive learning materials, the Excel Diploma Course is ideal for absolute beginners, who may have never opened a spreadsheet before, and those who know their way around the programme, along with some of the basic functions, but want to get a better grasp of how to use the more advanced features and speed up their workflow.

Accreditations

The Excel Diploma Course will take you up to 150 hours to complete working from home. There is no time limit for completing this course, it can be studied in your own time at your own pace. This is a Level 3 course and will give you 150 CPD (Continued Professional Development) points.

Upon completion of your course assessments, you receive 2 certificates. A certificate from the Centre of Excellence and a CPD certificate displaying the number of CPD points earned from the course.

This course is endorsed by the Quality Licence Scheme. Therefore, upon successful completion of this course, learners can also receive a certificate of achievement from Quality Licence Scheme and a Learner Unit Summary, which lists the details of all the units the learner has completed as part of the course. (This certificate is optional and costs an additional £25).

The Quality Licence Scheme is part of the Skills and Education Group, a charitable organisation that unites education and skills-orientated organisations that share similar values and objectives. With more than 100 years of collective experience, the Skills and Education Group’s strategic partnerships create opportunities to inform, influence and represent the wider education and skills sector.

The Skills and Education Group also includes two nationally recognised awarding organisations; Skills and Education Group Awards and Skills and Education Group Access. Through their awarding organisations they have developed a reputation for providing high-quality qualifications and assessments for the education and skills sector. They are committed to helping employers, organisations and learners cultivate the relevant skills for learning, skills for employment, and skills for life.

Their knowledge and experience of working within the awarding sector enables them to work with training providers, through the Quality Licence Scheme, to help them develop high-quality courses and/or training programmes for the non-regulated market.

Grow with CoE Subscribe and save!
Grow with CoE Memberships Grow with CoE Memberships Grow with CoE Memberships
Get 12 courses with a HUGE 80% discount!
(Just US$33.07 per month - billed annually)
Grow members loved these great courses!
5K

Business Management with Accountancy Diploma

Diploma Course

Business, Marketing & PR Courses
3K

Coaching & Mentoring for Business Success Diploma Course

Diploma Course

Business, Marketing & PR Courses
4K

Financial Intelligence for Wealth Building Diploma Course

Diploma Course

Business, Marketing & PR Courses
3K

Marketing & PR for Small Businesses Diploma Course

Diploma Course

Business, Marketing & PR Courses
1K

Public Speaking Diploma Course

Diploma Course

Business, Marketing & PR Courses
1K

Speed Reading Diploma Course

Diploma Course

Free courses
4K

Team Leadership and Motivation Diploma Course

Diploma Course

Business, Marketing & PR Courses
700

eBay Business Diploma Course

Diploma Course

Business, Marketing & PR Courses
3K

Human Resources Diploma Course

Diploma Course

Business, Marketing & PR Courses
5K

Virtual Assistant Business Diploma Course

Diploma Course

Business, Marketing & PR Courses
5K

Social Media Marketing Diploma Course

Diploma Course

Business, Marketing & PR Courses
13K

Internet Marketing Strategies for Business Diploma Course

Diploma Course

Business, Marketing & PR Courses
13K

Teach Your Own Classroom Based Courses Diploma

Diploma Course

Child Education
3K

Project Management Diploma Course

Diploma Course

Business, Marketing & PR Courses
1K

Affiliate Marketing Diploma Course

Diploma Course

Business, Marketing & PR Courses
1K

Fundraising Diploma Course

Diploma Course

Business, Marketing & PR Courses
980

Introduction to Bitcoin, Blockchain and Cryptocurrencies Diploma Course

Diploma Course

Business, Marketing & PR Courses
1K

How to Make Marketing Videos for Business Diploma Course

Diploma Course

Business, Marketing & PR Courses
1K

Online Course Creation Diploma Course

Diploma Course

Business, Marketing & PR Courses

0 / 19

A State of the Art
e-Learning Experience

We provide a state of the art online learning platform, accessible from anywhere, learning available 24/7.

  • Access Your Personalised Course Library

    View your courses in your online course library.

  • On-the-go Learning

    Learn on your mobile, tablet, laptop or via audio.

  • Join our thriving online community

    Over 1 million learners.

  • Lifetime access

    Learn in your own time at your own pace.

A State of the Art Learning Experience
Trustpilot
Don’t just take our word for it!
We have over 5,000 5-star
reviews on Trust Pilot!
Stop wasting time, effort, and money on mediocre courses. At Centre of Excellence, we provide the highest quality of courses to help you learn more effectively. Our goal is to ensure that you are always satisfied with your purchase. That's why we offer a 14 day money back guarantee for every course you buy with us. You have nothing to lose!
Trustpilot
The best quality online course provider…

The best quality online courses at the very best price. Really well done, the courses are easy to understand and you make the subjects really interesting. Staff are helpful and supportive. You are truly the centre of excellence!

Navid
Trustpilot
The CoE Learning Experience

What's not to love about learning with the CoE

The course modules are in-depth & easy to read/understand. Prior to carrying out the assessment you are able to consolidate your learning by completing the test your knowledge & bullet pointing the learning objectives. Further to this, once you have completed each assessment you receive feedback, and you receive feedback once you complete the course.

Any issues you may encounter, the team at COE are on hand and respond quickly & efficiently - double bonus, you have lifetime access to all the courses you complete, great to revisit & brush up on your knowledge & they have online support through their Facebook group.

Annie
Trustpilot
I really enjoyed this course

I really enjoyed this course. It was a lot more in depth and informative than I thought it would be.

I will definitely use the new knowledge and skills within my work.

Amy
Trustpilot
Excellent credited courses for everyone!

Desc: I have done over 15 courses with CoE already and I can only recommend them. Friendly customer support, great topics, very alternative and unique courses you'll hardly find anywhere else. Also a huge selection of different interests, there is something for everyone. Great discount codes running at all times! What started as a way to cope with COVID has become a true passion for me. Thank you CoE!

Katrin
Celebrating Your Success
Here at Centre of Excellence we are supremely proud to be at the heart of a vibrant community of hard-working students. The determination and enthusiasm of our students never ceases to impress us and there is nothing better than seeing our graduates go on to succeed in further education, work, business or just life in general!
Best Business Award
Best Business Award
This award is aimed at those that have gone
Shining Star Award
Shining Star Award
This award recognises those that have gone
Outstanding Therapist
Outstanding Therapist
Are you helping your clients to make positi
Entrepreneur Award
Entrepreneur Award
Drive, ambition and a mindset for success a
Achievement Award
Achievement Award
Have you gone on to really push the boundar
Contribution Award
Contribution Award
Have you helped to make a big difference to
Learner Of The Year
Learner Of The Year
Have you really pushed the boundaries with

Frequently Asked Questions

Below you’ll find the answers to the questions that we get asked the most regarding Centre of Excellence

There is no time limit for completing your course it can be studied in your own time at your own pace.

All of our courses vary in length but most of our courses will take you between 50 - 250 hours to complete. The length of this course can be found in the Accreditations section above.

Once purchased your course is located in your Learning Centre on our website. Please log in using the same email address that you used when you purchased your course.

You can purchase a printed copy of your course materials at the checkout or from within your Learning Centre at any time after purchasing your course.

This week's Top Sellers

1K People Enrolled
Random Act of Kindness
Speed Reading Diploma Course

Speed Reading Diploma Course

9 Modules

Was US$0.00 Save US$0.00
US$0.00
Pay It Forward

Related News

Angel Number 555: Meaning in Career, Love Life, and Health

Angel Number 555: Meaning in Career, Love Life, and Health

Have you noticed the number 555 pop up in your life more often than usual? From digital clocks showing 5:55 to receipts totalling £5.... Read More

Ares, The Evil Greek God: Myths, Legends, and Powers

Ares, The Evil Greek God: Myths, Legends, and Powers

Ares, the god of war, stands out as a particularly complex character. Often associated with the darker aspects of warfare, such as cha... Read More

How to Forgive Yourself: 9 Steps to Emotional Well-being

How to Forgive Yourself: 9 Steps to Emotional Well-being

Forgiving yourself can sometimes feel like an impossible challenge. We've all been there, carrying the weight of past mistakes, wonder... Read More

Scorpio Moon: Traits, Characteristics, and Compatibility

Scorpio Moon: Traits, Characteristics, and Compatibility

The moon represents our inner world: our emotions, instincts, and underlying personality traits. When the moon is in Scorpio, it bring... Read More

Excel Diploma Course
US$161.52
Excel Diploma Course
Excel Diploma Course
Trustpilot
Certified Course
Accredited Course
5K Users Enrolled
US$161.52