Arusha Computing Centre

Imparting Knowledge & Technical Skills

home
Facebook Instagram

Financial Spreadsheets

Transforming Data into Decisions

Overview

This course will give participants a thorough training in advanced skills needed to produce sophisticated reports, perform complex mathematical and statistical calculations, and improve productivity using a spreadsheet application. Spreadsheets are an important tool for managing and analyzing financial data that will help professionals use the complex capabilities of spreadsheet tools to understand data and make informed decisions.

After taking this course, you will gain expertise in;

  • Understand functions such as those associated with logical, statistical, financial, and mathematical operations
  • To make use of tables and lists to analyze, filter, sort, validate, and audit data, as well as create and use scenarios
  • How to apply advanced formatting options such as conditional formatting, customized number formatting, and chart formatting
  • To use linking, embedding and importing features as well as comparing and merging spreadsheets
  • To understand the productivity and security features of spreadsheet tools.

Target Group

  • Banks
  • Microfinance
  • Saccos

Training Schedule

TOPIC CONTENT
Formatting
  • Apply conditional formatting.
  • Create and apply custom number formats.
  • Split text to columns.
  • Copy, move worksheets between spreadsheets.
  • Split a window. Move, remove split bars.
  • Hide, show rows, columns, worksheets.
  • Save a spreadsheet as a template, modify a template.
Formulas and Functions
  • Use date and time functions: today, now, day, month, year, network days.
  • Use logical functions: and, or, not.
  • Use mathematical functions: round down, roundup, sumif, sumifs.
  • Use statistical functions: countif, countblank, rank.
  • Use text functions: left, right, mid, trim, concatenate.
  • Use financial functions: fv, pv, pmt, xnpv, sln, db.
  • Use lookup and reference functions: vlookup, hlookup, index and match.
  • Create a two-level nested function.
  • Use a 3-D reference within a sum, average, minimum, maximum function.
  • Use mixed references in formulas.
Creating and Formatting Charts
  • Create a combined chart like: column and line, column and area.
  • Create, change, delete a sparkline.
  • Add a secondary axis to a chart.
  • Change the chart type for a defined data series.
  • Add, delete a data series in a chart.
  • Re-position chart title, legend, data labels.
  • Change scale of value axis: minimum, maximum number to display, major interval.
  • Change display units on value axis without changing data source: hundreds, thousands, millions.
  • Format columns, bars, pie slices, plot area, chart area to display an image.
Analysis
  • Create, modify a pivot table/datapilot.
  • Modify the data source and refresh the pivot table/datapilot.
  • Filter, sort data

Why Choose Us?

At Arusha Computing Centre, we are committed to providing a learning experience that is both effective and engaging. Our course offers:

  • Interactive sessions with expert instructors.
  • Real-world case studies and practical exercises.
  • Flexible learning schedules.
  • Access to a wide range of resources and support.

Enroll Today!

Start your learning journey today. Enroll in our courses for a straightforward, impactful educational experience. 

Join our courses today

Acc offers various courses ranging from Basic Computer Applications, Professional Computer Courses to Academic Programmes.

Get Started

WHAT WE OFFER

Quick Links

Reach us

  • NSSF Kaloleni Plaza, 1st Floor, Florida Roundabout
  • Saidi Kondo Building, opposite St. Thomas Hospital near Metropole.
© 2022 All Rights Reserved | Designed by Arusha Computing Centre
Facebook-f Instagram