This course aims to help professionals develop and enhance their MS Excel skills, which are essential for working with various types of data and performing various tasks. The course will cover topics such as:
- How to use the MS Excel environment
- How to use MS Excel functions for fundamental data analysis
- How to use intermediate MS Excel functions
- How to carry out statistical analysis using MS Excel, such as calculating mean, mode, median, standard deviation, variance, examining inter-dependency, drawing histograms, and introduction to data analysis functions
- How to perform what if and scenario analysis using MS Excel, such as naming cells, linking cells together, introduction to solver, advanced charting, and sharing MS Excel output with other office formats
