banner

Centre of Excellence – Excel Diploma Course

🎁 HAPPY NEW YEAR 2025! Exclusive 30% OFF for New Year 2025! Use code NEWYEAR30Claim Your Gift
img

Centre of Excellence – Excel Diploma Course

Centre of Excellence - Excel Diploma Course

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.

Centre of Excellence – Excel Diploma Course (1)

What Will You Learn?

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.

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.

Modules

Module 1: Excel: An Overview

  • 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
Module 2: The Excel Environment
  • 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
Module 3: Basic Excel Skills
  • Part 1: Introduction to Cells
  • Part 2: Sharing, Saving & Exporting Workbooks
  • Test Your Knowledge
  • Key Learning Points Exercise
  • 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
  • Test Your Knowledge
  • Key Learning Points Exercise
  • Module 4 Assessment
Module 5: How to Calculate with Excel
  • Part 1: Understanding Formulas
  • Part 2: Benefit of Cell References
  • Test Your Knowledge
  • Key Learning Points Exercise
  • Module 5 Assessment
Module 6: Advanced Formulas and Functions
  • Part 1: More about Operators
  • Part 2: Nesting Functions
  • Test Your Knowledge
  • Key Learning Points Exercise
  • Module 6 Assessment
Module 7: Sorting and Filtering Data
  • Part 1: Sorting
  • Part 2: Filtering
  • Test Your Knowledge
  • Key Learning Points Exercise
  • 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
  • Test Your Knowledge
  • Key Learning Points Exercise
  • Module 8 Assessment
Module 9: Viewing & Printing
  • Part 1: Viewing
  • Part 2: Page Layout, Orientation and Formatting
  • Test Your Knowledge
  • Key Learning Points Exercise
  • Conclusion
  • Module 9 Assessment

There are no reviews yet.

Add a Review
Original price was: $177.00.Current price is: $67.00.

Learn how to format spreadsheets, not just for aesthetic reasons (though good formatting can certainly have that affect)...

Purchase this product now and earn 67 Points!
10 Points = $1