Enter your keyword

Applied Excel

VIEW BY

Showing all 5 results

0

MS Excel – Advanced Level

1,300.00

The goal of this course is to equip trainees to be able to design and develop systems and templates in MS Excel to automate certain manual and repetitive processes.

Course Content:

  • System Design and Development in Excel (for Sales, Operations, Stocks data etc.)
  • Array Formulas (TRANSPOSE …)
  • Logical functions (IF, AND, OR…)
  • Summary functions (SUMIF, SUMIFS, COUNTA, COUNTIF…)
  • Reference functions (VLOOKUP, MATCH & INDEX …)
  • Text functions (PROPER, UPPER, CONCATENATE, LEFT…)
  • Data Validation to eliminate errors when entering data
  • Advanced Filtering
  • Analysing large data with Pivot Tables and Pivot Charts
  • More complex Conditional formatting
  • Preventing wrong date formats
  • Cell Locking and sheet Protection to minimize errors
  • Automating regular tasks by recording and replaying Excel Macros

Course Duration: 10 Hours

Course Fee: GHS 1300

 

0

Financial Modeling in MS Excel

1,500.00

The main objective of this course is to equip participants with relevant methods and techniques for building Financial Models and carrying out What-if analysis in MS Excel.

Course Content:

• Building Financial Models
• Financial functions (FV, PV, NPV, PMT…)
• Using Goal Seek to –
Investment decision-making
Basic/Gross Salary determination given Net Salary
Gross amount determination given Amount Payable
Pricing decision-making etc.
• Data Tables
Single-Input Data Table
Double-Input Data Table
• Using Scenario Manager for –
Efficient and effective Budget Reviews
Flexible Budgeting etc.
• Using Solver for –
Optimal Product or Service Mix (i.e., Profit Maximization,
Cost Minimization or Target Profit) given certain constraints,
Budget optimization and to determine if given targets are achievable.

Course Duration: 8 Hours

Course Fee: GHS 1500

0

Excel Dashboard Development

1,350.00

The main objective of this course is to train participants to design and build relevant dashboards to visually display Key Performance Indicators (KPIs) and trends in their organization; interactive and organized on a single sheet or screen so the information can be tracked at a glance to enhance management decision-making.

Course Requirements:

Each participant must already have at least an Intermediate level of knowledge of MS Excel. Areas to be covered and applied are Intermediate & Advanced level topics including:

Course Content:

  • Planning the Excel Dashboard Design
  • Tables & PivotTables for Excel Dashboard Data Analysis
  • PivotTables Summarize Values By calculations
  • PivotTables Show Values As calculations
  • GETPIVOTDATA function for Excel Dashboard Development
  • Creating Sparklines (mini charts in a single cells) from Pivot Tables
  • PivotTables Slicers (Visual filters)
  • Connecting Slicers to PivotTable Reports to make the Excel Dashboard interactive
  • Using Macros to enhance the interactivity of Excel Dashboards for presentation
  • Adding Hyperlinks for navigation
  • Adding new data to the Excel Dashboard
  • Protecting your Excel Dashboard

Course Duration: 8 Hours

Course Fees: 1,350

0

MS Excel – Intermediate Level

1,000.00

This course is aimed at equipping trainees to be able to design and develop systems and templates in MS Excel to automate certain manual and repetitive processes.

Course Content:

  • System Design and Development in Excel (for Sales, Operations, Stocks data, etc.)
  • Array Formulas (TRANSPOSE …)
  • Logical functions (IF, AND, OR…)
  • Summary functions (SUMIF, SUMIFS, COUNTA, COUNTIF…)
  • Reference functions (VLOOKUP, MATCH & INDEX …)
  • Text functions (PROPER, UPPER, CONCATENATE, LEFT…)
  • Data Validation to eliminate errors when entering data
  • Advanced Filtering
  • Analysing large data with Pivot Tables and Pivot Charts
  • More complex Conditional formatting
  • Preventing wrong date formats
  • Cell Locking and sheet Protection to minimize errors
  • Automating regular tasks by recording and replaying Excel Macros

Course Duration: 6 Hours

Course Fee: GHS 1300

 

0

MS Excel – Foundation Level

800.00

This course introduces participants to the fundamental tools and functions of Microsoft Excel. Participants learn how to create, edit, format, and print basic Microsoft Excel worksheets and workbooks.

Course Content:

  • Customizing Excel
  • Customizing the Quick Access Toolbar
  • Relative and Absolute cell referencing
  • Worksheets and Workbooks manipulations
  • Alt key help
  • Selection techniques
  • Manipulating rows and columns
  • AutoFill and Custom lists
  • Database guidelines and Sorting data
  • Searching and replacing data
  • Switching between worksheets
  • Copying or moving worksheets between workbooks
  • Font, Alignment and Number formatting
  • Freezing row and column titles
  • Basic Formulas and functions (SUM, AVERAGE, COUNT, IF etc.)
  • Working with Charts
  • Printing in Excel with ease

Course Length: 1 month (Saturdays only)

Course Fee: GHS 800