This training will dwell on lookup functions and advanced list management. The participants will be introduced to the art of producing valuable insights from accumulated data.
The advanced excel for data analysis course is meant to help the participants to understand how to create a function that will bring data from other sources into Excel, perform data cleaning and pre-processing steps, and create data mash-ups. The foundation laid in understanding the functions of Excel will lead to participants’ exposure to basic tools for building business logic in the Excel data model and presenting the data with interactive visualizations. The training will dwell on lookup functions and advanced list management. Finally, the participants will be introduced to the art of producing valuable insights from accumulated data.
For enquiries, contact:
Grace – 0806 638 5629
Isaac – 0803 346 0440
Samsideen – 07010178911
Upon completion of this course, participants should be able to:
§ Understand the functions of Excel, and appreciate its capabilities
§ Quickly summarize, analyze, and sort your data.
§ Carryout data analysis and data presentation using Microsoft Excel
§ Filter data and create reports using simple Excel formulas
§ Collect, model, analyze, and explore data to find a pattern in it
§ Produce valuable insights from accumulated data
§ Create flexible data aggregations and represent data visually
The course on Advanced Excel is for officer-mid-level staff. The targeted audience also includes every department that requires the use of modelling such as accountants, equity research analysts, economists, analysts, managers, and the staff of research departments to provide a springboard for them to effectively function in their primary, secondary and tertiary roles.