fbpx

.....securing africa

Excel Masterclass

Abiola David (Is the only Microsoft MVP in Africa).
Microsoft® Excel MVP | Author | Trainer | Speaker | Blogger | Trainer | Founder, Excel Jet Consult

Abiola David is a Microsoft Excel, Power BI, SQL Server Consultant, Speaker, Author and Blogger. He is Microsoft MVP (Excel)

He is the Founder of Excel Jet Consult, a data analytics hub located in Lagos, Nigeria.

He believes that the more advanced professionals are in using the productivity and Business Intelligence tools -Excel and Power BI, the more efficient and productive they become! In light of these, he uses his vast knowledge to help companies improve their business processes and decision making.

In addition, he regularly facilitate Excel training at many universities in Nigeria and for NYSC Corp members serving in Lagos, Nigeria. The brain behind these is to equip the young graduates with in-demand skills which will increase their employability portfolio and improve their job prospecting. He has delivered bespoke training for Senior Staff at the Federal Ministry of Petroleum Resources and staffs from Guinness Nigeria, GTBank, Access Bank to name a few

He deliver online teaching via Youtube videoss

Training will include a certificate from him personally, this is regarded s a life time opportunity that shouldn’t be taken for granted

Saturdays 3pm to 6pm

Skillup Africa training center, Cvilla resorts 45, muiz banire way Abraham adesanya off Ajah

1. Introduction to Excel Interface, Tabs and Commands
2. Data Entry in Excel Way
3. Understanding Formulas and Basic Functions
4. Types of Cell References
5. Across Sheet Reference
6. Chat Types.
7. Understand Named Ranges
8. PivotTable and PivotCharts
9. Lookup Family Functions
10. SUMIFS, COUNTIFS, AVERAGEIFS
11. Logical Functions (IF, IFS, AND, OR, Nested IF Statement)
12. Text and Date Functions
13. Accounting Functions
14. Introduction to Power Query
15. Building Dashboard
16. Tips, Tricks and Shortcuts