MICROSOFT EXCEL AND DATA ANALYSTIC TRAINING
TRAINING REGISTRATION FORM
INTERMEDIATE EXCEL COURSE OUTLINE
COURSE OBJECTIVES:
Microsoft Excel is the most commonly used spreadsheet application in the World today. It is a sine qua non Tool to all Professionals who want make an indelible mark in their chosen career. It is applicable in nearly all fields of human endeavours. Therefore, learning how to use Excel proficiently is an investment in both your personal and professional life. This course is designed for you to fit in both at the entering level and in a Managerial position of your organization.
Intermediate Microsoft Excel course is designed for participants who have used Excel before and who want to expand their knowledge. Improving formatting, organizing data, highlighting key information and creating formulas/links between sheets.
Prerequisites
The prerequisite is a good and sound knowledge of Basic Excel. Working knowledge of creating/formatting simple spreadsheets, basic formulas and functions
Benefits
At the end of the training participants will be able to
- Quickly summaries multiple sheets of data into one
- Turn long lists and reports into easy-to-read tables
- Formulas to check whether cells pass or fail your rules
- Create links between cells so that they all update automatically
- Consolidate Data in Multiple sheets
- Protect your workbook
- Design chat and Dashboard
- Highlight targets, trends, duplicates and errors with Conditional Formatting
- Formatting and layout consistency by saving as a Template
DURATION OF COURSE: 2 days in our Office
AMOUNT: N30,000.00
Course Content
- Formatting of Table
- Insert, Format Cell and Delete cell
- Deleting of Multiple Cells
- Recurring of Dates
- Currency Symbol
- Fraction
- Date & Time Formatting
- Percentage
- Text Formatting
- Number Formatting
- Text Wrap & Merge
- Conditional Formatting
- Total & Subtotal
- Filter & Sorting
- Find & Replace
- Gridlines
- Split / Hide Sheet
- Freeze Planes
- linking of Cells and Worksheet
- Data Consolidation
- Sum IFS
- Removal of Duplicate
- Transposing Column to Rows
- Insert Chart, Picture & Table
- Cell & Sheet Protection
- Workbook Protection
- Comment
- Cell Reference
- Designing of Invoice & Receipt
- Creating Hyperlink in Excel
- Dashboard
- Named Ranges
- Creating Easy Data Entry Forms in Excel
- View (Page Break)/Printing
CLICK ON WHATSAPP BELOW TO REGISTER
CLICK TO PREVIEW TRAINING VIDEOS
SHARE
DATA ANALYTICS AND ADVANCED EXCEL
COURSE OBJECTIVES
This program is organized to raise qualified Data analyst with theability to analyse Financial, Economic, Banking, Business and Accounting data for Management decisions taking. Microsoft Excel is one of the top tools for data analysis and the built-in pivot tables are arguably the most popular analytic tool. This program will walk you through the entire data analysis process, which includes: Posing a question; Wrangling your data into a format you can use and fixing any problems with it; Exploring the data, finding patterns in it, and building your intuition about it; Drawing conclusions and/or making predictions and Communicating your findings.
This Program is Organized for Accountants, Financial controllers, Financial Managers, Business analysts, financial analysts, Business Owners and Entrepreneurs, Individuals for personal finance, Business development managers, SMEs Advisers, Master’s Degree and PHD Students.
COURSE FEE: N50,000
Course Outline
Section 1 Advanced worksheet Functions
- Introduction
- Understanding excel interface;
- Work with ribbons;
- Most powerful excel dialogue boxes;
- 20 hottest excel shortcuts.
Section 2 Data Separation and Data Joining
2.1. Flash Fill and Auto
2.2. Delimiters
2.3. Ampersand
2.4. Concatenate
Section 3 Cell Reference
3.1. Relative Cell Reference
3.2. Absolute Cell Reference
3.3. Mixed Cell Reference
Section 4 Conditional & Logical Functions
4.1. Using logical functions
4.2. Using If and Nested IF Function
Section 5 What-if Analysis
5.1. Scenario Manager
5.2. Goal Seek
5.3. Solver for Goal Seek
Section 6 Pivot Tables and Pivot Charts
6.1. Using the PivotTable Wizard
6.2. Using Pivotable and Subtotal
7.3. Using Calculated Field
6.4. Using Timeline for Filtering Report
6.5. Creating Pivot Charts
6.6. Using Slicers to manipulate PivotTables
Section 7 working with Large Data
7.1. 3D Formular (sum)
7.2. Data Consolidation
Section 8 Lookups functions
8.1. The VLOOKUP functions
8.2. The HLOOKUP function
8.3. INDEX and MATCH function
Section 9 Loan Repayment Schedule
9.1. Calculating Monthly Payment with PMT function
9.2. Calculating Payment on Principal with PPMT function
9.3. Calculating payment on Loan Interest with IPMT function
Section 10 Sorting and Filtering
10.1 Using of advanced sorting and filtering
10.2. Using Text and Number Filter
Section 11 Advanced list management
11.1. Using data validation
11.2. Setting criteria for entry of text, values and dates
11.3. Creating a dropdown list
Section 12 Auditing Formular
12.1 Auditing Features
CLICK ON WHATSAPP BELOW TO REGISTER
CLICK TO PREVIEW TRAINING VIDEOS
SHARE
FINANCIAL MODELING
COURSE OBJECTIVES:
In today’s scenario of economic unpredictability and random upheavals in trade and commerce, Financial Modelling has become an important skill to have.It is the most widely sought-after skills by Accountants, Bankers and finance Managers in the World today. It is the art of building a model to depict financial statements and investment analysis using Microsoft Excel. This helps to arrive at optimal business solutions by analysing various parameters. Financial models can be used to represent the performance of a business, a project or any other investment. In today’s world, all decisions made are based on quantitative analysis and information. This is why Accountants,Bankers, Investment Business Analyst, Equity Research Analysts, and FundManagers find Financial Modelling indispensable.
This Program is Organized for Financial Modellers, Consultants, Accountants, Financial controllers, Financial Managers, Business analysts, financial analysts, Business Owners and Entrepreneurs, Individuals for personal finance, Business development managers, SMEs Advisers, Master’s Degree and PHD Students.
COURSE FEE: N120,000
Course Outline
1. Fundamentals of Financial Modelling
- Financial Statements Basics
- Fundamentals of Financial Modelling
2. Mastering Financial Analysis
- Building a Financial Ratio Database in Excel
- Practical Modelling: The Cost-Volume-Profit Relationship
- Measuring and Improving Return on Investment
- Measuring and Improving Asset Management Efficiency
- Measuring and Managing Capital Structure and Risk
- Practical Modelling: The Effect of Gearing on Shareholders’ Earnings
3. Financial Projection
- Introduction of Spin button and combo box for projection
4. Financial Planning
- Modelling Income Statement,
- Balance Sheet, cash flow,
- Financial ratios,
- financial statement forecasting
5. Improving Financial Forecasting
- Practical Modelling: Using Excel Statistical Analysis Tools
- Avoiding Common Forecasting Problems
- Using Moving Averages to Analyze Time Series Data
- Using Linear Regression for Sales Trend Analysis
- Using Excel Solver to Minimize Forecasting Error
- Using Regression and Correlation to Forecast Costs
- Practical Modelling: Cash Flow Forecasting
6. Financial Models to Improve Investment Decision-making
- Principles of Capital Investment Decision-making
- Sources and Cost of Business Finance
- Investment Appraisal techniques e.g (NPV, IRR, PBP)
- Practical Modelling: Using Excel Discounted Cash Flow Tools (DCF)
- Practical Modelling: Capital Investment Analysis
- Essentials of Business Valuation
- Practical Modelling: Business Valuation Based on Shareholder Value Added
7. Time Value of Money
- PV and FV of Annuity; (Single and Multiple Cash flow),
- Amortization;(Constant and general Discount rate),
- Sensitivity analysis.
8. Managing Risk and Uncertainty
- Identifying and Analyzing Business Risk
- Probability Based Approach to Decision-making
- Monte Carlo Simulation
- Sensitivity Analysis and “what-if”Forecasting
- Identifying the Key Drivers of Financial Performance
- Practical Modelling: Key Driver “what-if”Forecast
9. Valuation: Stock and Bond valuation with sensitivity analysis using spin buttonased Approach to Decision-making