In this lesson, I’m going to be showing you how to:
- Format cells as Currency (£) in Excel
- Format cells as Accountancy (£) in Excel
- Format cells as Percentages in Excel
- Format cells as Dates in Excel
- Apply Decimal places to numbers in Excel
Download the Excel file below, and save it onto your computer. So you can complete this lesson with me.
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 14: How to insert a HEADER in Excel? | How to insert an AUTOMATIC FILENAME in the header?
Or go back to:
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
I’m glad I found your blog. I often have questions about working in Excel. And you explain so clearly and to the point. Thanks for your work!
Welcome on board! I really hope there is all the information you need to be learning more about Excel. Please let us know if there is something I’ve not covered and you would like to learn.
Many thanks for your feedback.
Habib (ICT Tutor)
This is something that should be mandatory at school. I use Excel every day and couldn’t live without it! Keep the content coming!
I agree with you Gareth. The knowledge of excel makes our lives so much easier and more efficient as it contains a lot of automated techniques and routines, which saves us time and improves on productivity.
Habib (ICT Tutor)
wow your tutorials are always good.
I have been looking for ways to actually have an excel spreadsheet to do automated calculations and have struggled to know this.
Your tutorials are what I will refer to when I need help. Thanx again Well written.
Thank you Thabo – automating spreadsheets is the way to go. Formatting cells and shading them too also gives you the visual appeal to it. Take care
Habib (ICT Tutor)
Hello Habib,
I use Excel in my work so it is great to read your explanation about specific topics of excel.
You refresh my mind with some information and you teach me new ideas. Your explanation is clear and interesting
Wishing you great success
Rania
It is my pleasure Rani, you have completed many of my lessons and I can see you are learning a lot and enjoying them very much. That is my main aim of these lessons – I want everyone to be learning and I am offering these lessons for FREE. Take care
Habib (ICT Tutor)
Hi Habib,
This is another very clear and practical post of you!
It really makes Excel looks easy and fun to use. Wish your website was already there when I had to learn this back in high school…
Greetings,
Catherine.
Hi Catherine,
Hopefully it will be useful for you now, as to me, there is not age for learning 🙂
All the best
Habib (ICT tutor)
Hey Habib,
You have some very useful tutorials and i love how simple and straight to the point they usually are. Knowing how to do the basics in Excel is so imperative in today’s world. i wish they taught this in school..but I am glad you are doing a great job!
Hi Sasha,
Thank you for your reply and lovely comments. I try my best and want to make sure it’s as simple and easy for everyone to follow.
Best Wishes
Habib
Fantastic tutorial about ‘how to format cells as currencies’. I liked the way you explained this, and it was effortless to follow. I am happy I learned something new and the fact that this task will cost me less time in the future.
Best wishes.
Jude
Hi Jude,
That’s great to know! 🙂
Please keep visiting our site for more useful contents like these at: https://lifestyletipsandhacks.com/
Best wishes
Habib (ICT tutor)
Hello – great job in showing us how to format cells in pounds and decimal places. Your video is easy to follow and will help a lot. I look forward to seeing the next ones.
Keep Well,
Nancy Hamar
BedroomsbyNancy.com
Hi Nancy,
Thank you for your lovely feedback, its very much appreciated! 🙂
I’ve got many more tutorials on Exel on my website and more coming up at: https://lifestyletipsandhacks.com/ and on YouTube: https://www.youtube.com/watch?v=5WIXOjbpK2s&list=PLp_KoITzt6sxlN2eTFuq4bevXNQwv83Aj
Kind Regards
Habib (ICT tutor)
Thank you so much for this informative lesson, Habib! I love Excel, and I regularly use both the currency and decimal place functions. I learned by trial and error, however; just bumming around until I finally struck gold. Haha I would have loved to have had your video back then! You do an excellent job of describing the process; even the newest of people to Excel can follow along and know what to do. I have saved your article, and will definitely share it with my friends and family! Great read! God bless you!
Thank you very much – explaining the basic sometimes is what we all need to understand the more complicated stuff as the basic gives you the strong foundation. I’m happy to hear you will share our site with your friends and family, so they can benefit too. Great stuff, take care.
Habib (ICT Tutor)
Hello Habib,
Like you website it is very explisit, I use excel in another compagnie I work with and I like it very much. Good job for the video it help me with what I have to do at work.
thank you for this video
Lyne
Hi,
Thank you very much for your lovely feedback and how it’s going to be helpful for you.
All the very best
Habib (ICT tutor)
Excel is not one of my strengths I have to admit and I do not use it that often. Your lessons here are valuable and I will definitely save your website for further guidance.
Great post.
Joe Joson
Thank you Joe. Please do share them with your family and friends so everyone can benefits from these tutorials on Microsoft Excel.
Best Regards
Habib (ICT tutor)
Interesting article for sure. I don’t have much experience with Excel but still found your article very helpful.
Thanks for sharing.
Thank you John. You can always try it and hopefully you will find it interesting and valuable.
All the best
Habib (ICT tutor)
Thanks Habib for these helpful lessons on using Excel. I as a complete beginner to Excel, these videos have been a gold mine of knowledge.
Wow! That’s great to know!
Please do share your feedback once you’ve watched them all here: https://lifestyletipsandhacks.com/
Best Regards
Habib (ICT tutor)
It’s so great to see such a brief yet educative tutorial. I personally find it hard sitting through long lessons and I enjoyed every bit of this delivery. It is clear that you are an expert in excel and I will certainly come back for more!
Hi,
Thank you very much for your lovely feedback. It’s very much appreciated.
Please keep visiting our site for more amazing contents like these here: https://lifestyletipsandhacks.com/
Best wishes
Hi habib
Thanks for this informative post. I usually do not use currencies in excel but it’s good to know in case of yearly budget planning
Hi Fares,
Thank you for your feedback. Hopefully my lessons will be useful for you.
All the best
Habib (ICT tutor)
Managing and graphing currency and profit is one of the main reasons I use excel so often. This is a very helpful video, and just like all your other videos, it helped me learn even more about excel.
Thank you for sharing!
-Joseph
Hi Joseph,
Many Thanks for your compliments and comments.
I’m glad to hear my tutorials on Microsoft Excel have been useful for you.
Best wishes
Habib (ICT tutor)