In this lesson, I’m going to be showing you how to:
- 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 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 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 (£) and apply 2 Decimal places to numbers in Excel?
Lesson 12 – What is the Wrap Text feature, and how to apply it in Excel?
Lesson 11 – What is the Merge & Center feature, and how to apply it in Excel?
Lesson 10 – Using the COUNT function to ONLY count the TEXT in a list or cell range in Excel. Is it possible?
Lesson 9 – What is the INSERT FUNCTION button for in Excel? How to use it to create different FUNCTIONS?
Lesson 8 – What is the IF function, and how to insert it in Excel?
Lesson 7 – What is the ROUND function, and how to insert it in Excel?
Lesson 6 – What is the COUNT & COUNTA function, and how to insert them in Excel?
Lesson 5 – What is the MINIMUM & MAXIMUM function, and how to insert them in Excel?
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
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
Thank you Yoana for your feedback. I’m glad to hear this has been helpful for you. Please share out video tutorials with your family and friends so they can benefit from these FREE lessons too. https://www.youtube.com/channel/UCBfGJLMmTIA3ESh9DFYWLIg?view_as=subscriber
Best Regards
Habib (ICT Tutor)
Well impressed with your simple and clear tutorials on how to format numbers. You keep it up Habib!
Thank you Ekufaa – I will keep it up always. Happy to help you understand how to format numbers as percentages in excel.
Habib (ICT tutor)
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!
Thank you for your kind words Sharon. Happy to hear you found this lesson very impressive 🙂
Habib (ICT tutor)
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)
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!
Thank you Teresa. Yes, your son will benefit a lot as Accountancy and Excel go hand in hand. Also inform him of our YouTube channel, which is dedicated to my ICT lessons 🙂
Habib (ICT tutor)
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,
Natalie
Thank you Natalie for the beautiful comment. Please pass it onto everybody that will benefit from my free lessons 🙂
Habib (ICT tutor)
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)
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.
You’re very welcome Benson 🙂
Habib (ICT tutor)
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)
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)
OMG! Amazing video. Thanks for this. Looks like I will be visiting your site often to learn.
Thanks for sharing this.
Thank you Chigs. You’re very welcome to come back to our site as often as you want – the more the merrier 🙂
Habib (ICT tutor)
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!
Cheers.
SAM
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)
Thanks for another excel tutorial. It was very easy to follow along. Looking forward to see your next post.
Thank you Ladia. There are few more lessons for you to complete, which you can do here on our website or over on our YouTube channel 🙂
Habib Ali (ICT Tutor)
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?
Thanks
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)
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.
Thank you Olga, it is my pleasure 🙂
Habib (ICT tutor)
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)
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)