PricewaterhouseCoopers survey:
Stress about financial concerns
distracts 29% of workers from their
jobs. http://bit.ly/hDKMUi 12 days ago
There is nothing so useless as
doing efficiently that which should
not be done at all. - Peter Drucker #Quote 12 days ago
Are you’re looking to grow your
business efficiently? 12 days ago
BUSINESS!
Give me six hours to chop down a tree and I will s... Read more...
Quotes "If you go to work on your goals,
your goals will go to work on you.
If you go to work on your plan,
your plan will go to work on you. Whatever good things we build
end up building us."
The demand for skill acquisition among members of the labour force, especially regarding the use of business tools such as Microsoft Excel (“Excel”), is currently on the rise. This is in line with the growing recognition among workers of the need to build proficiency in use of spread sheet applications in order to stay relevant in the workplace as well as maintaining a competitive edge over their peers. As the most commonly used spread sheet application in the world, Microsoft Excel is without doubt one of the most essential tools in the workplace.
However, most users fail to harness the capabilities of this application in improving overall effectiveness. In fact, studies have shown that Excel users explore only a fraction of Excels’ brilliant features and computation power. One survey among regular users revealed that at least 9 out of 10 of Excel's most powerful features are never used.
But with our training, you would be able to unleash the true power of this application and become a member of an elite group of indispensible professionals who:
Get more work done with fewer resources
Expend minimal effort in implementing tasks
Reduce time spent on tasks (e.g. reports) from hours/days to seconds/minutes; and
As such we expect that by the end of this course, participants would be able to:
Work effectively with large volumes of texts and numerical data in Excel, without breaking into a sweat
Enjoy the use of a wide vocabulary of key concepts, functions, and “power-tips” as they enhance their mastery of the application
Design Excel-based templates fordata collection, analysis and reporting
Automate all manner of work activities/tasks in Excel, amongst others.
Our Approach
This involves a 2 day intensive training running from 9 am – 5 pm each day. Participants learn about Excel through a series of hands-on exercises as they apply learned concepts in implementing tasks.
Time would be devoted to tackling Case studies and Excel-related challenges which participants typically encounter at work. Participants would also enjoy two (2) months of free post-training support.
Course Outline Day 1
Data Validation
Sorting and Filtering (including Advanced Filtering tools)
Implementing Data validation (using simple and dependent data validation techniques)
Use of Excel Functions in work activities
Logical Functions: IF, AND, OR, NOT,etc
Lookup Functions: VLOOKUP, CHOOSE, Improving VLOOKUP capabilities through the combination of INDEX&MATCH, etc
Text Functions: LEFT, RIGHT, MID, SEARCH, SUBSTITUTE, etc
Tackling text problems: manipulating and formatting text as well as managing large volumes of text data
Use of conditional formatting in data analysis
Consolidation of Excel data (across several worksheets)
Introduction to New Functions in Excel: SUMIFS, COUNTIFS, etc
Analyzing data with Excel Tables
Creating and manipulating tables
Use of Table functions
Working with Dates and Time in Excel
Day 2
Dependent Data Validation
Use of Relative & Absolute referencing
Types of formulae: array, 3-dimensional, etc
Working with Goal Seek (e.g. breakeven analysis, etc)
Working with Pivot Tables& Pivot Charts:
Creating pivot tables
Learn about analyzing data with pivot tables using tools such as grouping, conditional formatting, etc.
Working with calculated fields in pivot tables
Creating Charts in line with best practices
Find the appropriate chart for numerical data
Design more complex and professional looking charts e.g. waterfall charts
Charts for Project management (Gantt charts, etc)
Application of Form Controls: combo boxes, scroll bars, check box, option box, etc
Linking with other Microsoft Office applications (e.g. Word, PowerPoint, Outlook, Access) and the Web
Introduction to Power Pivot and other new tools in Microsoft Excel 2010
Introduction to Macros and VBA
Case studies
Course requirements Participants may be required to have some basic knowledge of Microsoft Excel and attend the training with their laptops (with Microsoft Excel installed).
Course fee
₦60,000 per participant (includes Course materials, Tea break and Lunch)
State
Bank
Account Name
Account Number
Lagos Training
GT Bank
Albert & Benjamin Ross
223 863 276 110
Lagos Training
Zenith Bank
Albert & Benjamin Ross
6017107432
Available discounts Early bird discount
Save up to:
5% if you register and pre-pay at least 2 weeks prior to the scheduled course date; or
10% if you register and pre-pay at least 4 weeks prior to the scheduled course date
Group discount
5% off course fees if 2 - 3 individuals register and pay for the same course together;
10% off course fees if 4 - 6 individuals register and pay for the same course together; or
Up to 15% off course fees if 7 or more individuals register and pay for the same course together
The group discount will be applied to each individual course registration.
Lead Facilitator
GbengaAdetimehin is the Managing Partner of a business services advisory firm with competence in Microsoft Excel and Access consulting and training. He has used Microsoft Excel extensively as a Financial Adviser in the development of project and corporate financial models.
Some of his past projects include:
design and construction of Excel-based financial models to support growth and fund raising strategies for projectsin industries such as real estate, healthcare, media and communications, information technology, etc;
development of a complex Budget Forecast and Reporting template for one of Nigeria’s top telecommunications companies (demo);
creation of a Pricing model for a major Nigerian transport and logistics operator; and
design and deployment of a Microsoft Access-based Customer Relationship Management system for a leading Asset Management Firm. This centralized database facilitated real time multi-user access across three regional offices in different parts of the country.
