OpenCastLabs partners with government, non-profit and private clients to deliver professional services in capacity building and research. We are a training and consultancy firm established in Kenya, Rwanda and Uganda. We hereby invite you to our trainings for the second quarter (April-June)
Course Tittle: Advanced Excel for Professionals
Dates: 1st -2nd April, 2015 (2 days)
Fees: $125 per delegate
This course shows how spreadsheets can be used to enhance management reporting.
The course shows how to analyze and review data extracted from ERP systems and databases in order to prepare management reports, including using Excel’s graphing capabilities. The course studies Excel’s functions and how to use these effectively. The program also shows how to access the Visual Basic Editor and use macros and user defined functions in order to enhance Excel’s functionality. Half a day will also be spent showing attendees how to use Excel’s pivot table functionality.
Pivot tables are often poorly understood and yet are the most powerful feature in Excel.
A basic pivot table will allow you to summarize 50,000 rows of data in 30 seconds.
Aggregating and analyzing data from different sources is made easy with Excel’s Power Pivot plugin. But before you can glean insights from your data, you’ll need to know how to build an effective data model, or collection of tables. In this section, we cover all the steps for data modeling with Excel: adding data sources, setting up relationships between tables, and configuring hierarchies. Additionally, we explore the power of DAX, the language behind the calculated columns and calculated fields that make for powerful PivotTables.