Data Analysis with Libre Office Calc
What you'll learn
- Navigate inside Libre Office Calc
- Apply various functions in Calc
- Data validation and conditional formatting
- Data visualization and statistics
- Basic applications of finance and accounting
- Installation of Libre Office preferably or Microsoft Excel
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.
Who this course is for:
- People looking to use Calc/Excel
From California, Dr. Darrin Thomas is a Lecturer who has worked in the United States and throughout Southeast Asia at the elementary to the tertiary level. He has taught courses in education, English, research, and music. Currently, he is serving at Asia-Pacific International University. He has an undergraduate degree in music, a master degree in music, a master degree in education and a PhD in education with an emphasis in Curriculum and Instruction.