Course curriculum

Use coupon code code EXCELPRO2024 to get 80% Off

    1. Welcome

      FREE PREVIEW
    2. Download the class files here

    1. Converting texts to different cases with UPPER, LOWER and PROPER

      FREE PREVIEW
    2. Using LEFT and RIGHT to extract characters from start and end of text strings

      FREE PREVIEW
    3. Using MID to extract middle characters and TRIM to remove extra spaces

      FREE PREVIEW
    4. Combining texts with CONCATENATE, CONCAT and TEXTJOIN

    5. Converting between numbers and characters with UNICODE and UNICHAR

    6. Using LEN, FIND and SEARCH functions

    7. Practice Assignment 2

    1. Introduction to Date Functions

    2. Extracting Day, Month and Year from Date with DAY, MONTH and YEAR

    3. Extracting day of week and week of year with WEEKDAY and WEEKNUM

    4. Using TEXT function to write Date into a text format

    5. Using DATEVALUE to convert text based date to date based

    6. Using EOMONTH to get end of month date

    7. Moving date by periods with EDATE

    8. Getting the number of working dates between 2 dates with NETWORKDAYS and NETWORKDAYS.INTL

    9. Intro to DATEDIF

    10. Calculating Age in different units with DATEDIF

    11. Practice Assignment 3

    1. Intro to combining functions

    2. Combining Functions Example 1

    3. Combining Functions Example 2

    4. Combining Functions Example 3a

    5. Combining Functions Example 3b

About this course

  • $70.00
  • 65 lessons
  • 4.5 hours of video content
  • Use coupon code code EXCELPRO2024 to get 80% Off

Complete your purchase with Paystack for Naira Cards or Stripe for International Cards

Reviews

5 star rating

Great course!!!

Cherif BISSIRIOU

Complex Excel Functions explain in easy way to understand. Thanks for this excellent course.

Complex Excel Functions explain in easy way to understand. Thanks for this excellent course.

Read Less
5 star rating

Good learning experience

Omotayo Ajenifuja

Now I have a good idea of using formulas on excel.

Now I have a good idea of using formulas on excel.

Read Less
5 star rating

Great Course

Olayinka Akingbade

Excellent instructor. Dedicates time to thoroughly explain the details of all functions.

Excellent instructor. Dedicates time to thoroughly explain the details of all functions.

Read Less
5 star rating

Advanced excel functions

Emuobonuvie Akpeghagha

Very detailed

Very detailed

Read Less