Lesson 30: Best method to format numbers to display as PERCENTAGES in Excel

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

  1. Format numbers to display as percentages in Excel

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

If I have not covered everything 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 31: Relative OR Absolute references in Excel | Everything explained | Confusion solved!

Or go back to:

Lesson 29: Everything you need to know about ABSOLUTE cell references before replicating a formula in Excel

Lesson 28: A simple DIVISION formula in Excel | How to DIVIDE in Excel

Lesson 27: What is the thousand separator in Excel | How to use the thousand separator in Excel

Lesson 26: Use the AUTOSUM button to quickly ADD up cells in Excel | What is the Autosum Button in Excel?

Lesson 25: Everything you need to know about FREEZING PANES (rows & columns) in Excel | What is Freeze panes?

Lesson 24: How to SORT data in ASCENDING order in Excel

Lesson 23: Best techniques to widen columns & adjust the height of rows in Excel

Lesson 22: How to RENAME a worksheet in Excel

Lesson 21: How to COPY cells from one spreadsheet to another spreadsheet in Excel

Lesson 20: How to select multiple NON-ADJACENT cells in Excel | What are the benefits?

Lesson 19: What is a Workbook and Worksheet in Excel | What is the difference between a workbook and worksheet in Excel?

Lesson 18: What is a Formula and Function in Excel | What is the difference between a formula and function in Excel?

Lesson 17: How to PRINT the spreadsheet SHOWING the formulas and functions in Excel

Lesson 16: What is Page Orientation in Excel | Change Portrait orientation to Landscape in Excel

Lesson 15: Format the Font colour in Excel | Shade a range of cells to any colour in Excel

Lesson 14: How to insert a HEADER in Excel? | How to insert an AUTOMATIC FILENAME in the header?

Lesson 13: How to Format cells as Currency, Date, Percentages and apply Decimal Places to numbers in Excel

Lesson 12: Wrap Text in Excel | Break Text to Multiple Lines | Shrink to Fit

Lesson 11: Merge & Center in Excel | Merge Across | Merge Cells

Lesson 10: How to use the INSERT FUNCTION command in Excel

Lesson 9: Simple Subtraction Formula in Excel

Lesson 8: Using the COUNT and COUNTIF function to count ONLY the cells, which contains TEXTUAL data

Lesson 7: Count & CountA function in Excel | Difference between Count and CountA function in Excel

Lesson 6: MIN & MAX function in Excel | Find the Minimum and Maximum value within a range in Excel

Lesson 5: Average Function in Excel | What does Average mean

Lesson 4: Multiplication Formula in Excel | Replicate or Copy Formulas in Excel

Lesson 3: Formatting Cells in Excel | Make a Spreadsheet look visually attractive

Lesson 2: SUM function in Excel | Entering Text & Numbers | FREE Series of Microsoft Excel Lessons

Lesson 1: Introduction to Microsoft Excel | Excel Interface | FREE Series of Microsoft Excel Lessons (pdf guide included)

Hope you are enjoying your learning 🙂

Habib Ali – ICT Tutor

34 thoughts on “Lesson 30: Best method to format numbers to display as PERCENTAGES in Excel”

  1. Thank you so much for this. I have learned a new thing today thanks to you, for free.- how to format numbers to display as percentage.
    I wish I found your channel and website earlier.
    MAny thanks

  2. Wow, not only do we learn one way, we learn the best methods to format numbers! I’m well impressed.

    You’ve such a clear way of portraying the instructions – a born teacher!

  3. Hi, this is such a great article on how to format numbers to display as percentages. I often use excel and there is so much you can do with it, your videos are very informative and have helped me solve a problem in a simple manner. I look forward to watching your other video too.

    • Thank you Kay, and you’re very welcome. Many more lessons are available here on our site and our YouTube channel. Happy to hear I have helped solve one of your problems. Feel free to share what it was, if you want 🙂

      Habib (ICT tutor)

  4. I can really appreciate how thorough you are with your teachings in these lessons. It’s obvious you are most familiar with Excel and all it has to offer. I am going to forward your site on to my son. He’s going to school for Accounting and I think he would benefit by having it. Thank you so much!

  5. Wow! You are really doing a great job by creating these easy-to-follow tutorials about Excel.

    It’s clear that you’re having a deep understanding of this program, and talent to pass the information further.

    Keep up the good work, and I’ll definitely recommend your website to my friends.

    Best Wishes,

  6. Habib,
    That was a great step-by-step process on how to do percentages with Excel! It was easy to follow and I could replicate it with ease. That’s the most important part, right? Great teaching, and simple to follow. Thank you!

    • Yes Robert, being able to follow my lessons and implement what you learn is a very important factor, which I always factor in, otherwise it will be a complete waste of time. This is something I’m very aware of too, as I’m a qualified ICT tutor 🙂

      Habib (ICT tutor)

  7. Always delivers spectacular excel tutorial. I love how you explained the concept, very detailed and in a perfect pace that anyone can understand.
    Thanks for the great tutorial.

  8. Hi there.

    Interesting videos.

    A few years back I really needed someone to explain to me how to work in excel. At the time, at my workplace I really need it. But I had to learn by myself as the courses at the time was very expensive. I am not an expert, but I can tell that many things you explain in your videos I did not know.

    The videos are really easy to follow and you explain very well.

    Well done

    • My lessons I’m offering here for FREE would normally cost hundreds of pounds. But I believe in giving free education where possible, especially in this time of need where a lot of people are out of a job due to Covid 19. I hope I can make a difference to all my visitors to my site and YouTube channel. Take care Oana 🙂

      Habib (ICT tutor)

  9. You keep on spoiling us with these excel tutorials! This time another very good lesson about formatting numbers to display as percentages.
    Thanks for making it so clear!

    • I’m going to spoil you and all our visitors and give them good quality contents, so you and everybody always feels you take something from our site always – never go empty handed 🙂

      Habib (ICT tutor)

  10. Hi Habib,

    Great pace in your video lesson, it’s good for those who are totally new to Excel. Teaching people to nail down the basics really helps.

    Keep it up!


    • Hi Sam, thank you for the comment. It depends what you call basics, for a lot of people my lessons would be advanced, but to others it may be basic as they already have a foundation of Excel. Kindly pass on the word to everybody of my FREE lessons 🙂 Thank you

      Habib (ICT tutor)

  11. I really appreciate your videos. They are so easy to follow along with and you make using excel much easier for me to understand.
    I am looking forward to learning more from your videos.
    I am needing to learn how to convert measurements in to 16ths. Like if I had a measurement of 14 inches and 7/8 and added 4 inches and a 1/4 to it. How would I get excel to display 19 inches and 3/16?


    • Hi Greg, thank you for your feedback. Now to answer your question, you will need to use a “=CONVERT” function. I will put this on my list to do for my video lessons and will create a lesson for you. So please watch out for that. Take care

      Habib (ICT tutor)

  12. Thanks a lot for another imformative tutorial. I always used to struggle when working with excel. Not anymore because your tutorials are expained always so clearly.

  13. Omgoodness! I LOVE your lessons! I am terrible with Math in general and you break everything down so well! I would have said I was terrible at Excel, but after your lessons I am definitely much better! I have actually started tracking my business reports on my own instead of having to hire out! Thank you SSSSSOOOOO much!!!!!!

    • You’re very welcome Brianna – there is so much you can do on your own, you don’t need to be hiring people out and pay-out big bucks. Carry on watching my tutorials and you have learnt a wealth of knowledge. Don’t forget to bookmark our site and subscribe to our YouTube channel 🙂

      Habib (ICT tutor)

  14. Another great tutorial Habib on how to format numbers to display as percentages.
    I always find your style of teaching really simplifies it without being patronising.
    Thanks for the help.

    • Thank you Amy – I do get quite a lot of compliments on my teaching style. My students, current and past have always highlighted this in my classes and also at the end of the course evaluation feedback forms we give them – so thank you for recognising this too 🙂

      Habib (ICT tutor)


Leave a comment

Share via
Copy link
Powered by Social Snap