Centreofexcellence – Excel Diploma Course
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.
This online training course uses Excel 2013 for Windows, though Excel 2016 was released at the end of 2015.
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!
What will I learn on the course?
Module 1: Excel: An Overview
Module 2: The Excel Environment
Module 3: Basic Excel Skills
Module 4: The Fine Art of Formatting
Module 5: How to Calculate with Excel
Module 6: Advanced Formulas and Functions
Module 7: Sorting and Filtering Data
Module 8: Charts and Graphics
Module 9: Viewing & Printing
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.