Posts

Showing posts with the label Microsoft Office

Featured Posts

CS50 Python , Nutrition Facts Table

Image
Nutrition Facts: Python Practice for Beginners Nutrition Facts Table for Python Practice Welcome to this comprehensive guide for Python beginners! If you are learning how to work with lists, dictionaries, and loops, this post will help you build practical skills using a real-world example: nutrition facts for fruits. Understanding how to organize and manipulate data is a key part of programming, and this exercise will give you hands-on experience. Below is a sample table of fruits and their calorie values, formatted as a Python list of dictionaries. This structure is ideal for coding exercises, projects, or even building your own nutrition calculator. You can expand this list, add new fruits, or use it as a foundation for more advanced Python tasks. Python List of Dictionaries Example: fruits = [ {'name': 'Apple', 'calories': 130}, {'name': 'Avocado', 'calories': 50}, {'name': 'Banana', 'ca...

Convert a Currency Number to Words in Excel

Image
Convert amount from Number to Words Convert a Currency Number to Words in Excel  Step by Step tutorial This VBA code will enable you to convert any amount in an excel cell to words amount with 6 currencies very easily. Steps are below: 1- Open an Excel file and press Alt + F11 2- Click Insert, Module Alt + F11 3- Copy below text and paste it in the module Option Explicit 'https://ilpd-ms.blogspot.com/2020/03/how-to-convert-amount-from-number-to.html Function  SpellNumberEDP(ByVal MyNumber, Optional MyCurrency As String = "")      Dim  Dollars, cents, Temp      Dim  DecimalPlace, Count      ReDim  Place( 9 ) As String     Place( 2 ) =  " Thousand "     Place( 3 ) =  " Million "     Place( 4 ) =  " Billion "  ...