Abuja, Kaura
6 views
Microsoft Excel for All Users- Beginner to Expert : Training
Brifek Technologies Limited
Company Name
Courses
Type
Business
Subtype
Finance
Topics
Advanced
Level
25
hours
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
Open now
• 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
Safety tips
- Check Feedback to make sure the person is reliable
- Agree on the scope of work and remuneration
- Meet in person at a safe public place