Course curriculum

  • 01

    Live_On_Line

  • 02

    INTRODUCTION

  • 03

    MANAGE WORKBOOK

    • WORKSHEET & WORKBOOK

    • BACKSTAGE VIEW

    • EXCEL FORMULA

    • FORMULA ELEMENTS

    • FORMULA EXERCISE

    • NAME CELL EXERCISE

    • CELL RANGE EXCERCISE

    • CELL REFERENCES

    • RANGE NAME

    • MANAGE WORKBOOK ASSESSMENT
  • 04

    TEXT FORMULA

    • AMPERSAND

    • CONCATENATE

    • CONCAT

    • CHAR (10)

    • TEXT

    • EXERCISE CONCATENATE

    • EXERCISE JOIN CELL

    • EXERCISE CHAR(10)

    • EXERCISE CHAR(10) & TEXT

    • EXERCISE CHAR(10)&TEXT

    • TEXT FORMULA ASSESSMENT
  • 05

    MATHEMATICAL & TRIG

    • COUNT

    • COUNTA

    • COUNTIF

    • COUNTIFS

    • SUMIF

    • SUMIFS

    • SUMPRODUCT

    • EXERCISE COUNT

    • EXERCISE COUNTIFS

    • EXERCISE SUMIFS

    • EXERCISE SUMPRODUCT

    • MATHEMATICAL FUNCTIONS ASSESSMENT
  • 06

    DATA VALIDATION

    • DATA VALIDATION

    • DATA VALIDATION LIST

    • DATA VALIDATION INPUT

    • DATA VALIDATION ASSESSMENT

    • EXERCISE DATA VALIDATION-1

    • EXERCISE DATA VALIDATION-2
  • 07

    LOGICAL FUNCTIONS

    • 5.7 IF ERROR-01

    • 5.5 IF _ OR-01

    • 5.3 IF _ AND-01

    • 5.2 AND-01

    • 5.1 IF-01

    • 5.4 OR-01

    • 5.6 Nested IF-01

    • 5.2 IFS-01

    • LOGICAL FUNCTION ASSESSMENT
  • 08

    LOOKUP & REFERENCES

    • 5.0 LOOKUP-01

    • 5.2 V Look Up-01

    • 5.2 VLOOKUP APPROXIMATE-01

    • EXERCISE VLOOKUP

    • EXERCISE VLOOKUP APPROXIMATE MATCH

    • 5.4 CHOOSE-01

    • 5.5 CHOOSE _ SUM-01

    • INDEX-01

    • INDEX ROW-01

    • 5.6 INDEX COLUMN

    • 5.7 INDEX TABLE-01

    • 5.6 Sum _ Index-01

    • 5.8 INDEX _ SUM-01

    • 5.8 MATCH-01

    • 5.7 Match-01

    • 5.8 INDEX & MATCH

    • EXERCISE INDEX

    • EXERCISE INDEX & MATCH

    • 5.10 X LOOKUP VERTICAL-01

    • 5.11 X LOOKUP HORIZENTAL-01

    • X LOOKUP LEFT-01

    • 5.13 X LOOKUP APPROXIMATE MATCH-01

    • 5.12 X LOOKUP MORE RESULT-01

    • 5.14 X LOOKUP ERROR-01

    • 5.15 NESTED X LOOKUP-01

    • XLOOKUP SEARCH MODE-01

    • 5.16 X LOOKUP WILDCARD-01

    • EXERCISE XLOOKUP 01

    • EXERCISE XLOOKUP 02

    • LOOKUP & REFERENCES ASSESSMENT
  • 09

    FINANCIAL FUNCTIONS

    • 8.01 FINANCIAL FORMULA-01

    • 8.02 TIME VALUE OF MONEY-01

    • 8.3 INTEREST RATE-01

    • 8.3 COMPOUNDING RATE-01

    • 8.4 DISCOUNT RATE-01

    • 8.5 FV FUNCTION-01

    • 8.6 PV FUNCTION-01

    • 8.6 NPV INVESTMENT-01

    • 8.7 NPV FUNCTION-01

    • 8.8 XNPV

    • 8.9 IRR-01

    • 8.9 XIRR

    • 8.10 IRR _ NPV-01

    • 8.11 PMT LOAN PAYMENT-01

    • 8.12 PPMT PRINCIPLE AMOUNT-01

    • IMPT-01

    • 8.13 LOAN PAYMENT AMORTIZATION-01

    • 8.14 SLN DEPRECIATION

    • 8.15 DB DEPRECIATION-01

    • EXERCISE NET PRESENT VALUE

    • EXERCISE FUTURE VALUE

    • EXERCISE PRESENT VALUE

    • EXERCISE LOAN AMORTIZATION

    • FINANCIAL FUNCTION ASSESSMENT
  • 10

    DATE AND TIME

    • DATE AS A SERIAL NO.

    • DATE TO SERIAL NO.

    • DATE VALUE FUNCTION

    • DAY-MONTH-YEAR

    • END OF THE MONTH

    • DATE FORMAT

    • EXERCISE DATE AND FORMAT

    • EXERCISE INVOICE DUE DATE

    • DATE& TIME ASSESSMENT

    • EXERCISE DAY-MONTH-YEAR

    • EXERCISE INVOICE DUE DATE
  • 11

    CONCLUSION

    • ADVANCED EXCEL ASSESSMENT

    • GBT Solutions Advanced Excel 2019 Survey

    • CONCLUSION

About The Instructor

Mohamed Faris, ACMA, CGMA, CMA, CPA An internationally renowned Financial and Technology consultant with more than 20 years of global experience in multinational companies,Banking and Financial services, in Europe, North America, Africa and the Middle East, Mohamed has worked for top recognized global brands including, Shell Co., SABIC, SIEMENS & DAL Group. He has substantial experience in training and advising corporate executives on business strategy, Business valuation modelling, corporate restructuring, M&A, Business Performance Management and Management Information Systems. Mohamed is a Chartered Management Accountant (ACMA), Chartered Global Management Accountant (CGMA), Certified Management Accountant (CMA) and Chartered Professional Accountant (CPA). He graduated with first class degree in Cost and Management Accounting and hold a master degree in Business Information Technology from university of Westminster UK.

Mohamed Faris

Founder and Director