Tell a friend

Excel Diploma Course

Act quickly to secure this special offer

£127.00

WAS £297.00

SAVE £170.00

OR

What will you learn?

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...

What will you learn?

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.

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

If you are completely new to Excel, 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!

Course Syllabus

What will I learn on the course?

Module 1: Excel: An Overview

Part 1: The Beginnings of MS Excel

Part 2: Common areas of business that use MS Excel

Module 1 Assessment

Module 2: The Excel Environment

Part 1: The Excel Worksheet (Spreadsheet)

Part 2: How to Use and Customize the Quick Access Toolbar (QAT) and the Ribbon

Part 3: Spreadsheet (worksheet) views

Module 2 Assessment

Module 3: Basic Excel Skills

Part 1: Introduction to Cells

Part 2: Sharing, Saving & Exporting Workbooks

Module 3 Assessment

Module 4: The Fine Art of Formatting

Part 1: Formatting Fonts

Part 2: Text alignment

Part 3: Applying Colours, Borders and Patterns

Part 4: Modifying Columns and Rows

Module 4 Assessment

Module 5: How to Calculate with Excel

Part 1: Understanding Formulas

Part 2: Benefit of Cell References

Module 5 Assessment

Module 6: Advanced Formulas and Functions

Part 1: More about Operators

Part 2: Nesting Functions

Module 6 Assessment

Module 7: Sorting and Filtering Data

Part 1: Sorting

Part 2: Filtering

Module 7 Assessment

Module 8: Charts and Graphics

Part 1: Understanding Charts

Part 2: How To Modify Your Chart

Part 3: Pivot Tables

Part 4: Sparklines

Module 8 Assessment

Module 9: Viewing & Printing

Part 1: Viewing

Part 2: Page Layout, Orientation and Formatting

Module 9 Assessment

Who would benefit from the 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.

This course is certified by the IAHT (International Alliance of Holistic Therapists), the IAHT is an internationally recognised organisation. The IAHT certify personal development, health, fitness and nutrition courses.

Upon completion of your course assessments, you will receive 3 certificates. An accredited certificate from the awarding body relating to your course, a CPD certificate displaying the number of CPD points earned from the course and a certified Diploma certificate from the Centre of Excellence.

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.

Inspirational Events & Workshops

Gain access to our online TV channel.

1,204 Online Courses

Find what you need in our growing library. New courses added weekly.

Ready to change your life?

If you are ready to take the next step click on the "Buy this Course" button below or make an enquiry about this course if you have any questions.

Latest Blog Articles

Room by Room Home Aromatherapy

Just like the colour schemes you pick, the lighting you choose or even the little details of decor in your home such as cushions and throws, fragrancing a room has the potential to completely change … Read More