FLOURISH ICT ACADEMY
FLOURISH ICT ACADEMY
  • Видео 32
  • Просмотров 42 934
10 EXCEL FORMULAS EVERY DATA ANALYST SHOULD KNOW
In this training video, I covered 10 Excel formulas to boost your Excel and Data Analytics skills. Watch to the end because, by the end of this training video, you’ll understand some important formulas in Excel that will help you in your journey to data analytics. This is one of my give away computer training for beginners.
Timecode:
0:00 Introducing the dataset
10:50 LEN, MIN/MAX FUNCTION
14:38 SUMIF FUNCTION
22:06 DAYS/NETWORKDAYS FUNCTION
27:43 REPLACE/SUBSTITUTE FUNCTION
34:36 MINIFS/MAXIFS FUNCTION
42:32 TRIM FUNCTION
47:06 COUNTIFS FUNCTION
50:55 LEFT/RIGHT FUNCTION
53:32 VLOOKUP FUNCTION
MS Excel Training for Beginners:
ruclips.net/p/PLlbNVRepzl0xENEUiVE5uX1lQurhvP8Ky
Data Analytics Training fo...
Просмотров: 157

Видео

DATA ANALYTICS TRAINING FOR BEGINNERS | LESSON 1
Просмотров 33921 день назад
Data analysts are in high demand across various sectors because of the volume of data that needs to be analyzed. If you want to begin your journey into this highly demanding career, this video is for you. Timecode: 0:00 - Intro 03:13 - Data 03:27 - Evolution of data analyst 6:104 - Data Analysis vs Data Analytics vs Data Science 7:37 - The burst of data 10:25 - Characteristics of big data 18:00...
HOW TO PRINT IN EXCEL
Просмотров 144Месяц назад
I explained all the technicalities of printing in MS Excel. Excel Training for Beginners: ruclips.net/video/EI_OMoRj-Xc/видео.html For personal/ corporate training requirements, visit: training.flocomputers.com/
HOW TO SPLIT TEXT TO COLUMNS | EXCEL TRAINING FOR BEGINNERS
Просмотров 204Месяц назад
This lesson will teach you how to split text in a column such as full name into two columns, first name and last name. JOINING AND MANIPULATING TEXT IN EXCEL USING TEXT FUNCTION: ruclips.net/video/nH7NlqOVYtg/видео.html For personal/ corporate training requirements, visit: training.flocomputers.com/
HOW TO PREPARE QUOTATION OR INVOICE IN EXCEL | FOR BEGINNERS | 3
Просмотров 147Месяц назад
You can effortlessly prepare a quotation or invoice in MS Excel. This video will teach you how to go about it with practical examples. EXCEL LESSON 1: ruclips.net/video/KZ5nPsjSNps/видео.html Visit Flourish ICT Academy to learn more about our training courses: training.flocomputers.com/ #exceltutorial #excelformulas #microsoftoffice #beginners #computertraining #computertraininginstitute
MICROSOFT WORD TRAINING FOR BEGINNERS | LESSON 8
Просмотров 170Месяц назад
This is a practical training on how to insert watermark which is also known as ghost text in Microsoft Word for beginners. Although, the focus is for beginner but there is a take home for everyone. Even the experienced user will learn something in this video as there is no end to learning. Remember to subscribe. Watch more lessons on Microsoft Word Training for Beginners: ruclips.net/video/VItJ...
JOINING AND MANIPULATING TEXT IN EXCEL USING TEXT FUNCTION | FOR BEGINNERS | 2
Просмотров 130Месяц назад
One of the important functions in Excel is the Text Function. In this video, I explained all you need to know as a beginner about text function with practical examples. #computertraining #exceltutorial #microsoftoffice #computerknowledge #computertraininginstitute Microsoft Excel Training for Beginners (Previous Lessons): ruclips.net/p/PLlbNVRepzl0xENEUiVE5uX1lQurhvP8Ky&si=oRCmyV0TsA28ZfuU
FORMULAS AND FUNCTIONS IN EXCEL | FOR BEGINNERS | 1
Просмотров 2262 месяца назад
This lesson, formulas and functions in Microsoft Excel for beginners, is a continuation of our computer training for beginners. Watch the first Excel lesson which is a foundational to this: ruclips.net/video/EI_OMoRj-Xc/видео.html Timecode: 0:00 - Intro to Formulas & Functions 3:53- Definition and Layout recap 5:47 - Entering and Editing Formulas in Excel 17:04 - How to Insert Function in Excel...
POWERPOINT TRAINING FOR BEGINNERS WITH PRACTICAL EXAMPLES
Просмотров 4292 месяца назад
This is a practical training on Microsoft PowerPoint for beginners. Although, the focus is for beginner but there is a take home for everyone here. Even the experienced user will learn something in this video as there is no end to learning. Remember to subscribe. How to Insert and Edit Table in MS Word: ruclips.net/video/1TxdGg8mbMA/видео.html Timecode: 0:00 - Intro 2:25 - Getting Started with ...
FUNCTIONS OF THE COMPUTER KEYBOARD KEYS: THE KEYS YOU'VE BEEN IGNORING BUT CAN MAKE YOU WORK FASTER
Просмотров 7472 месяца назад
The keyboard is an input device. Knowing how to use all the keys and when to use them will make you a better computer user. I did a survey recently and observed that there are many keys on the keyboard that people are wrongly or not using at all. Watch this video to become a better computer user. Remember to subscribe: / @flourishcomputers Timecodes 0:00 - Intro 03:20 - Keyboard Layout (laptop ...
MICROSOFT WORD TRAINING FOR BEGINNERS | LESSON 7
Просмотров 3292 месяца назад
MICROSOFT WORD TRAINING FOR BEGINNERS | LESSON 7
HOW TO USE FIND AND REPLACE TOOL IN MICROSOFT WORD | LESSON 9
Просмотров 1792 месяца назад
HOW TO USE FIND AND REPLACE TOOL IN MICROSOFT WORD | LESSON 9
MICROSOFT WORD TRAINING FOR BEGINNERS | LESSON 6
Просмотров 4722 месяца назад
MICROSOFT WORD TRAINING FOR BEGINNERS | LESSON 6
MICROSOFT WORD TRAINING FOR BEGINNERS | LESSON 5
Просмотров 4733 месяца назад
MICROSOFT WORD TRAINING FOR BEGINNERS | LESSON 5
MICROSOFT WORD TRAINING FOR BEGINNERS | LESSON 4
Просмотров 3883 месяца назад
MICROSOFT WORD TRAINING FOR BEGINNERS | LESSON 4
MICROSOFT WORD TRAINING FOR BEGINNERS | LESSON 3
Просмотров 1,2 тыс.3 месяца назад
MICROSOFT WORD TRAINING FOR BEGINNERS | LESSON 3
MICROSFT WORD TRAINING FOR BEGINNERS | LESSON 2
Просмотров 8713 месяца назад
MICROSFT WORD TRAINING FOR BEGINNERS | LESSON 2
BEST APPROACH TO ORGANIZE YOUR COMPUTER FILES
Просмотров 2953 месяца назад
BEST APPROACH TO ORGANIZE YOUR COMPUTER FILES
MICROSOFT WORD TRAINING FOR BEGINNERS | LESSON 1
Просмотров 3 тыс.3 месяца назад
MICROSOFT WORD TRAINING FOR BEGINNERS | LESSON 1
WATCH THIS BEFORE YOU BUY A COMPUTER
Просмотров 4573 месяца назад
WATCH THIS BEFORE YOU BUY A COMPUTER
COMPUTER TRAINING FOR BEGINNERS || LESSON 2 COMPUTER PORTS
Просмотров 6 тыс.5 месяцев назад
COMPUTER TRAINING FOR BEGINNERS || LESSON 2 COMPUTER PORTS
COMPUTER TRAINING FOR BEGINNERS || LESSON 1
Просмотров 26 тыс.5 месяцев назад
COMPUTER TRAINING FOR BEGINNERS || LESSON 1
Microsoft Excel Lesson 6
Просмотров 744 года назад
Microsoft Excel Lesson 6
Microsoft Excel Lesson 5
Просмотров 704 года назад
Microsoft Excel Lesson 5
Microsoft Excel Lesson 3
Просмотров 834 года назад
Microsoft Excel Lesson 3
Microsoft Excel Lesson 4
Просмотров 774 года назад
Microsoft Excel Lesson 4
Microsoft Excel Lesson 2
Просмотров 924 года назад
Microsoft Excel Lesson 2
Microsoft Excel Lesson 1
Просмотров 1254 года назад
Microsoft Excel Lesson 1

Комментарии

  • @ManikMehrotra-ed6tb
    @ManikMehrotra-ed6tb 9 часов назад

    Hhht7ur👨‍💻👩‍💻

  • @AminaEtsu
    @AminaEtsu 2 дня назад

    Thank you sir

  • @AdjarhoFavour-m4k
    @AdjarhoFavour-m4k 4 дня назад

    I will like to learn ICT and Computer Training for Employees and Job Seekers

  • @MariaNMupolo
    @MariaNMupolo 5 дней назад

    I would like to learn more with you sir❤

  • @puritypaul-yx3tc
    @puritypaul-yx3tc 5 дней назад

    Thank you sir

  • @blessingkelechi9182
    @blessingkelechi9182 10 дней назад

    Am interested I would really love to learn how to operate the computer

  • @AhmadYusif-j8g
    @AhmadYusif-j8g 11 дней назад

    Hi this is Ahmed, I'm under Flourish ICT training. Your explanation is very interested and I'm interested on it thank you.

  • @AlexanderAjangAtak
    @AlexanderAjangAtak 12 дней назад

    Am very interested ❤❤

  • @MahezPhone-fe4hc
    @MahezPhone-fe4hc 13 дней назад

    I'm very interesting ❤❤👍

  • @DengGattuak
    @DengGattuak 14 дней назад

    Am very interesting

  • @isaacpauline5288
    @isaacpauline5288 14 дней назад

    I am interested please

  • @ManshakDason
    @ManshakDason 16 дней назад

    Yes, I am interested to start a class

  • @NkuMary-sp5ny
    @NkuMary-sp5ny 17 дней назад

    Pls how do I create a new folder

    • @flourishictacademy
      @flourishictacademy 17 дней назад

      watch the training I did on the best approach to organize your document. Here is the link; ruclips.net/video/T5mm1trLw7Y/видео.html

  • @shaydiemassaquoi
    @shaydiemassaquoi 18 дней назад

    I’m new here ❤from Sierra Leone west Africa please help me be one of you!

  • @user-du3cl4dh3e
    @user-du3cl4dh3e 18 дней назад

    I am learning so much sir

  • @MalaminDrammeh-z5r
    @MalaminDrammeh-z5r 19 дней назад

    Am interested

    • @flourishictacademy
      @flourishictacademy 18 дней назад

      @@MalaminDrammeh-z5r ruclips.net/p/PLlbNVRepzl0wPlEzGPTMQZSYrY_baABmN&si=-eeVytEciFzxAMRo

  • @Andrewpaul-c4r
    @Andrewpaul-c4r 20 дней назад

    Ict and computer training for beginners (ictb)

  • @kayanjajohnbosco9132
    @kayanjajohnbosco9132 20 дней назад

    I am new here help me be part of u

  • @SifunisoSilishebo
    @SifunisoSilishebo 22 дня назад

    Keep up the good work I myself personally I appreciate

  • @OGSUCCESS319
    @OGSUCCESS319 22 дня назад

    Make a video on ict and computer training for beginners (ictb)

    • @flourishictacademy
      @flourishictacademy 18 дней назад

      @@OGSUCCESS319 i have. check this ruclips.net/p/PLlbNVRepzl0wPlEzGPTMQZSYrY_baABmN&si=-eeVytEciFzxAMRo

    • @flourishictacademy
      @flourishictacademy 18 дней назад

      @@OGSUCCESS319 here is it ruclips.net/p/PLlbNVRepzl0wPlEzGPTMQZSYrY_baABmN&si=-eeVytEciFzxAMRo

  • @kigozidan4900
    @kigozidan4900 23 дня назад

    Thanks for teaching us one love from Uganda

  • @FrancisSagoe-g1v
    @FrancisSagoe-g1v 23 дня назад

    Francis as usual…That’s a very interesting lesson..may God richly bless you with more knowledge for this Good Samaritan job you are doing it for us. By the way, l would like you to do a video about cyber security. Thanks 🙏

    • @flourishictacademy
      @flourishictacademy 23 дня назад

      @@FrancisSagoe-g1v Thank you. Sure, very soon training on cybersecurity will be released. I have been busy with the online students.

    • @FrancisSagoe-g1v
      @FrancisSagoe-g1v 23 дня назад

      @@flourishictacademy oh ok

  • @FrancisSagoe-g1v
    @FrancisSagoe-g1v 23 дня назад

    Francis as usual…That’s a very interesting lesson..may God richly bless you with more knowledge for this Good Samaritan job you are doing it for us. By the way, l would like you to do a video about cyber security. Thanks 🙏

  • @HERRO_BANKERS
    @HERRO_BANKERS 25 дней назад

    I'm new here 🎉please help me to be one of you.

  • @IbrahimBangura-g9s
    @IbrahimBangura-g9s 26 дней назад

    From this stage where are we going to

    • @flourishictacademy
      @flourishictacademy 25 дней назад

      The lessons are in order. Go to lesson 2, when you are done with lesson 2, watch the lesson on the keyboard then start MS Word lessons, PowerPoint followed by MS Excel.

  • @user-ql7qd9br9u
    @user-ql7qd9br9u 27 дней назад

    Flourish you are the best

  • @ChideraIkewete
    @ChideraIkewete Месяц назад

    Sir my own does not have the ruler

    • @flourishictacademy
      @flourishictacademy Месяц назад

      @@ChideraIkewete It does but you need to enable it. Go to the VIEW on the MENU bar. VIEW is in the same role with FILE and it is after REVIEW. When you click on the view, you will see ruler checkbox in the show group before Zoom. Click on the checkbox before the ruler and you will see the ruler. Let me know if you are able to find it

    • @ChideraIkewete
      @ChideraIkewete Месяц назад

      Thanks I have seen it😊

  • @kingstech7
    @kingstech7 Месяц назад

    Which software do you use for your videos

  • @kingstech7
    @kingstech7 Месяц назад

    Very Educative

  • @AlphaSesay-nb8hd
    @AlphaSesay-nb8hd Месяц назад

    Good evening sir I am new I am interested in learning computer Computer training for beginner

    • @flourishictacademy
      @flourishictacademy Месяц назад

      chat me up on WhatsApp +2348030583525 or visit training.flocomputers.com/ to fill the registration form.

  • @abigealakinlolu1541
    @abigealakinlolu1541 Месяц назад

    Please in adjusting the margin I don't know where to press to adjust, I already placed the arrow where you said to place it but I don't know where to press to adjust it

    • @flourishictacademy
      @flourishictacademy Месяц назад

      Place the arrow where I said then hold the left click down on your mouse while you drag the line up or down depending on whether you want to reduce or increase the margin. Ensure you hold the left click down on your mouse while moving it.

  • @VivianKalamu
    @VivianKalamu Месяц назад

    I want to print a risi how can I do

    • @flourishictacademy
      @flourishictacademy Месяц назад

      You want to print what? If you are on WhatsApp, send me a message there too +2348030583525.

  • @gregpledge2769
    @gregpledge2769 Месяц назад

    Excellent lesson on setting up the margins thank you

  • @NkisuMuleya
    @NkisuMuleya Месяц назад

    Thank you

  • @xavierdes1
    @xavierdes1 Месяц назад

    Good information and interesting to study about your experiences knowledge 🥰🏡✅⭐️🌎👍💭🌟🌟🌟✅💭

  • @VanesaMatuti-ct8mo
    @VanesaMatuti-ct8mo Месяц назад

    I like your exlaplanations

  • @mosesnado5795
    @mosesnado5795 Месяц назад

    Thank you sir for sharing this I am still learning the basics of excel

  • @otiengchristianopeter-fj2hd
    @otiengchristianopeter-fj2hd 2 месяца назад

    How can I work on it using my phone as well

  • @otiengchristianopeter-fj2hd
    @otiengchristianopeter-fj2hd 2 месяца назад

    I didn't understand in font sir I join late

    • @flourishictacademy
      @flourishictacademy 2 месяца назад

      What exactly is it that you don't understand? You can watch the video again.

  • @otiengchristianopeter-fj2hd
    @otiengchristianopeter-fj2hd 2 месяца назад

    Very interesting

  • @NgoieAlineMulenda
    @NgoieAlineMulenda 2 месяца назад

    Morning sir your voice is lower please can you raise your voice

  • @otiengchristianopeter-fj2hd
    @otiengchristianopeter-fj2hd 2 месяца назад

    👍 is the best way for us

  • @otiengchristianopeter-fj2hd
    @otiengchristianopeter-fj2hd 2 месяца назад

    VERY GOOD

  • @ttuddekunnono8623
    @ttuddekunnono8623 2 месяца назад

    Thanks for your teachings brother but we also need to see the keyboard how you press those buttons for easier leaning

    • @flourishictacademy
      @flourishictacademy 2 месяца назад

      Thank you for that observation but I didn't press any special key during the training. Every key I used are the usual numbers and alphabets.

  • @PATRICIAARIANNA
    @PATRICIAARIANNA 2 месяца назад

    Thnx