Free Spreadsheet Training Course
The objective of this course is to familiarize you with the LibreOffice Calc package, on completion you will be able to understand the principles of Spreadsheets.
From Beginner to expert in simple to follow steps
The Spreadsheet training course will take you from the beginning, installing and opening the spreadsheet program, then it will teach you to recognise the layout of the spreadsheet, including Toolbars and menus.
These Lessons Will Help You Improve Your Spreadsheet Skills.
A spreadsheet in this context is a computer program designed to help in the processing of structured information, commonly numbers. The word spreadsheet comes from how accountants would use a SHEET of paper to SPREAD values like costs and profit into a format that was easy to see.
In line with its paper based origins the spreadsheet program we will be looking at can also be used to manipulate numbers, in fact if you have any structured data that you need to be presented in an attractive way then a spreadsheet is the best tool.
The advantage of using a spreadsheet over other programs is that it can constantly update figures without having to constantly re-calculate the results, when your spreadsheet is set up all calculations will be instantly updated and the results will be correct. You can start performing “what if” calculations, make one change in a large spreadsheet and the results can be viewed instantly.
For this course we will use the Program Calc from the free LibreOffice package.
Enter your name and email address,
then press "Enroll Me".
You will then be sent links to these lessons on a regular basis. When you have completed this course to will be sent updates on new courses, all of which will be free.
Why Do We Need Your Email Address?
Our intention is to deliver the best quality training to as many people as possible, regardless of location, background or ability to pay.
|What We WILL do.||What We WILL NOT do.|
|Send regular e-mails informing you of the next lesson in the course||Send any marketing material|
|Notify you of your test score and grades||Pass on your details to third parties|
|Send details of new courses as they become available||Send you a few lessons and then expect you to pay for the rest.|
Your e-mail address is for us to inform you about your training, the costs associated with the delivery of this training site are met by on page advertising only. We will not use your e-mail to generate any further income.
Basic Spreadsheet Course
Part 1 - LibreOffice Installation
Part 2 - Using Spreadsheets
Part 3 - Spreadsheet Cells
Part 4 - Managing Worksheets
Part 5 - Formulas and Functions
Part 6 - Spreadsheet Formatting
Part 7 - Charts
Part 8 - Prepare Outputs
Advanced Spreadsheet Course
Part 1 - Advanced Formatting
Part 2 - Advanced Functions and Formulas
Part 3 - Advanced Charts
Part 4 - Data Analysis
Part 5 - Validating and Auditing Data
Part 6 - Using Spreadsheets to Enhance Productivity
Part 7 - Collaborative Editing
All These Lessons Are 100% Free.
By Registering Today You Will Automatically Qualify For The Following Courses:
Both Basic And Advanced