How to Maximize Excel

Diploma
Certificate
Start Date
16 July 2018
Mode
Full-time
Duration
3 days

Course date: 16-18 July 2018

Location: Maastricht School of Management

Description:
This intensive 3-day course has been developed to introduce participants to the many ways that Excel can be used as a support tool for analysis and decision making. The course is filled with practical exercises that allow participants to find out how to get the most out of Excel. Data sets and real-world examples will be used for practical application.

The three-day short course will focus on the following areas:

  • Report Basics
  • PivotTable Reporting
  • Spreadsheet Reporting
  • Decision Support Cases Using Excel Scenario Manager
  • External Data
  • Worksheet Applications using an Agricultural Economics Example
  • Decision Support Cases Using the Excel Solver
  • Data Analytics in Excel
  • Data Presentation
  • Applications, Macros & Automation
  • Decision Support Case Using Basic and Advanced Excel Functionality

The learning outcomes for participants are depicted subsequently:

  • Be familiar with the basic concepts of navigation, displays, formatting, and ranges
  • Be ready to compile databases and use pivot tables to use data for multiple purposes efficiently
  • Know the shortcuts and techniques used in data manipulation and management
  • Apply Macros and Excel’s advanced functions in working with data and setting up reports
  • Set up projection and trend analysis spreadsheets to assist with management decisions
  • Work with multiple data sources to make a broader range of information available for analysis
  • Conduct management-specific data analysis to help highlight problems before they occur
  • Manage risk by checking the effect that external factors may have on costs, profits and results
  • Draft easy to understand reports and charts, highlighting critical information
  • Have expanded their Excel skills.

To follow the course with proficiency, it is suggested to have basic knowledge of mathematics and Excel, as well as a good working knowledge of Windows. The course is appropriate for doctoral students and academic researchers that use quantitative research methodologies.

Lecturer

Riaan Rossouw, PhD is an economist who specializes in data analysis, particularly the conversion and dissemination of large volumes of data into strategic intelligence. He is also an expert in computable general equilibrium (CGE) modelling and international trade flows and databases. He is an honorary research fellow at the Maastricht School of Management and extraordinary associate professor in the School of Economics at the North-West University. Riaan holds a PhD from the North-West University.
Riaan has completed numerous local and international advisory projects for governments, financial institutions, international NGOs, international business schools, mining houses, freight transport companies and utility providers. He has developed several mathematical and econometric models which contribute practically to decision making in a public and private institution context. He also participated in numerous smaller projects and in doing so, demonstrated skills in the economic analysis of energy-related projects, computer programming, decision support systems, economic and strategic planning, quantitative research, development of modelling tools, and related software design.
Riaan has taught both local and international students and development practitioners. Based on his private and professional experiences on projects in Southern Africa, the Netherlands and the UK, Riaan knows both developed and emerging market dynamics and has a keen eye for intercultural relations.
His research interests include social and economic dimensions of inequality, economic impact assessment, decision support systems as well as CGE modelling (particularly in the African context), with a focus on regional disparities, labor markets, fiscal reform, tourism, energy policy, development planning and international trade.

Admissions

The program targets

  • Academics
  • Professionals
  • PHD Students/DBA Students
  • Post-Doctoral Students
  • Post-graduates Students


Application document

CV

Visa

Participants are responsible for arranging their own entry visa, if applicable. If needed, students can request an admission statement for their Visa application via e-mail (research@msm.nl ), but only after full payment is received by MSM. Students should apply for a tourist Visa and not a study Visa.

Fees

Early Bird Fee (registration until 10 May 2018 Regular Fee (registration after 10 May 2018)
Course fee for 3-day program € 350 € 400

The fee includes: Tuition fees, Study Materials, Welcome Package.

The fee does not include housing costs, living expenses, travel expenses, visa and insurance costs.

MSM reserves the right to cancel the program in case the number of participants does not meet the MSM requirements for minimum number of participants. In this case, any payment made to MSM for tuition fee will be refunded.

Deadline

Deadline for application is 3 June 2018.

Back to Overview