Lesson 5 – What is the MINIMUM & MAXIMUM function, and how to insert them in Excel?

In this lesson, I’m going to be showing you how to:

  • Understand, what a MINIMUM function is
  • Insert a MINIMUM function
  • Understand, what a MAXIMUM function is
  • Insert a MAXIMUM function

Go ahead, open the video below and watch the tutorial at your own pace:

If I have not covered anything in this lesson, please leave a comment or your question below and I will get back to you. (you may have to scroll down past other lovely peoples comments)

Enjoyed this tutorial? Then please don’t forget to Like & Share with your family and friends on all the social media platforms, such as Facebook, WhatsApp and Instagram 🙂

Watch this tutorial directly on our YouTube channel and Subscribe

Thanks for watching!

Do you want to learn to create your own website?

If you want to LEARN to create your own website like ours, then CLICK HERE to join a learning platform for FREE and learn at your own pace with video tutorials. Once you’ve joined, we will see you on the other side to help you out too.

CLICK HERE to read our review about this amazing learning platform, if you want to know more.

When you’re ready move onto:

Lesson 6 – What is the COUNT & COUNTA function, and how to insert them in Excel?

Or go back to:

Lesson 4 – What is an AVERAGE function, and how to insert it in Excel?

Lesson 3 – Simple Subtraction Formula using Excel

Lesson 2 – Creating SUM Functions and Replicating Formulas in Excel

Lesson 1 Simple multiplication Formula using Excel

Hope you are enjoying your learning 🙂

Habib Ali – ICT Tutor

33 thoughts on “Lesson 5 – What is the MINIMUM & MAXIMUM function, and how to insert them in Excel?”

  1. Hi Habib,

    Thank you ever so much, not only for this video, but your entire series thus far.

    I’m not sure why excel has always been a bit of a struggle for me, as your explanations make perfect sense, and to be honest there isn’t anything particularly complicated in the various formulas you provide.

    Having to work constantly with producing excel spreadsheets and the like, it’s actually a pleasure to find all the information required in one place, and without any use of jargon or complicating matters.

    Thanks once again and keep up the great work.
    Partha

    Reply
    • Hi Partha,

      Thank you for your extensive feedback. I’m humbled to know how useful these tutorials been for you. I tried my best to keep it as simple and user friendly as possible. So, even for someone who is new to spreadsheets can learn from it.

      Please keep visiting our site more more useful contents like these at: https://lifestyletipsandhacks.com/

      Best Wishes
      Habib

      Reply
  2. Im realy enjoying these tutorials. I like it how you put the real world into your explanations. It makes us see reality and picture how excel is used in the outside world.

    Reply
  3. Another very practical video. They are simple functions but very much used. It makes so much easier. Excel is a fantastic tool. I’m exploring each day more and more. I’m using the function SUMIF and COUNT a lot this days. It helps me to keep my spreadsheet updated without effort. Thank you for all the tips and all the best.

    Reply
    • Happy to hear you’re exploring excel, it will most definitely make your life a lot easier and efficient because most of the tasks, excel will do for you and update automatically when you make any changes to your data.

      I will be creating a video tutorial in the future for the SUMIF function, so come back and check or subscribe to my YouTube channel and you will be alerted automatically: https://www.youtube.com/channel/UCBfGJLMmTIA3ESh9DFYWLIg

      Reply
  4. Thank you for the lessons on functions. They can be quite challenging but you have explained how to do them really well in your videos.

    Reply
    • You are welcome. Yes functions can be challenging – but like you said if they are well explained and demonstrated, then they are actually very easy to understand and apply in Excel. All the best

      Habib (ICT Tutor)

      Reply
  5. Hi, many thanks for useful information. You have explained it logically for me so I am gonna have a look on your other lessons as well.

    Reply
  6. Hey Habib,

    I believe this post will definitely help many people. In one of my earlier jobs, I had to struggle with excel a lot and I learned everything by either reading blogs or watching videos.
    Sometimes, it takes a lot of time to find the correct resource to learn even a simple task like this in the correct way. Especially for non IT guys and those who do not have any related background, these could be more important than many of us think.

    Thank you for taking time to explain clearly.

    Reply
    • Hey Rajith, a lot of people struggle with Excel, but never find the right site or the right help, this is why I have and continuing to create these video tutorials, so that people who visit my site will keep returning to take advantage of my knowledge and skills of the Microsoft Office applications.

      My videos are simple, with good explanations of the functions before I demonstrate how to implement each skill. Knowledge is the key. Thank you

      Habib (ICT Tutor)

      Reply
  7. I have used Excel for a while.
    By the way, I became hesitant to say that I know Excel as I learned more functions of it. There are so many Excel functions I am not familiar with.
    Some people say that the world will be different once someone gets familiar with Excel. It is such a powerful tool and highly useful for many professionals and average users.
    You seem to be an expert in Excel, and teaching many useful Excel functions will benefit many online users.
    Thank you for providing an easy-to-follow tutorial, and I look forward to learning more useful functions from you.
    Thank you.

    Reply
    • Thank you Jason for your detailed comment. Yes you are right, Microsoft Excel is very logical and I am a logical person I guess. lol.

      I highly recommend it to everyone regardless of their profession and role. You will always take away something from my tutorials.

      Many Thanks
      Habib

      Reply
  8. Hi there,

    Thank you so much for the tutorial in utilizing fx insert, minimum and maximum function using Microsoft Excel. This is one of the skills that I am lacking on. The other day LinkedIn asked me to update my skills info, I was hesitating about putting down Microsoft Excel. So, thank you for this tutorial. I will definitely check out your previous lessons as well. Once I have mastered Excel, I’ll update my skill info on LinkedIn.

    Reply
  9. Thank you for this information, I’m going to need to start learning how to use Excel now and this is a great starting tool. Thank you again.

    Reply
  10. Exactly what I was looking for. I need to go back to the previous lessons to put it all in order. I enjoy working with Excel and the more I can learn, the more proficient I can become. Thank you for doing this is video form so I could see the live action.

    Reply
    • You’re welcome Greg. Video tutorials are the best. I started doing these tutorials with my students in mind during this Covid lockdown, but it seems everyone is benefiting – so for that, I am more than happy to do more video tutorials.

      Reply
  11. Hi Habib,

    Thanks a lot for providing this excel lesson regarding minimum & maximum. I learned excel in university, but that was 10 years ago, and now I need to be using it in my job. I really needed a refresher, so your lessons have really been helpful, and they are really clear and easy to understand!

    Reply
    • Hi Fernanda, glad to hear the lesson was clear and easy to understand – I get this a lot from my students. We always need a refresher, especially if it is 10 years ago. I hope your job will be easier now after going through my lesson. Take care

      Reply
    • You’re welcome and thank you Christy. Functions can be very challenging if not understood correctly. My aim is to simplify the learning for everyone.

      Reply

Leave a comment

Share via
Copy link
Powered by Social Snap