Your digital skills are very important in this day and age. Making your own worksheets and taking your excel skills to the next level can be very important in your life. Not only will it help you in your workplace, but it can also be beneficial at home. Excel can be used for virtually anything, and such programmes are becoming increasingly more important in this digital age. So if your level of knowledge and your skills on Excel aren’t what you want them to be, what are you waiting for?

This Microsoft Office Excel course will help you learn and master not only the basics, but also the more advanced options of Excel. The course consists of four chapters;

1.Calculating with Excel
2.Functions and Graphs
3.Excel Database
4.Subtotals, Pivot Tables and Macros

Each chapter consists of at least 10 videos to guide you through different parts of Excel.

N.B. Although the videos in this course are made in Excel, most (if not all) aspects of this course also apply to Excel 2010 and Excel 2013 and Excel 2019.

Here’s What You’ll Discover Inside This Video Training:
How to get started with MS Excel.
Learn how to get use to the interface and configure your settings.
Learn how to create your first sheet and what are the options to select when doing it.
Learn how to work with MS Excel templates and properties.
How to quickly and easily work with text, formula and others.
How to format attractive excel sheets that prints awesomely well.
How to use the configuration settings and organize your data properly before working.

Manage reports with Excel 2019

Here’s a list of the video titles included in this training:
1. Overview To Excel
2. Interface
3. File Menu
4. File Menu – Part 2
5. Home Menu
6. Insert Menu
7. Page Layout Menu
8. Formulas Menu
9. Data Menu
10. Data Menu – Part 2
11. Review Menu
12. View Menu
13. Templates
14. Dates
15. Numbers
16. Text
17. Calculations
18. Page Set Up
19. Print Settings
20. Conclusion


1 – Overview
2 – Calculations – Absolute References
3 – Calculations – Relative References
4 – Using Logical Formulas
5 – Using Text Formulas
6 – Using Lookup Formulas
7 – Using Financial Formulas
8 – Using Date and Time Formulas
9- Sorting Data
10 – Formatting Data into Tables
11 – Using Pivot Tables – Part 1
12 – Using Pivot Tables – Part 2 – Design
13 – Formatting Data as Charts
14 – Formatting As Data as Maps
15 – Formatting Data as Formal Reports
16 – Formatting Data for Other Office Documents
17 – Cell Protection and Collaboration
18 – Cell Protection and Collaboration – Part 2
19 – Interface with Google Sheets
20 – Conclusion

Course Curriculum

No curriculum found !

Course Reviews


1 ratings
  • 5 stars1
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0
  1. Very Informative and easy to follow


    Excel has always daunted me but this course is set out in such a way so as not to overwhelm you, it is explained easily and in easy to follow chunks.

  • 99.00
  • 1 year
Yvar is a registrated trade name of Ster Shop BV

Eindhovenseweg 116 5582HW Waalre
The Netherlands.

T: +3140844000
KVK: 17110779
BTWnr: NL8110.24.106.B01
IBAN: NL10ABNA0533372631

FAQ | Contact | Terms and Conditions |