
Have a simple idea of how Calc works and functions
If you're new to Calc or Excel this video will provide you with some basic insight into how to move around and navigate with the spreadsheet and workbooks that are associated with Calc.
In this second part to moving around in Calc we will learn some more advanced ideas and concepts for working within this software.
Learn how to format cells based on whatever changes you want to make
Learn how to fill cells and a series of cells with a few clicks
You will learn how to format numbers for various context and analysis in Calc
You will learn how to name cells and cell ranges as a shorthand for various calculations
This video provides a brief introduction to developing macros in Calc.
In this video you will learn the details if how to properly input code into the function bar and cells
This video details how to deal with common errors encountered when working with Calc
This video introduces you to the use of functions in Calc
In this video, you will use several different functions primarily for aggregating data
More functions are shared in this video focusing on rounding and modulus functions
More functions that are commonly used in Calc
Master data analysis with LibreOffice Calc by using logical functions such as and and or, by splitting and joining TEKS and numbers; explore amortization and present value calculations.
Introduction to boolean statements and the IF and OR functions
More applications of logical functions
This video will teach you how to split text into multiple cells.
This video will teach you how to join text from multiple cells.
Introduction to developing your own functions
A how-to on calculating several basic financial calculations
In this video you will learn how to create an amortization schedule
Learn how to calculate depreciation in Calc
Explore data analysis with LibreOffice Calc through data visualizations such as scatter plots, histograms, and bar graphs. Learn basic statistics including correlation, regression, descriptive statistics, and t-tests.
Conduct a regression analysis, calculate the correlation and create scatterplots
Make histogram and bar graphs in Calc
Learn how to calculate and interpret ANOVA results and calculate descriptive statistics
Calculate various tests for groups
Learn how to filter data based on a criteria you set
Learn how to set data validation to avoid mistakes during data entry
Learn to sort data in Calc
Create one-way look up tables for data analysis
Learn how to make pivot tables for analysis
Learn how to make two-way tables in Calc
Finding max values
Learn how to combine formulas with conditions
Using conditions to find errors
Compare lists in Calc
Duplicates are a major headache in data analysis. This video shows you how to find them in Calc.
Learn how to develop a project that tells you when an item is going to expire
This video is an introduction to case study and what if analysis
Goal seeker and solver are two of the most powerful tools in Calc. This video provides an introduction into how to use them.
Optimization is a useful tool when you are trying to find the best value given certain constraints. This is explain in this video.
This video takes your knowledge of solver to the next level by introducing constraints.
Every day millions of people need to use spreadsheet software for data entry and analysis. As such, people are always looking for ways to be more efficient when using any software. This course will provide an introduction to using Libre Office Calc an open-source alternative to Microsoft Excel. All the basics of using spreadsheet software along with concepts of data analysis are included such as auto-fill, conditional formatting, conditions, using functions, simple accounting, and financial analysis, statistical analysis, data visualization, and what-if analysis to name a few of the concepts addressed.
Excel users can also benefit from this course even though the focus is on Calc. There is a large amount of overlap in what the two programs can do and therefore it is possible to learn from this course while using Excel.
This course is designed for beginners to expert level who may be looking for some tips or insights that they may not have been exposed to before. After completing this course you will have the skills need to use a free alternative to Microsoft Excel with confidence in order to continue to achieve whatever goals you have in terms of data analysis. Calc is one of the top alternatives to Excel and is installed by default when running alternative operating systems such as Ubuntu.