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.
Course Content
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:
Word Processing
Presentations
Databases
Both Basic And Advanced