This course is conducted in English and PC/Windows operating system

2-Day Microsoft Excel Advanced Formulas And Functions Course
In Singapore

Learn most challenging advanced excel formulas and functions, and power formulas to crunch and analyse data

Microsoft Excel Advanced Formulas And Functions Course Overview

As jobs globally require advanced Microsoft Excel knowledge, it is undoubtedly one of the most important skills any employee can have. Our advanced Excel formulas and functions course in Singapore does the job of prepping you well for using Excel efficiently at work.

However, 95% of Excel users use a mere 5% of the program’s power formulas in improving work efficiency. Without these formulas, Excel becomes a data keeping tool.

By using formulas, you can crunch, analyse and glean insights from the data for complex questions. Anyone can use a simple SUM or IF formula, but an advanced user would be able to seamlessly write & combine formulas like SUMIFS, SUMPRODUCT, INDEX, MATCH, VLOOKUP formulas. Apart from knowing the formulas, advanced Excel users know how to audit, debug and employ different Excel formulas for different problems. For any given problem, having a few alternative methods on hand can prove useful as well.

In the Microsoft Excel Advanced Formulas and Functions course, learners will be shown some of the most challenging formulas and functions in Excel and how to best use them. This course delves into practical examples that will help users easily transition to using these formulas and functions in real-world scenarios.

At the end of the course, learners are able to:

  • use those functions in the following function categories:

    – IFs Functions
    Information Functions
    – Statistical Functions
    – Math Function
    – Date Functions
    – Text Functions
    – Lookup and Reference Functions
    – Database Functions

  • mix and match functions
  • solve real-life problem using functions
  • automate work using functions
  • analyse problems and derive solutions
  • strengthen Excel skills with formulas and functions
  • automate tasks to increase productivity
  • perform advanced searching and data retrieval with Lookup functions
  • create statistic reports with criteria applied using Statistical functions
  • extract required text from given string using Text functions and many more

This course is for anyone:

  • who has completed the Excel Advanced course
  • who wants to advanced their skills in Excel
  • who is highly interested to learn problems solving in Excel
  • who is a power user in Excel

This is a hands-on practical course. Our trainer will walk through each of the topics step-by-step. Learners will also be provided with exercise files on each topic to effectively apply what has been taught. A short Q & A session will be available after each topic.

This Excel Advanced Formulas and Functions course is suitable for those

  • with an advanced working knowledge of Excel who want a greater understanding of more sophisticated formulas and functions within Excel.
  • familiar with creating functions including IF, OR, AND, nested functions, VLOOKUPs and HLOOKUP 
  • PC/Windows operating system laptop (personal laptops are preferred as some company laptops may have restrictions in accessing the Internet and USB thumb drive)
  • Laptop power adaptor
  • A USB mouse
  • A USB thumb drive or hard-disk
  • Software requirement: Microsoft Excel version 2010-2019 or Office 365

Course Outline

Our Dedicated Trainer

Having trained adult learners specialising in IT from both public and private sectors since 1986, Alaster has a wealth of experience in training. Before moving into the training sector, Alaster worked in IT for over 12 years – boasting a wide range of roles held within software development. Prior to being approved by People’s Association (PA), Alaster was an Associate Trainer with the Civil Service College. He also holds Microsoft Office Specialist (MOS) certification and specialises in training Microsoft Office Applications and Adobe Photoshop.

With his vast experience and commitment to keeping abreast with emerging trends, tools and technologies within the IT and software industry, Alaster is extensively involved in developing course outlines and materials that equip learners with up-and-coming skills in demand for the future of work.

In constantly exploring innovative and effective methods of imparting knowledge, Alaster is able to engage his learners in the courses he conducts. A large part of his trainings are committed to providing practical solutions to real-life problems, especially in the Excel courses he conducts. An approachable and engaging trainer, Alaster is always willing to aid his learners in overcoming various problems using the skills acquired even after courses. Well-known and liked for his dedication, commitment and passion for training, Alaster is appreciated by his learners.

Alaster’s strong background reinforces his capabilities in conducting the Microsoft Excel Advanced Formulas and Functions course. This course is conducted in Singapore – perfect for anyone who needs to brush up on their skills in using advanced Excel formulas and functions.

Online Registration

For organisations applying with more than 2 learners, please click here to download the registration form.

All registration forms should be submitted at least 2 weeks before course commencement. Many courses have pre-requisites, intended to foster a learner’s success in the course. Be sure to check the necessary pre-requisites before registering.

Apply Online

Company Registration Form – Excel Advanced Formulas

  • 18-19 Nov 2019, 9am-5pm
  • 27-28 Apr 2020, 9am-5pm
  • 22-23 Jun 2020, 9am-5pm
  • 31 Aug-1 Sep 2020, 9am-5pm
  • Mr.
  • Mrs.
  • Ms.
  • Miss
  • Prof.
  • Dr.
🇸🇬
  • 🇦🇩
    Andorra +376
  • 🇦🇪
    United Arab Emirates +971
  • 🇦🇫
    Afghanistan +93
  • 🇦🇬
    Antigua And Barbuda +1268
  • 🇦🇮
    Anguilla +1264
  • 🇦🇱
    Albania +355
  • 🇦🇲
    Armenia +374
  • 🇦🇴
    Angola +244
  • 🇦🇶
    Antarctica +672
  • 🇦🇷
    Argentina +54
  • 🇦🇸
    American Samoa +1684
  • 🇦🇹
    Austria +43
  • 🇦🇺
    Australia +61
  • 🇦🇼
    Aruba +297
  • 🇦🇿
    Azerbaijan +994
  • 🇧🇦
    Bosnia And Herzegovina +387
  • 🇧🇧
    Barbados +1246
  • 🇧🇩
    Bangladesh +880
  • 🇧🇪
    Belgium +32
  • 🇧🇫
    Burkina Faso +226
  • 🇧🇬
    Bulgaria +359
  • 🇧🇭
    Bahrain +973
  • 🇧🇮
    Burundi +257
  • 🇧🇯
    Benin +229
  • 🇧🇱
    Saint Barthelemy +590
  • 🇧🇲
    Bermuda +1441
  • 🇧🇳
    Brunei Darussalam +673
  • 🇧🇴
    Bolivia +591
  • 🇧🇷
    Brazil +55
  • 🇧🇸
    Bahamas +1242
  • 🇧🇹
    Bhutan +975
  • 🇧🇼
    Botswana +267
  • 🇧🇾
    Belarus +375
  • 🇧🇿
    Belize +501
  • 🇨🇦
    Canada +1
  • 🇨🇩
    Congo, The Democratic Republic Of The +243
  • 🇨🇫
    Central African Republic +236
  • 🇨🇬
    Congo +242
  • 🇨🇭
    Switzerland +41
  • 🇨🇰
    Cook Islands +682
  • 🇨🇱
    Chile +56
  • 🇨🇲
    Cameroon +237
  • 🇨🇳
    China +86
  • 🇨🇴
    Colombia +57
  • 🇨🇷
    Costa Rica +506
  • 🇨🇺
    Cuba +53
  • 🇨🇻
    Cape Verde +238
  • 🇨🇾
    Cyprus +357
  • 🇨🇿
    Czech Republic +420
  • 🇩🇪
    Germany +49
  • 🇩🇯
    Djibouti +253
  • 🇩🇰
    Denmark +45
  • 🇩🇲
    Dominica +1767
  • 🇩🇴
    Dominican Republic +1809
  • 🇩🇿
    Algeria +213
  • 🇪🇨
    Ecuador +593
  • 🇪🇪
    Estonia +372
  • 🇪🇬
    Egypt +20
  • 🇪🇷
    Eritrea +291
  • 🇪🇸
    Spain +34
  • 🇪🇹
    Ethiopia +251
  • 🇫🇮
    Finland +358
  • 🇫🇯
    Fiji +679
  • 🇫🇰
    Falkland Islands (malvinas) +500
  • 🇫🇲
    Micronesia, Federated States Of +691
  • 🇫🇴
    Faroe Islands +298
  • 🇫🇷
    France +33
  • 🇬🇦
    Gabon +241
  • 🇬🇧
    United Kingdom +44
  • 🇬🇩
    Grenada +1473
  • 🇬🇪
    Georgia +995
  • 🇬🇭
    Ghana +233
  • 🇬🇮
    Gibraltar +350
  • 🇬🇱
    Greenland +299
  • 🇬🇲
    Gambia +220
  • 🇬🇳
    Guinea +224
  • 🇬🇷
    Greece +30
  • 🇬🇹
    Guatemala +502
  • 🇬🇺
    Guam +1671
  • 🇬🇼
    Guinea-bissau +245
  • 🇬🇾
    Guyana +592
  • 🇭🇰
    Hong Kong +852
  • 🇭🇳
    Honduras +504
  • 🇭🇷
    Croatia +385
  • 🇭🇹
    Haiti +509
  • 🇭🇺
    Hungary +36
  • 🇮🇩
    Indonesia +62
  • 🇮🇪
    Ireland +353
  • 🇮🇱
    Israel +972
  • 🇮🇳
    India +91
  • 🇮🇶
    Iraq +964
  • 🇮🇷
    Iran, Islamic Republic Of +98
  • 🇮🇸
    Iceland +354
  • 🇮🇹
    Italy +39
  • 🇯🇲
    Jamaica +1876
  • 🇯🇴
    Jordan +962
  • Japan +81
  • 🇰🇪
    Kenya +254
  • 🇰🇬
    Kyrgyzstan +996
  • 🇰🇭
    Cambodia +855
  • 🇰🇮
    Kiribati +686
  • 🇰🇲
    Comoros +269
  • 🇰🇳
    Saint Kitts And Nevis +1869
  • 🇰🇵
    Korea Democratic Peoples Republic Of +850
  • 🇰🇷
    Korea Republic Of +82
  • 🇰🇼
    Kuwait +965
  • 🇰🇾
    Cayman Islands +1345
  • 🇱🇦
    Lao Peoples Democratic Republic +856
  • 🇱🇧
    Lebanon +961
  • 🇱🇨
    Saint Lucia +1758
  • 🇱🇮
    Liechtenstein +423
  • 🇱🇰
    Sri Lanka +94
  • 🇱🇷
    Liberia +231
  • 🇱🇸
    Lesotho +266
  • 🇱🇹
    Lithuania +370
  • 🇱🇺
    Luxembourg +352
  • 🇱🇻
    Latvia +371
  • 🇱🇾
    Libyan Arab Jamahiriya +218
  • 🇲🇦
    Morocco +212
  • 🇲🇨
    Monaco +377
  • 🇲🇩
    Moldova, Republic Of +373
  • 🇲🇪
    Montenegro +382
  • 🇲🇬
    Madagascar +261
  • 🇲🇭
    Marshall Islands +692
  • 🇲🇰
    Macedonia, The Former Yugoslav Republic Of +389
  • 🇲🇱
    Mali +223
  • 🇲🇲
    Myanmar +95
  • 🇲🇳
    Mongolia +976
  • 🇲🇴
    Macau +853
  • 🇲🇵
    Northern Mariana Islands +1670
  • 🇲🇺
    Mauritania +222
  • 🇲🇸
    Montserrat +1664
  • 🇲🇹
    Malta +356
  • 🇲🇺
    Mauritius +230
  • 🇲🇻
    Maldives +960
  • 🇲🇼
    Malawi +265
  • 🇲🇽
    Mexico +52
  • 🇲🇾
    Malaysia +60
  • 🇲🇿
    Mozambique +258
  • 🇳🇦
    Namibia +264
  • 🇳🇨
    New Caledonia +687
  • 🇳🇪
    Niger +227
  • 🇳🇬
    Nigeria +234
  • 🇳🇮
    Nicaragua +505
  • 🇳🇱
    Netherlands +31
  • 🇳🇴
    Norway +47
  • 🇳🇵
    Nepal +977
  • 🇳🇷
    Nauru +674
  • 🇳🇺
    Niue +683
  • 🇳🇿
    New Zealand +64
  • 🇴🇲
    Oman +968
  • 🇵🇦
    Panama +507
  • 🇵🇪
    Peru +51
  • 🇵🇫
    French Polynesia +689
  • 🇵🇬
    Papua New Guinea +675
  • 🇵🇭
    Philippines +63
  • 🇵🇰
    Pakistan +92
  • 🇵🇱
    Poland +48
  • 🇵🇲
    Saint Pierre And Miquelon +508
  • 🇵🇳
    Pitcairn +870
  • 🇵🇹
    Portugal +351
  • 🇵🇼
    Palau +680
  • 🇵🇾
    Paraguay +595
  • 🇶🇦
    Qatar +974
  • 🇷🇴
    Romania +40
  • 🇷🇸
    Serbia +381
  • 🇷🇺
    Russian Federation +7
  • 🇷🇼
    Rwanda +250
  • 🇸🇦
    Saudi Arabia +966
  • 🇸🇧
    Solomon Islands +677
  • 🇸🇨
    Seychelles +248
  • 🇸🇩
    Sudan +249
  • 🇸🇪
    Sweden +46
  • 🇸🇬
    Singapore +65
  • 🇸🇭
    Saint Helena +290
  • 🇸🇮
    Slovenia +386
  • 🇸🇰
    Slovakia +421
  • 🇸🇱
    Sierra Leone +232
  • 🇸🇲
    San Marino +378
  • 🇸🇳
    Senegal +221
  • 🇸🇴
    Somalia +252
  • 🇸🇷
    Suriname +597
  • 🇸🇹
    Sao Tome And Principe +239
  • 🇸🇻
    El Salvador +503
  • 🇸🇾
    Syrian Arab Republic +963
  • 🇸🇿
    Swaziland +268
  • 🇹🇨
    Turks And Caicos Islands +1649
  • 🇹🇩
    Chad +235
  • 🇹🇬
    Togo +228
  • 🇹🇭
    Thailand +66
  • 🇹🇯
    Tajikistan +992
  • 🇹🇰
    Tokelau +690
  • 🇹🇱
    Timor-leste +670
  • 🇹🇲
    Turkmenistan +993
  • 🇹🇳
    Tunisia +216
  • 🇹🇴
    Tonga +676
  • 🇹🇷
    Turkey +90
  • 🇹🇹
    Trinidad And Tobago +1868
  • 🇹🇻
    Tuvalu +688
  • 🇹🇼
    Taiwan, Province Of China +886
  • 🇹🇿
    Tanzania, United Republic Of +255
  • 🇺🇦
    Ukraine +380
  • 🇺🇬
    Uganda +256
  • 🇺🇸
    United States +1
  • 🇺🇾
    Uruguay +598
  • 🇺🇿
    Uzbekistan +998
  • 🇻🇨
    Saint Vincent And The Grenadines +1784
  • 🇻🇪
    Venezuela +58
  • 🇻🇬
    Virgin Islands, British +1284
  • 🇻🇮
    Virgin Islands, U.s. +1340
  • 🇻🇳
    Vietnam +84
  • 🇻🇺
    Vanuatu +678
  • 🇼🇫
    Wallis And Futuna +681
  • 🇼🇸
    Samoa +685
  • 🇾🇪
    Yemen +967
  • 🇾🇹
    Mayotte +262
  • 🇿🇦
    South Africa +27
  • 🇿🇲
    Zambia +260
  • 🇿🇼
    Zimbabwe +263
  • Mr.
  • Mrs.
  • Ms.
  • Miss
  • Prof.
  • Dr.
  • Singaporean
  • Singapore PR
  • Others
🇸🇬
  • 🇦🇩
    Andorra +376
  • 🇦🇪
    United Arab Emirates +971
  • 🇦🇫
    Afghanistan +93
  • 🇦🇬
    Antigua And Barbuda +1268
  • 🇦🇮
    Anguilla +1264
  • 🇦🇱
    Albania +355
  • 🇦🇲
    Armenia +374
  • 🇦🇴
    Angola +244
  • 🇦🇶
    Antarctica +672
  • 🇦🇷
    Argentina +54
  • 🇦🇸
    American Samoa +1684
  • 🇦🇹
    Austria +43
  • 🇦🇺
    Australia +61
  • 🇦🇼
    Aruba +297
  • 🇦🇿
    Azerbaijan +994
  • 🇧🇦
    Bosnia And Herzegovina +387
  • 🇧🇧
    Barbados +1246
  • 🇧🇩
    Bangladesh +880
  • 🇧🇪
    Belgium +32
  • 🇧🇫
    Burkina Faso +226
  • 🇧🇬
    Bulgaria +359
  • 🇧🇭
    Bahrain +973
  • 🇧🇮
    Burundi +257
  • 🇧🇯
    Benin +229
  • 🇧🇱
    Saint Barthelemy +590
  • 🇧🇲
    Bermuda +1441
  • 🇧🇳
    Brunei Darussalam +673
  • 🇧🇴
    Bolivia +591
  • 🇧🇷
    Brazil +55
  • 🇧🇸
    Bahamas +1242
  • 🇧🇹
    Bhutan +975
  • 🇧🇼
    Botswana +267
  • 🇧🇾
    Belarus +375
  • 🇧🇿
    Belize +501
  • 🇨🇦
    Canada +1
  • 🇨🇩
    Congo, The Democratic Republic Of The +243
  • 🇨🇫
    Central African Republic +236
  • 🇨🇬
    Congo +242
  • 🇨🇭
    Switzerland +41
  • 🇨🇰
    Cook Islands +682
  • 🇨🇱
    Chile +56
  • 🇨🇲
    Cameroon +237
  • 🇨🇳
    China +86
  • 🇨🇴
    Colombia +57
  • 🇨🇷
    Costa Rica +506
  • 🇨🇺
    Cuba +53
  • 🇨🇻
    Cape Verde +238
  • 🇨🇾
    Cyprus +357
  • 🇨🇿
    Czech Republic +420
  • 🇩🇪
    Germany +49
  • 🇩🇯
    Djibouti +253
  • 🇩🇰
    Denmark +45
  • 🇩🇲
    Dominica +1767
  • 🇩🇴
    Dominican Republic +1809
  • 🇩🇿
    Algeria +213
  • 🇪🇨
    Ecuador +593
  • 🇪🇪
    Estonia +372
  • 🇪🇬
    Egypt +20
  • 🇪🇷
    Eritrea +291
  • 🇪🇸
    Spain +34
  • 🇪🇹
    Ethiopia +251
  • 🇫🇮
    Finland +358
  • 🇫🇯
    Fiji +679
  • 🇫🇰
    Falkland Islands (malvinas) +500
  • 🇫🇲
    Micronesia, Federated States Of +691
  • 🇫🇴
    Faroe Islands +298
  • 🇫🇷
    France +33
  • 🇬🇦
    Gabon +241
  • 🇬🇧
    United Kingdom +44
  • 🇬🇩
    Grenada +1473
  • 🇬🇪
    Georgia +995
  • 🇬🇭
    Ghana +233
  • 🇬🇮
    Gibraltar +350
  • 🇬🇱
    Greenland +299
  • 🇬🇲
    Gambia +220
  • 🇬🇳
    Guinea +224
  • 🇬🇷
    Greece +30
  • 🇬🇹
    Guatemala +502
  • 🇬🇺
    Guam +1671
  • 🇬🇼
    Guinea-bissau +245
  • 🇬🇾
    Guyana +592
  • 🇭🇰
    Hong Kong +852
  • 🇭🇳
    Honduras +504
  • 🇭🇷
    Croatia +385
  • 🇭🇹
    Haiti +509
  • 🇭🇺
    Hungary +36
  • 🇮🇩
    Indonesia +62
  • 🇮🇪
    Ireland +353
  • 🇮🇱
    Israel +972
  • 🇮🇳
    India +91
  • 🇮🇶
    Iraq +964
  • 🇮🇷
    Iran, Islamic Republic Of +98
  • 🇮🇸
    Iceland +354
  • 🇮🇹
    Italy +39
  • 🇯🇲
    Jamaica +1876
  • 🇯🇴
    Jordan +962
  • Japan +81
  • 🇰🇪
    Kenya +254
  • 🇰🇬
    Kyrgyzstan +996
  • 🇰🇭
    Cambodia +855
  • 🇰🇮
    Kiribati +686
  • 🇰🇲
    Comoros +269
  • 🇰🇳
    Saint Kitts And Nevis +1869
  • 🇰🇵
    Korea Democratic Peoples Republic Of +850
  • 🇰🇷
    Korea Republic Of +82
  • 🇰🇼
    Kuwait +965
  • 🇰🇾
    Cayman Islands +1345
  • 🇱🇦
    Lao Peoples Democratic Republic +856
  • 🇱🇧
    Lebanon +961
  • 🇱🇨
    Saint Lucia +1758
  • 🇱🇮
    Liechtenstein +423
  • 🇱🇰
    Sri Lanka +94
  • 🇱🇷
    Liberia +231
  • 🇱🇸
    Lesotho +266
  • 🇱🇹
    Lithuania +370
  • 🇱🇺
    Luxembourg +352
  • 🇱🇻
    Latvia +371
  • 🇱🇾
    Libyan Arab Jamahiriya +218
  • 🇲🇦
    Morocco +212
  • 🇲🇨
    Monaco +377
  • 🇲🇩
    Moldova, Republic Of +373
  • 🇲🇪
    Montenegro +382
  • 🇲🇬
    Madagascar +261
  • 🇲🇭
    Marshall Islands +692
  • 🇲🇰
    Macedonia, The Former Yugoslav Republic Of +389
  • 🇲🇱
    Mali +223
  • 🇲🇲
    Myanmar +95
  • 🇲🇳
    Mongolia +976
  • 🇲🇴
    Macau +853
  • 🇲🇵
    Northern Mariana Islands +1670
  • 🇲🇺
    Mauritania +222
  • 🇲🇸
    Montserrat +1664
  • 🇲🇹
    Malta +356
  • 🇲🇺
    Mauritius +230
  • 🇲🇻
    Maldives +960
  • 🇲🇼
    Malawi +265
  • 🇲🇽
    Mexico +52
  • 🇲🇾
    Malaysia +60
  • 🇲🇿
    Mozambique +258
  • 🇳🇦
    Namibia +264
  • 🇳🇨
    New Caledonia +687
  • 🇳🇪
    Niger +227
  • 🇳🇬
    Nigeria +234
  • 🇳🇮
    Nicaragua +505
  • 🇳🇱
    Netherlands +31
  • 🇳🇴
    Norway +47
  • 🇳🇵
    Nepal +977
  • 🇳🇷
    Nauru +674
  • 🇳🇺
    Niue +683
  • 🇳🇿
    New Zealand +64
  • 🇴🇲
    Oman +968
  • 🇵🇦
    Panama +507
  • 🇵🇪
    Peru +51
  • 🇵🇫
    French Polynesia +689
  • 🇵🇬
    Papua New Guinea +675
  • 🇵🇭
    Philippines +63
  • 🇵🇰
    Pakistan +92
  • 🇵🇱
    Poland +48
  • 🇵🇲
    Saint Pierre And Miquelon +508
  • 🇵🇳
    Pitcairn +870
  • 🇵🇹
    Portugal +351
  • 🇵🇼
    Palau +680
  • 🇵🇾
    Paraguay +595
  • 🇶🇦
    Qatar +974
  • 🇷🇴
    Romania +40
  • 🇷🇸
    Serbia +381
  • 🇷🇺
    Russian Federation +7
  • 🇷🇼
    Rwanda +250
  • 🇸🇦
    Saudi Arabia +966
  • 🇸🇧
    Solomon Islands +677
  • 🇸🇨
    Seychelles +248
  • 🇸🇩
    Sudan +249
  • 🇸🇪
    Sweden +46
  • 🇸🇬
    Singapore +65
  • 🇸🇭
    Saint Helena +290
  • 🇸🇮
    Slovenia +386
  • 🇸🇰
    Slovakia +421
  • 🇸🇱
    Sierra Leone +232
  • 🇸🇲
    San Marino +378
  • 🇸🇳
    Senegal +221
  • 🇸🇴
    Somalia +252
  • 🇸🇷
    Suriname +597
  • 🇸🇹
    Sao Tome And Principe +239
  • 🇸🇻
    El Salvador +503
  • 🇸🇾
    Syrian Arab Republic +963
  • 🇸🇿
    Swaziland +268
  • 🇹🇨
    Turks And Caicos Islands +1649
  • 🇹🇩
    Chad +235
  • 🇹🇬
    Togo +228
  • 🇹🇭
    Thailand +66
  • 🇹🇯
    Tajikistan +992
  • 🇹🇰
    Tokelau +690
  • 🇹🇱
    Timor-leste +670
  • 🇹🇲
    Turkmenistan +993
  • 🇹🇳
    Tunisia +216
  • 🇹🇴
    Tonga +676
  • 🇹🇷
    Turkey +90
  • 🇹🇹
    Trinidad And Tobago +1868
  • 🇹🇻
    Tuvalu +688
  • 🇹🇼
    Taiwan, Province Of China +886
  • 🇹🇿
    Tanzania, United Republic Of +255
  • 🇺🇦
    Ukraine +380
  • 🇺🇬
    Uganda +256
  • 🇺🇸
    United States +1
  • 🇺🇾
    Uruguay +598
  • 🇺🇿
    Uzbekistan +998
  • 🇻🇨
    Saint Vincent And The Grenadines +1784
  • 🇻🇪
    Venezuela +58
  • 🇻🇬
    Virgin Islands, British +1284
  • 🇻🇮
    Virgin Islands, U.s. +1340
  • 🇻🇳
    Vietnam +84
  • 🇻🇺
    Vanuatu +678
  • 🇼🇫
    Wallis And Futuna +681
  • 🇼🇸
    Samoa +685
  • 🇾🇪
    Yemen +967
  • 🇾🇹
    Mayotte +262
  • 🇿🇦
    South Africa +27
  • 🇿🇲
    Zambia +260
  • 🇿🇼
    Zimbabwe +263
  • Muslim
  • Vegetarian
  • No Preference
  • Mr.
  • Mrs.
  • Ms.
  • Miss
  • Prof.
  • Dr.
  • Singaporean
  • Singapore PR
  • Others
🇸🇬
  • 🇦🇩
    Andorra +376
  • 🇦🇪
    United Arab Emirates +971
  • 🇦🇫
    Afghanistan +93
  • 🇦🇬
    Antigua And Barbuda +1268
  • 🇦🇮
    Anguilla +1264
  • 🇦🇱
    Albania +355
  • 🇦🇲
    Armenia +374
  • 🇦🇴
    Angola +244
  • 🇦🇶
    Antarctica +672
  • 🇦🇷
    Argentina +54
  • 🇦🇸
    American Samoa +1684
  • 🇦🇹
    Austria +43
  • 🇦🇺
    Australia +61
  • 🇦🇼
    Aruba +297
  • 🇦🇿
    Azerbaijan +994
  • 🇧🇦
    Bosnia And Herzegovina +387
  • 🇧🇧
    Barbados +1246
  • 🇧🇩
    Bangladesh +880
  • 🇧🇪
    Belgium +32
  • 🇧🇫
    Burkina Faso +226
  • 🇧🇬
    Bulgaria +359
  • 🇧🇭
    Bahrain +973
  • 🇧🇮
    Burundi +257
  • 🇧🇯
    Benin +229
  • 🇧🇱
    Saint Barthelemy +590
  • 🇧🇲
    Bermuda +1441
  • 🇧🇳
    Brunei Darussalam +673
  • 🇧🇴
    Bolivia +591
  • 🇧🇷
    Brazil +55
  • 🇧🇸
    Bahamas +1242
  • 🇧🇹
    Bhutan +975
  • 🇧🇼
    Botswana +267
  • 🇧🇾
    Belarus +375
  • 🇧🇿
    Belize +501
  • 🇨🇦
    Canada +1
  • 🇨🇩
    Congo, The Democratic Republic Of The +243
  • 🇨🇫
    Central African Republic +236
  • 🇨🇬
    Congo +242
  • 🇨🇭
    Switzerland +41
  • 🇨🇰
    Cook Islands +682
  • 🇨🇱
    Chile +56
  • 🇨🇲
    Cameroon +237
  • 🇨🇳
    China +86
  • 🇨🇴
    Colombia +57
  • 🇨🇷
    Costa Rica +506
  • 🇨🇺
    Cuba +53
  • 🇨🇻
    Cape Verde +238
  • 🇨🇾
    Cyprus +357
  • 🇨🇿
    Czech Republic +420
  • 🇩🇪
    Germany +49
  • 🇩🇯
    Djibouti +253
  • 🇩🇰
    Denmark +45
  • 🇩🇲
    Dominica +1767
  • 🇩🇴
    Dominican Republic +1809
  • 🇩🇿
    Algeria +213
  • 🇪🇨
    Ecuador +593
  • 🇪🇪
    Estonia +372
  • 🇪🇬
    Egypt +20
  • 🇪🇷
    Eritrea +291
  • 🇪🇸
    Spain +34
  • 🇪🇹
    Ethiopia +251
  • 🇫🇮
    Finland +358
  • 🇫🇯
    Fiji +679
  • 🇫🇰
    Falkland Islands (malvinas) +500
  • 🇫🇲
    Micronesia, Federated States Of +691
  • 🇫🇴
    Faroe Islands +298
  • 🇫🇷
    France +33
  • 🇬🇦
    Gabon +241
  • 🇬🇧
    United Kingdom +44
  • 🇬🇩
    Grenada +1473
  • 🇬🇪
    Georgia +995
  • 🇬🇭
    Ghana +233
  • 🇬🇮
    Gibraltar +350
  • 🇬🇱
    Greenland +299
  • 🇬🇲
    Gambia +220
  • 🇬🇳
    Guinea +224
  • 🇬🇷
    Greece +30
  • 🇬🇹
    Guatemala +502
  • 🇬🇺
    Guam +1671
  • 🇬🇼
    Guinea-bissau +245
  • 🇬🇾
    Guyana +592
  • 🇭🇰
    Hong Kong +852
  • 🇭🇳
    Honduras +504
  • 🇭🇷
    Croatia +385
  • 🇭🇹
    Haiti +509
  • 🇭🇺
    Hungary +36
  • 🇮🇩
    Indonesia +62
  • 🇮🇪
    Ireland +353
  • 🇮🇱
    Israel +972
  • 🇮🇳
    India +91
  • 🇮🇶
    Iraq +964
  • 🇮🇷
    Iran, Islamic Republic Of +98
  • 🇮🇸
    Iceland +354
  • 🇮🇹
    Italy +39
  • 🇯🇲
    Jamaica +1876
  • 🇯🇴
    Jordan +962
  • Japan +81
  • 🇰🇪
    Kenya +254
  • 🇰🇬
    Kyrgyzstan +996
  • 🇰🇭
    Cambodia +855
  • 🇰🇮
    Kiribati +686
  • 🇰🇲
    Comoros +269
  • 🇰🇳
    Saint Kitts And Nevis +1869
  • 🇰🇵
    Korea Democratic Peoples Republic Of +850
  • 🇰🇷
    Korea Republic Of +82
  • 🇰🇼
    Kuwait +965
  • 🇰🇾
    Cayman Islands +1345
  • 🇱🇦
    Lao Peoples Democratic Republic +856
  • 🇱🇧
    Lebanon +961
  • 🇱🇨
    Saint Lucia +1758
  • 🇱🇮
    Liechtenstein +423
  • 🇱🇰
    Sri Lanka +94
  • 🇱🇷
    Liberia +231
  • 🇱🇸
    Lesotho +266
  • 🇱🇹
    Lithuania +370
  • 🇱🇺
    Luxembourg +352
  • 🇱🇻
    Latvia +371
  • 🇱🇾
    Libyan Arab Jamahiriya +218
  • 🇲🇦
    Morocco +212
  • 🇲🇨
    Monaco +377
  • 🇲🇩
    Moldova, Republic Of +373
  • 🇲🇪
    Montenegro +382
  • 🇲🇬
    Madagascar +261
  • 🇲🇭
    Marshall Islands +692
  • 🇲🇰
    Macedonia, The Former Yugoslav Republic Of +389
  • 🇲🇱
    Mali +223
  • 🇲🇲
    Myanmar +95
  • 🇲🇳
    Mongolia +976
  • 🇲🇴
    Macau +853
  • 🇲🇵
    Northern Mariana Islands +1670
  • 🇲🇺
    Mauritania +222
  • 🇲🇸
    Montserrat +1664
  • 🇲🇹
    Malta +356
  • 🇲🇺
    Mauritius +230
  • 🇲🇻
    Maldives +960
  • 🇲🇼
    Malawi +265
  • 🇲🇽
    Mexico +52
  • 🇲🇾
    Malaysia +60
  • 🇲🇿
    Mozambique +258
  • 🇳🇦
    Namibia +264
  • 🇳🇨
    New Caledonia +687
  • 🇳🇪
    Niger +227
  • 🇳🇬
    Nigeria +234
  • 🇳🇮
    Nicaragua +505
  • 🇳🇱
    Netherlands +31
  • 🇳🇴
    Norway +47
  • 🇳🇵
    Nepal +977
  • 🇳🇷
    Nauru +674
  • 🇳🇺
    Niue +683
  • 🇳🇿
    New Zealand +64
  • 🇴🇲
    Oman +968
  • 🇵🇦
    Panama +507
  • 🇵🇪
    Peru +51
  • 🇵🇫
    French Polynesia +689
  • 🇵🇬
    Papua New Guinea +675
  • 🇵🇭
    Philippines +63
  • 🇵🇰
    Pakistan +92
  • 🇵🇱
    Poland +48
  • 🇵🇲
    Saint Pierre And Miquelon +508
  • 🇵🇳
    Pitcairn +870
  • 🇵🇹
    Portugal +351
  • 🇵🇼
    Palau +680
  • 🇵🇾
    Paraguay +595
  • 🇶🇦
    Qatar +974
  • 🇷🇴
    Romania +40
  • 🇷🇸
    Serbia +381
  • 🇷🇺
    Russian Federation +7
  • 🇷🇼
    Rwanda +250
  • 🇸🇦
    Saudi Arabia +966
  • 🇸🇧
    Solomon Islands +677
  • 🇸🇨
    Seychelles +248
  • 🇸🇩
    Sudan +249
  • 🇸🇪
    Sweden +46
  • 🇸🇬
    Singapore +65
  • 🇸🇭
    Saint Helena +290
  • 🇸🇮
    Slovenia +386
  • 🇸🇰
    Slovakia +421
  • 🇸🇱
    Sierra Leone +232
  • 🇸🇲
    San Marino +378
  • 🇸🇳
    Senegal +221
  • 🇸🇴
    Somalia +252
  • 🇸🇷
    Suriname +597
  • 🇸🇹
    Sao Tome And Principe +239
  • 🇸🇻
    El Salvador +503
  • 🇸🇾
    Syrian Arab Republic +963
  • 🇸🇿
    Swaziland +268
  • 🇹🇨
    Turks And Caicos Islands +1649
  • 🇹🇩
    Chad +235
  • 🇹🇬
    Togo +228
  • 🇹🇭
    Thailand +66
  • 🇹🇯
    Tajikistan +992
  • 🇹🇰
    Tokelau +690
  • 🇹🇱
    Timor-leste +670
  • 🇹🇲
    Turkmenistan +993
  • 🇹🇳
    Tunisia +216
  • 🇹🇴
    Tonga +676
  • 🇹🇷
    Turkey +90
  • 🇹🇹
    Trinidad And Tobago +1868
  • 🇹🇻
    Tuvalu +688
  • 🇹🇼
    Taiwan, Province Of China +886
  • 🇹🇿
    Tanzania, United Republic Of +255
  • 🇺🇦
    Ukraine +380
  • 🇺🇬
    Uganda +256
  • 🇺🇸
    United States +1
  • 🇺🇾
    Uruguay +598
  • 🇺🇿
    Uzbekistan +998
  • 🇻🇨
    Saint Vincent And The Grenadines +1784
  • 🇻🇪
    Venezuela +58
  • 🇻🇬
    Virgin Islands, British +1284
  • 🇻🇮
    Virgin Islands, U.s. +1340
  • 🇻🇳
    Vietnam +84
  • 🇻🇺
    Vanuatu +678
  • 🇼🇫
    Wallis And Futuna +681
  • 🇼🇸
    Samoa +685
  • 🇾🇪
    Yemen +967
  • 🇾🇹
    Mayotte +262
  • 🇿🇦
    South Africa +27
  • 🇿🇲
    Zambia +260
  • 🇿🇼
    Zimbabwe +263
  • Muslim
  • Vegetarian
  • No Preference
  • ALS Sales Team / Email Updates
  • Search Engines (Bing, Yahoo, Google)
  • Social Media (LinkedIn, Facebook)
  • Referral (Colleagues, Friends, Family)
  • Others

Self Registration Form – Excel Advanced Formulas

  • 18-19 Nov 2019, 9am-5pm
  • 27-28 Apr 2020, 9am-5pm
  • 22-23 Jun 2020, 9am-5pm
  • 31 Aug-1 Sep 2020, 9am-5pm

Part A:     Learner Information

  • Mr.
  • Mrs.
  • Ms.
  • Miss
  • Prof.
  • Dr.
🇸🇬
  • 🇦🇩
    Andorra +376
  • 🇦🇪
    United Arab Emirates +971
  • 🇦🇫
    Afghanistan +93
  • 🇦🇬
    Antigua And Barbuda +1268
  • 🇦🇮
    Anguilla +1264
  • 🇦🇱
    Albania +355
  • 🇦🇲
    Armenia +374
  • 🇦🇴
    Angola +244
  • 🇦🇶
    Antarctica +672
  • 🇦🇷
    Argentina +54
  • 🇦🇸
    American Samoa +1684
  • 🇦🇹
    Austria +43
  • 🇦🇺
    Australia +61
  • 🇦🇼
    Aruba +297
  • 🇦🇿
    Azerbaijan +994
  • 🇧🇦
    Bosnia And Herzegovina +387
  • 🇧🇧
    Barbados +1246
  • 🇧🇩
    Bangladesh +880
  • 🇧🇪
    Belgium +32
  • 🇧🇫
    Burkina Faso +226
  • 🇧🇬
    Bulgaria +359
  • 🇧🇭
    Bahrain +973
  • 🇧🇮
    Burundi +257
  • 🇧🇯
    Benin +229
  • 🇧🇱
    Saint Barthelemy +590
  • 🇧🇲
    Bermuda +1441
  • 🇧🇳
    Brunei Darussalam +673
  • 🇧🇴
    Bolivia +591
  • 🇧🇷
    Brazil +55
  • 🇧🇸
    Bahamas +1242
  • 🇧🇹
    Bhutan +975
  • 🇧🇼
    Botswana +267
  • 🇧🇾
    Belarus +375
  • 🇧🇿
    Belize +501
  • 🇨🇦
    Canada +1
  • 🇨🇩
    Congo, The Democratic Republic Of The +243
  • 🇨🇫
    Central African Republic +236
  • 🇨🇬
    Congo +242
  • 🇨🇭
    Switzerland +41
  • 🇨🇰
    Cook Islands +682
  • 🇨🇱
    Chile +56
  • 🇨🇲
    Cameroon +237
  • 🇨🇳
    China +86
  • 🇨🇴
    Colombia +57
  • 🇨🇷
    Costa Rica +506
  • 🇨🇺
    Cuba +53
  • 🇨🇻
    Cape Verde +238
  • 🇨🇾
    Cyprus +357
  • 🇨🇿
    Czech Republic +420
  • 🇩🇪
    Germany +49
  • 🇩🇯
    Djibouti +253
  • 🇩🇰
    Denmark +45
  • 🇩🇲
    Dominica +1767
  • 🇩🇴
    Dominican Republic +1809
  • 🇩🇿
    Algeria +213
  • 🇪🇨
    Ecuador +593
  • 🇪🇪
    Estonia +372
  • 🇪🇬
    Egypt +20
  • 🇪🇷
    Eritrea +291
  • 🇪🇸
    Spain +34
  • 🇪🇹
    Ethiopia +251
  • 🇫🇮
    Finland +358
  • 🇫🇯
    Fiji +679
  • 🇫🇰
    Falkland Islands (malvinas) +500
  • 🇫🇲
    Micronesia, Federated States Of +691
  • 🇫🇴
    Faroe Islands +298
  • 🇫🇷
    France +33
  • 🇬🇦
    Gabon +241
  • 🇬🇧
    United Kingdom +44
  • 🇬🇩
    Grenada +1473
  • 🇬🇪
    Georgia +995
  • 🇬🇭
    Ghana +233
  • 🇬🇮
    Gibraltar +350
  • 🇬🇱
    Greenland +299
  • 🇬🇲
    Gambia +220
  • 🇬🇳
    Guinea +224
  • 🇬🇷
    Greece +30
  • 🇬🇹
    Guatemala +502
  • 🇬🇺
    Guam +1671
  • 🇬🇼
    Guinea-bissau +245
  • 🇬🇾
    Guyana +592
  • 🇭🇰
    Hong Kong +852
  • 🇭🇳
    Honduras +504
  • 🇭🇷
    Croatia +385
  • 🇭🇹
    Haiti +509
  • 🇭🇺
    Hungary +36
  • 🇮🇩
    Indonesia +62
  • 🇮🇪
    Ireland +353
  • 🇮🇱
    Israel +972
  • 🇮🇳
    India +91
  • 🇮🇶
    Iraq +964
  • 🇮🇷
    Iran, Islamic Republic Of +98
  • 🇮🇸
    Iceland +354
  • 🇮🇹
    Italy +39
  • 🇯🇲
    Jamaica +1876
  • 🇯🇴
    Jordan +962
  • Japan +81
  • 🇰🇪
    Kenya +254
  • 🇰🇬
    Kyrgyzstan +996
  • 🇰🇭
    Cambodia +855
  • 🇰🇮
    Kiribati +686
  • 🇰🇲
    Comoros +269
  • 🇰🇳
    Saint Kitts And Nevis +1869
  • 🇰🇵
    Korea Democratic Peoples Republic Of +850
  • 🇰🇷
    Korea Republic Of +82
  • 🇰🇼
    Kuwait +965
  • 🇰🇾
    Cayman Islands +1345
  • 🇱🇦
    Lao Peoples Democratic Republic +856
  • 🇱🇧
    Lebanon +961
  • 🇱🇨
    Saint Lucia +1758
  • 🇱🇮
    Liechtenstein +423
  • 🇱🇰
    Sri Lanka +94
  • 🇱🇷
    Liberia +231
  • 🇱🇸
    Lesotho +266
  • 🇱🇹
    Lithuania +370
  • 🇱🇺
    Luxembourg +352
  • 🇱🇻
    Latvia +371
  • 🇱🇾
    Libyan Arab Jamahiriya +218
  • 🇲🇦
    Morocco +212
  • 🇲🇨
    Monaco +377
  • 🇲🇩
    Moldova, Republic Of +373
  • 🇲🇪
    Montenegro +382
  • 🇲🇬
    Madagascar +261
  • 🇲🇭
    Marshall Islands +692
  • 🇲🇰
    Macedonia, The Former Yugoslav Republic Of +389
  • 🇲🇱
    Mali +223
  • 🇲🇲
    Myanmar +95
  • 🇲🇳
    Mongolia +976
  • 🇲🇴
    Macau +853
  • 🇲🇵
    Northern Mariana Islands +1670
  • 🇲🇺
    Mauritania +222
  • 🇲🇸
    Montserrat +1664
  • 🇲🇹
    Malta +356
  • 🇲🇺
    Mauritius +230
  • 🇲🇻
    Maldives +960
  • 🇲🇼
    Malawi +265
  • 🇲🇽
    Mexico +52
  • 🇲🇾
    Malaysia +60
  • 🇲🇿
    Mozambique +258
  • 🇳🇦
    Namibia +264
  • 🇳🇨
    New Caledonia +687
  • 🇳🇪
    Niger +227
  • 🇳🇬
    Nigeria +234
  • 🇳🇮
    Nicaragua +505
  • 🇳🇱
    Netherlands +31
  • 🇳🇴
    Norway +47
  • 🇳🇵
    Nepal +977
  • 🇳🇷
    Nauru +674
  • 🇳🇺
    Niue +683
  • 🇳🇿
    New Zealand +64
  • 🇴🇲
    Oman +968
  • 🇵🇦
    Panama +507
  • 🇵🇪
    Peru +51
  • 🇵🇫
    French Polynesia +689
  • 🇵🇬
    Papua New Guinea +675
  • 🇵🇭
    Philippines +63
  • 🇵🇰
    Pakistan +92
  • 🇵🇱
    Poland +48
  • 🇵🇲
    Saint Pierre And Miquelon +508
  • 🇵🇳
    Pitcairn +870
  • 🇵🇹
    Portugal +351
  • 🇵🇼
    Palau +680
  • 🇵🇾
    Paraguay +595
  • 🇶🇦
    Qatar +974
  • 🇷🇴
    Romania +40
  • 🇷🇸
    Serbia +381
  • 🇷🇺
    Russian Federation +7
  • 🇷🇼
    Rwanda +250
  • 🇸🇦
    Saudi Arabia +966
  • 🇸🇧
    Solomon Islands +677
  • 🇸🇨
    Seychelles +248
  • 🇸🇩
    Sudan +249
  • 🇸🇪
    Sweden +46
  • 🇸🇬
    Singapore +65
  • 🇸🇭
    Saint Helena +290
  • 🇸🇮
    Slovenia +386
  • 🇸🇰
    Slovakia +421
  • 🇸🇱
    Sierra Leone +232
  • 🇸🇲
    San Marino +378
  • 🇸🇳
    Senegal +221
  • 🇸🇴
    Somalia +252
  • 🇸🇷
    Suriname +597
  • 🇸🇹
    Sao Tome And Principe +239
  • 🇸🇻
    El Salvador +503
  • 🇸🇾
    Syrian Arab Republic +963
  • 🇸🇿
    Swaziland +268
  • 🇹🇨
    Turks And Caicos Islands +1649
  • 🇹🇩
    Chad +235
  • 🇹🇬
    Togo +228
  • 🇹🇭
    Thailand +66
  • 🇹🇯
    Tajikistan +992
  • 🇹🇰
    Tokelau +690
  • 🇹🇱
    Timor-leste +670
  • 🇹🇲
    Turkmenistan +993
  • 🇹🇳
    Tunisia +216
  • 🇹🇴
    Tonga +676
  • 🇹🇷
    Turkey +90
  • 🇹🇹
    Trinidad And Tobago +1868
  • 🇹🇻
    Tuvalu +688
  • 🇹🇼
    Taiwan, Province Of China +886
  • 🇹🇿
    Tanzania, United Republic Of +255
  • 🇺🇦
    Ukraine +380
  • 🇺🇬
    Uganda +256
  • 🇺🇸
    United States +1
  • 🇺🇾
    Uruguay +598
  • 🇺🇿
    Uzbekistan +998
  • 🇻🇨
    Saint Vincent And The Grenadines +1784
  • 🇻🇪
    Venezuela +58
  • 🇻🇬
    Virgin Islands, British +1284
  • 🇻🇮
    Virgin Islands, U.s. +1340
  • 🇻🇳
    Vietnam +84
  • 🇻🇺
    Vanuatu +678
  • 🇼🇫
    Wallis And Futuna +681
  • 🇼🇸
    Samoa +685
  • 🇾🇪
    Yemen +967
  • 🇾🇹
    Mayotte +262
  • 🇿🇦
    South Africa +27
  • 🇿🇲
    Zambia +260
  • 🇿🇼
    Zimbabwe +263
  • Singaporean
  • Singapore PR
  • Others
  • Muslim
  • Vegetarian
  • No Preference
  • ALS Sales Team / Email Updates
  • Search Engines (Bing, Yahoo, Google)
  • Social Media (LinkedIn, Facebook)
  • Referral (Colleagues, Friends, Family)
  • Others

Course Information

Course Code:

ALSIT-EFF

Course Fee:

S$706.00 (Nett)

Inclusive of 2 coffee breaks with refreshments and catered / buffet lunch

Call us for a group rebate when you register in a group of 6 or more

Absentees will be charged the full course fee

Course Dates:

  • 18 - 19 Nov 2019
  • 27 - 28 Apr 2020
  • 22 - 23 Jun 2020
  • 31 Aug - 1 Sep 2020

2 days, 9:00am – 5:00pm
(14 hrs, exclude lunch break)

If you have a group of 6 or more preparing for the same course, you can opt for your own “closed” class. Closed classes are perfect for corporate team training where group learning can make a difference. 

Please note that closed class is not customised class.

Registration:

For Company-Sponsored Learners: Click here to download registration form

For Self-Sponsored Learners:
Click here to download registration form

You can also register online here

For Government Ministries / Agencies on HRMS / ACE, you are unable to see our courses on the list. Please inform your Training Coordinator the Course Code, Course Title, Course Date and the Training Provider is Advanced Learning Singapore to upload into the system for registration

Course Venue:

Details of hotel will be confirmed nearer the course start date

Others:

Complimentary car park coupon upon request (subject to availability and confirmed on a first come, first served basis)

Note:

ALS reserves the right to reschedule, postpone or cancel any course, change the trainer and venue at short notice and at its absolute discretion, due to insufficient enrolment, class size, availability and circumstances outside our control

More Courses By Alaster