Business generates mound of data regularly. The ability to transform this mound of data into bottom line information is of utmost importance to any organization that must remain relevant in this fast moving age of electronic data.
Microsoft Excel comes fully loaded with vast array of data management and analysis tools to interpret business information in a coherent and organized manner; it has functionalities that can be used to perform simple to complex data management and analysis. It can also be used to build complex models for solving financial and non-financial what-if scenarios.
The intent of this course is to empower participants with the skills of how to use more advanced features of Microsoft Excel in analyzing mound of data to spot trend for making accurate decision for business growth.
Dynamic Naming Range
Grouping and Outlining Data
Advanced use of conditional formatting
Advanced use of data validation
Database & List Management
Functions for Financial Analysis and investment performance
Excel’s Data Management Features
Excel functions to data mine and classify records.
Summarizing Data Visually with Excel Charts and KPI tools
Summarizing Data with PivotTables
Using Excel’s Modeling Tools for scenario-based forecasting
Solve Optimization Problems with Excel Solver
Using Excel for Statistical Analysis to Track Trends & Make Forecasts
Working with Array functions
Connecting to other database source
Who Should Attend?
This program is designed for analysts who need practical data management & data analysis skills in Excel
14th -16th February 2017
11th -13th April 2017
13th -15th September 2017
BVS Training Centre, 21 Adenuga Taiwo behind Fidson Headquarters Obanikoro Lagos.
=N=120,000.00 per participant. This fee covers all course materials, Tea and lunch break
It is expected that participants have basic knowledge of Excel functions, techniques for effective data entry and familiarly with the Excel Ribbon
was able to secure a promotion with the acquisition of knowledge on SQL and PL-SQL — Ada Daobi
took part in the Creating Professional Documents using the Advanced Features of Word 2010/2010 Course, and my office hours have become more productive. — john attah