Courses
http://www.turningpointdata.net/wp-content/uploads/2013/03/course.png

A full list of courses we offer are listed below, click on corresponding tabs to view more details about them.

[sections]
[section title=”Effective and Efficiency Techniques in Microsoft Excel 2007/2010“]

[tabs]
[tab title=”Overview”]
The most popular software used by companies in generating and manipulating data is Microsoft Excel. This is in spite of the latest sophisticated enterprise software we find around the globe. However, many users of this application (Excel) still find it difficult to navigate their way through the software, and exploit the advanced and sophisticated techniques embedded in its ability to generate and analyze data.

Research shows that a lot of Excel users know little about its functionality. This course is a foundational enhancement of assumed knowledge in Excel used.

This course is highly recommended for people who want to explore the world of possibilities in Microsoft Excel
[/tab]
[tab title=”Objectives”]
The intent of this 2 days course is to expose participants to the fact that Microsoft Excel 2007 has a lot of functionalities which are easy to use, making them more efficient and productive in their job functions.

It also equip participant in embarking on the journey of exploring the world of Excel which is endless ocean,
[/tab]

[tab title=”Course Content”]
Custom-Tailoring the Excel Workspace
Planning Your Worksheet Design
Managing Worksheets
Protecting Worksheets
Managing Multiple Workbooks
Introduction to Protecting Workbooks and Worksheets
Creating Custom Number format
Introduction to Conditional Formatting
Formatting in Depth
Understanding Relative, Absolute, and Mixed References
Referencing across sheets and books
Using built-in-functions
Understanding Error Values
Advanced Sorting and Filtering Techniques
Understanding How Excel Records Dates and Times
Working with Date and Time Functions
Reporting data in embedded charts and chart sheets
[/tab]

[tab title=”Who Should Attend?”]
Every Excel user who are yet to attend a formal class handled by professionals

[/tab]
[tab title=”Duration”]

[/tab]
[tab title=”Date”]
16th -17th Jan 2013

13th -14th Mar 2013

8th -9th May 2013
[/tab]

[tab title=”Venue”]
Leadway Assurance Training Centre 10, Abebe Village Road, Roof Top Apex Mill Building, Opposite
[/tab]

[tab title=”Fee”]
=N=65,000.00 per participant. This fee covers all course materials, Tea and lunch break
[/tab]

[tab title=”Register”]

[breezingforms name=”Effective_and_Efficiency_Techniques_in_Microsoft_Excel_2007_2010_Form” iframe=”1″ iframe_height=”450″ iframe_width=”100%”]

[/tab]
[/tabs]

[/section]

[section title=”Creating Professional Documents with Ease Using the Advanced Features of Word 2010/2010“]

[tabs]
[tab title=”Overview”]

Research as shown that 85% of MS Word users do not take full advantage of functionalities in MS word to make them highly productive. Preparing and reviewing their document takes a lot of time and great effort, hence putting then under unnecessary pressure.

The issue is not usually with the creative writing, but it is with formatting and adding other details like Table of content, footnotes, citation and taking full advantage of other tools that are readily available.
[/tab]
[tab title=”Objectives”]
The main objective of this workshop is to equip and expose participants on how to take full advantage of these advanced functionalities in word in the process of preparing, editing and reviewing their documents.

This one-day program will help participants acquire proficiency in organizing and presenting their document in any standard required format.
[/tab]

[tab title=”Course Content”]
Honing Document Navigation Skills
Organizing Concepts in Table and Use to tables in performing calculations
Prepare documents for multiple formatting (documents with different header, footers and page orientations)
Showing Data with SmartArt and Charts
Professional Polishing
Aligning Information and Formatting Paragraph Lists
Using Styles to Increase Your formatting Power
Reviewing Documents using Markup tools
Generating First-Class Tables of Contents and Reference Table
Building Table of Content
Generating Table of Figures
Generating  Table of Authorities
Creating Customized TOC
Add reference s like footnotes, endnotes, citations, bibliography
Compare and combine multiply documents
Create forms
Create  mail merge with records from another source like spreadsheet
[/tab]

[tab title=”Who Should Attend?”]

Business Executives, Consultants, Project Managers, Human Resource personnel, Trainees, Journalists, Company Secretaries and Job functions that involving report or proposal writing ,lawyers
[/tab]
[tab title=”Duration”]

[/tab]
[tab title=”Date”]
Jan:        10, 2013                               Apr:       4, 2013

Feb:       7, 2013                                  May:      2,  2013

Mar:      7, 2013                                  Jun:        4,  2013
[/tab]

[tab title=”Venue”]
Leadway Assurance Training Centre 10, Abebe Village Road, Roof Top Apex Mill Building, Opposite
[/tab]

[tab title=”Fee”]
=N=35,000.00 per participant. This fee covers all course materials, Tea and lunch break
[/tab]

[tab title=”Register”]

[breezingforms name=”Creating_Professional_Documents_with_Ease_Using_the_Advanced_Features_of_Word_2010_2010″ iframe=”1″ iframe_height=”450″ iframe_width=”100%”]

[/tab]
[/tabs]

[/section]

[section title=”Automating Reporting and Business Processes using VBA and Macros“]

[tabs]
[tab title=”Overview”]

Management and other regulatory reports are produced on a regular; daily, weekly, monthly etc. This reporting process usually involves repetitive processes which are error prone due to work pressure. Without any reasonable doubt 98% of these reports are done with Microsoft Excel which has the strength of automating this reporting process that involves many reports.

Excel macros can make your work easier and more productive by automating common tasks

This Course focuses on Visual Basic for Application (VBA), the programming language built into Excel. This course covers everything from recording simple macros through creating sophisticated user-friendly application and utilities.
[/tab]
[tab title=”Objectives”]
The main objective is to equip participants on how to automate processes done repeatedly. This course will take participants beyond recording simple macros. “Everybody can use the camcorder to record event, but it takes professionalism to edit the recording”
[/tab]

[tab title=”Course Content”]
Understanding the VBA Editor
Introduction to Excel Objects
VBA Sub and Function Procedures
Understanding the concept of recording in absolute and relative mode
Understanding the VBA language Elements
Working with Range Objects
Using VBA and Worksheet Functions
Controlling Program Flow and Making Decisions
Automatic Procedure and Event
Error-Handling Techniques
Bug Extermination Techniques
UserForm Techniques and Tricks
[/tab]

[tab title=”Special Note”]
Prerequisites:-  It is expected that participants has foundational knowledge in using excel functions and excel objects. It highly recommended that participants attend our effective and efficiency techniques in Excel class before attending this course. Programming skill not required for this course

For effective training delivery, the maximum size of this class is 8 participants per class.  This course is project oriented course; participants are expected to deliver a project 2 weeks after attending before certificates are issued.

[/tab]
[tab title=”Duration”]
3 Days
[/tab]
[tab title=”Date”]
12th – 15th February 2013

23rd – 26th April 2013
[/tab]

[tab title=”Venue”]
Leadway Assurance Training Centre 10, Abebe Village Road, Roof Top Apex Mill Building, Opposite
[/tab]

[tab title=”Fee”]
=N=150,000.00 per participant. This fee covers all course materials, Tea and lunch break
[/tab]

[tab title=”Register”]

[breezingforms name=”Automating_Reporting_and_Business_Processes_using_VBA_and_Macros” iframe=”1″ iframe_height=”450″ iframe_width=”100%”]

[/tab]
[/tabs]

[/section]

[section title=”Structured Query Language Training for non IT professional“]
[tabs]
[tab title=”Overview”]
There is a trend developing in business for non IT people to understand and use SQL (structured query language) to query relational database management systems

Business people new to databases (how they actually work and why they are designed in particular ways) need to grasp some basic database concepts before tackling the intricacies of SQL.

This SQL training course is provided for people with minimum understanding of relational databases (Access, Oracle, SQL Server, MySQL etc) who just want to demystify relational database management systems.

[/tab]
[tab title=”Objectives”]
The Objective is to close the gap between ICT professionals and non-ICT professionals. Usually non-ICT professionals are left in dark when involved in projects that involves relational Database management systems (RDMS), these non-ICT professionals are also at the mercy of the ICT professional.

This course will expose non-ICT professional and upcoming ICT professional to the fact that SQL is an easy and high interactive language.  SQL is also one of the needed tools for forensic audit
[/tab]

[tab title=”Course Content”]
Select data from one table Alias columns
Rationalizing result sets with DISTINCT
Derive columns with arithmetic and concatenation
Cull records with the Where clause and relational operators
Expand the Where clause with logical operators AND and OR
Sort result sets with the Order By clause and nested sort orders
Understand and use relational and logical operators (use the keywords AND, OR, BETWEEN, NOT, IN, LIKE, TOP and IS NULL)
‘Grade’ a result set with TOP in conjunction with ORDER BY
Retrieve aggregated data into grand totals and subtotals using GROUP BY
Filter aggregated result sets with HAVING
UNION, INTERSECT and EXCEPT queries
Create subtotals and totals with COMPUTE and COMPUTE BY
Apply output selection logic to the select clause with simple and searched CASE
Join multiple tables in a query (INNER joins, OUTER (LEFT, RIGHT and FULL) joins, CROSS joins)
Table aliasing and ‘self’ joins
Further aggregation with multiple dimensions using ROLLUP, CUBE, the GROUPING function and the CASE statement combined
Queries that use sub-queries
Use the view builder to form the basis of a SQL statement
Use SELECT INTO to create tables from existing data
The importance and use of intrinsic SQL functions
Understand common SQL Server data types, data type precedence and implicit versus explicit data type conversion
Conversion Functions
[/tab]

[tab title=”Who Should Attend?”]

[/tab]
[tab title=”Duration”]
3 Days
[/tab]
[tab title=”Date”]
16th -18th April 2013
[/tab]

[tab title=”Venue”]
Leadway Assurance Training Centre 10, Abebe Village Road, Roof Top Apex Mill Building, Opposite Nigeria Breweries Iganmu.
[/tab]

[tab title=”Fee”]
=N=150,000.00 per participant. This fee covers all course materials, Tea and lunch break
[/tab]

[tab title=”Register”]

[breezingforms name=”Structured_Query_Language_Training_for_non_IT_professional” iframe=”1″ iframe_height=”450″ iframe_width=”100%”]

[/tab]
[/tabs]

[/section]

[section title=”Data Analysis, Business Modeling and Reporting with Excel 2007/2010“]

[tabs]
[tab title=”Overview”]
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.

[/tab]
[tab title=”Objectives”]
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.
[/tab]

[tab title=”Course Content”]
Dynamic Naming Range
Grouping and Outlining Data
Advanced use of conditional formatting
Advanced use of data validation
Database & List Management
Data Cleaning
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
[/tab]

[tab title=”Who Should Attend?”]

This program is designed for analysts who need practical data management & data analysis skills in Excel
[/tab]
[tab title=”Duration”]
2 Days
[/tab]
[tab title=”Date”]
9th -11th April 2012

25th – 27th Jun 2012
[/tab]

[tab title=”Venue”]
Leadway Assurance Training Centre 10, Abebe Village Road, Roof Top Apex Mill Building, Opposite Nigeria Breweries Iganmu.
[/tab]

[tab title=”Fee”]
=N=105,000.00 per participant. This fee covers all course materials, Tea and lunch break
[/tab]
[tab title=”Special Note”]
It is expected that participants have basic knowledge of Excel functions, techniques for effective data entry and familiarly with the Excel Ribbon
[/tab]

[tab title=”Register”]

[breezingforms name=”Data_Analysis_Business_Modeling_and_Reporting_with_Excel_2007_2010″ iframe=”1″ iframe_height=”450″ iframe_width=”100%”]

[/tab]
[/tabs]

[/section]

[section title=”PowerPivot for Self-Service Business Intelligence“]

[tabs]
[tab title=”Overview“]

Microsoft PowerPivot for Excel 2010 is a new technology aimed at providing self-service Business Intelligence (BI). PowerPivot is a real revolution inside the world of data analysis because it gives you all the power you need to perform complex analysis of data without requiring the intervention of BI technicians.

PowerPivot gives you the opportunity of working with millions of rows from different data source. With PowerPivot you can relate data from multiple tables without using the popular and nutty VLOOKUP.

As a self-service BI product, PowerPivot gives non IT professionals with no specialized BI or analytic training to develop data models and calculations, sharing them either directly or through SharePoint document libraries
[/tab]
[tab title=”Objectives“]
The Objective of this three day course to empower analyst and excel power users how to seamlessly analyze data from multiple database source with unlimited number of rows
[/tab]

[tab title=”Course Content“]

  • Pros and cons of the various versions of PowerPivot
  • How to install PowerPivot
  • Import and integrate data from spreadsheet, SQL Server, Access, Oracle, text file, Atom data feeds and other sources.
  • Creating and Managing Relationships
  • Analyze multiple tables together, without complicated VLOOKUPs
  • Understanding the DAX (Data Analysis Expression) functions
  • Using DAX FOR Aggregate Functions
  • Create powerful reports from PowerPivot data – and format them so executives instantly get your point
  • Discover PivotTable tricks that work even better in PowerPivot
  • Named Sets, GetPivotData and Cube Formulas
  • Control multiple PivotTable elements on one worksheet with one set of Excel 2010 Slicers
  • Using Time Intelligence functions
  • Publishing your Dashboard to SharePoint

[/tab]

[tab title=”Who Should Attend?“]

Data Analyst, Financial Analyst, consultants, Project Managers, Program Managers, Business Executives
[/tab]

[tab title=”Duration“]
3 Days
[/tab]

[tab title=”Date“]

19th -21st Feb 2013

26th – 28th March 2013
[/tab]

[tab title=”Venue“]
Leadway Assurance Training Centre 10, Abebe Village Road, Roof Top Apex Mill Building, Opposite Nigeria Breweries Iganmu.
[/tab]

[tab title=”Fee“]
=N=180,000.00 per participant. This fee covers all course materials, Tea and lunch break
[/tab]

[tab title=”Register”]

[breezingforms name=”PowerPivot_for_Self_Service_Business_Intelligence_Form” iframe=”1″ iframe_height=”450″ iframe_width=”100%”]

[/tab]
[/tabs]

[/section]

[section title=”Balanced Scorecard, Data Visualization and Dashboard Reporting“]

[tabs]
[tab title=”Overview”]

[/tab]
[tab title=”Objectives”]

[/tab]

[tab title=”Course Content”]

[/tab]

[tab title=”Who Should Attend?”]

[/tab]
[tab title=”Duration”]

[/tab]
[tab title=”Date”]

[/tab]

[tab title=”Venue”]

[/tab]

[tab title=”Fee”]

[/tab]
[tab title=”Special Note”]

[/tab]

[tab title=”Register”]

[breezingforms name=”Balanced_Scorecard_Data_Visualization_and_Dashboard_Reporting” iframe=”1″ iframe_height=”450″ iframe_width=”100%”]

[/tab]
[/tabs]

[/section]

[section title=”Automating Business Process with infopath form and Sharepoint“]

[tabs]
[tab title=”Overview”]

[/tab]
[tab title=”Objectives”]

[/tab]

[tab title=”Course Content”]

[/tab]

[tab title=”Who Should Attend?”]

[/tab]
[tab title=”Duration”]

[/tab]
[tab title=”Date”]

[/tab]

[tab title=”Venue”]

[/tab]

[tab title=”Fee”]

[/tab]
[tab title=”Special Note”]

[/tab]

[tab title=”Register”]

[breezingforms name=”Automating_Business_Process_with_infopath_form_and_Sharepoint” iframe=”1″ iframe_height=”450″ iframe_width=”100%”]

[/tab]
[/tabs]

[/section]
[/sections]

 

 

[sections]
[section title=”Test training”]
[tabs]
[tab title=”Wordpress”]
training for wordpress
[/tab]
[tab title=”sharepoint”]
[breezingforms name=”wordpress_form” iframe=”1″ iframe_height=”450″ iframe_width=”100%”]
[/tab]
[/tabs]
[/section]
[section title=”Seminar”]
<p style=”margin:5px 0;padding:0;”>
Section Content 2.
</p>
[/section]
[/sections]

Copyright 2013 Turning Point Data Consulting - All rights Reserved.
Powered By Comcity