Office Software (1)
What are some important spreadsheet/excel/Google-Sheet Functions?
Basics
- Vlookup, Count, Max, Min
- Round, Ceiling, Floor ...
- Variation- MAX, MAXA
- Printing
Linear equation
- Slope using graph
Logical
- If Else....
Financial
- PV, FV, NPV, PMT, PPMT
Statistical
- Probability (Normal Distribution)
Data Analysis
- Pivot Table
The course strongly supports the use of free and open source software. Also the use of Google Docs is required in certain instances. Below as some of the recommended software that you can download
How To Create and Share a Google Doc? A video tutorial
Video 1
Video 2
How can I open an Adobe photoshop/Illustrator files? [FOSS Software]
Besides the commercially available (costly?) Adobe Photoshop and Illustrator, there are ofthen freeware graphics application program, These can often open/edit files like *.psd, *.ai.
Gimp is an alternative to various Photoshop Processing Requirement
Skencil is an alternative to various Illustrator Processing Requirement
Inkscape is an open source vector program.
