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.
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
Who this course is for:
- People looking to use Calc/Excel