(MC) MS Excel Intermediate for the Workplace

(MC) MS Excel Intermediate for the Workplace

Introduction

Studies have shown that 82% of office jobs require Microsoft Excel skills. MS Excel can also increase your earnings potential by 12% (Inc. & Technologies, 2017).

This course taps into MS Excel's productivity feature in the areas of data formatting, data analysis, data visualization and data protection.

To achieve optimum teaching and learning in a hands-on course, the course is conducted using demos and examples by the trainer and then working through tutorials and presentations in teams and as an individual.

The 2-day course will cover:

Data Formatting (Links, formulas and pick lists)
Data Visualisation (Charts, Conditional Formatting)
Data Analysis (Pivot tables, What-If Analysis, Goal Seek)
Data Protection (Data Validation and Protected Sheets & Files)
Time-saving tips and tricks

Organization

Imperium Edumaax - Professional Development

Outcome

At the end of this course, participants would have been introduced to:

- MS Excel Data Formatting
- MS Excel Data Visualisation techniques
- MS Excel Data Analytics features
- MS Excel Data Protection options
- Bonus: Time-saving tips and tricks in MS Excel

Expert

John David

John is a senior lecturer in the School of Engineering and IT at Imperium International College, Kuala Lumpur. He has been with the college for over 10 years and is also the head of the Centre for Professional Development and Training at Imperium Edumaax. John has taught courses in the MS Office suite for over 10 years with a special interest in MS Excel. He has a degree in Computer Science from Clemson University, USA, and a Master’s degree from the University of Maryland, USA. John has also worked in the software industry for over 20 years. Seven of those years were in the US, working as an IT consultant and defense contractor. In Malaysia, he has worked for multi-national companies, developing ERP systems for global usage.