By the end of this course candidates will master the techniques of using the right excel tools to solve problems more efficiently. Also new features in the current Excel version will be highlighted.
Topics covered include Conditional Formatting wizard, Flash Fill, Name Manager, various functions (string, maths, logical, lookup), pivot tables, slicers and pivot charts to build a BI dashboard.
Having practiced all of these new skills extensively during the course you will be able to hit the ground running on your return to the office and should be able to complete your Excel work far more proficiently.
A CPD Award accredited with 1 ECTS credits (MQF Level 5) by the Malta Further & Higher Education Authority (MFHEA), the Award in MS Excel Intermediate: The Use of Formulae & Intermediate Data Operations will be awarded.
This course is made up of 2 half-day sessions.
A foundation in basic Excel techniques is advised. This course will prepare students for a more advanced course, helping them to learn new tools and functions to make their work in the office more precise and efficient.
Dr. Vincent Marmara
Vincent Marmarà is a Statistician and Researcher by profession. He obtained his first degree in Statistics, Operational Research and Mathematics at the University of Malta. He later advanced his studies by obtaining Masters of Science in Statistics at Sheffield University, UK. Furthermore, he has obtained his PhD in Mathematics (Statistics) from the University of Stirling, Scotland. He was entrusted with numerous research projects both at a national and international level. He led research groups and analyzed data to a high-level scientific extent.
Vincent has over 11 years of experience in the Remote Gaming Industry as a Business Intelligence Analyst and Consultant. He occupied several key important roles in various organisations such as: Student Representative of the Faculty Board of Science (University of Malta), President of the Science Student Society, President of the Malta Statistics and Operations Research Organisation (MSTOR), Financial Officer of the National Youth Council, Deputy CEO and Chief Regulatory Officer within the Malta Lotteries and Gaming Authority.
Dr. Vincent Marmarà lectures statistics at the Department of Management (FEMA) at the University of Malta. Vincent is a fellow member (FRSS) of the Royal Statistical Society (UK). Dr. Marmarà provided research consultancy services to various organisations and supervised / is currently supervising BSc, BCom, MBA and MSc research students at the University of Malta. Vincent published several academic articles on international journals and other scientific surveys in Malta. At present he is one of the partners and co-owner of the statistics research company, Sagalytics.