Microsoft Excel for All Users- Beginner to Expert : Training

+1

Brifek Technologies Limited

Company Name

Courses

Type

Business

Subtype

Finance

Topics

Advanced

Level

25hours

Duration of Entire Course in Hours

Distance Learning, Home Lessons

Service Features

Store address

Abuja (FCT) • Kaura

Suite HF 50D, Kaura Modern Market, opp. Prince and Princess Estate, 900104, Abuja

Closed

• Mon - Sat, 08:00-19:00

100% hands-on training with real company data from 20 companies across different industries. Pt1- basic features: paste special, fill series, cell referencing, cell ranges, name manager, numbers, date, time etc pt2- functions: syntax, pemdas, categories of functions,financial function, functions for engineers, scientists, etc. Pt3- basic data management: filter, data conversion, validation, cleaning, sorting, dropdown list, vlookup & hlookup. Pt4- data visualization: scatter plots, column, and pie charts, pivot tables, slicers, sparklines, geographical maps. Pt5- advanced data management: two-way lookup, two-way conditional lookup, etc pt6- financial applications: simple & compound interest, effective & nominal interest rate, depreciation, etc pt7- what-if analysis: one-way & two-way data table, solver for the optimization problem pt8- model building: model building in excel, trendlines, linear interpolation, simple linear regression, general linear regression, multilinear regression

Show contact