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

A youtube playlist

What are the recommended software?

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 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.