Python and Excel Projects for Practice
Real exercises, projects and challenges of Excel
- Website
- practity.com · all feeds from this site
- Feed URL
https://practity.com/feed/
Read it in your FeedListing reader
Or add to: Feedly Inoreader Raw feed
Latest posts
-
Excel Challenges with Answers
Excel Challenges with Answers Mini Excel challenges are a fun way to put your skills to the test. If one of them leaves you wanting more practice, or shows you a gap you didn’t know you had, our Real Excel Challenges are the natural next step: Structured exercises, real…
-
Excel for Traders
Excel for Traders How Spreadsheets Power Decision-Making Across Every Asset Class Before the Bloomberg terminal, before the algorithmic trading platform, before the portfolio management system — there was a spreadsheet. For a significant number of serious traders, there still…
-
Exercises Solutions
Excel Challenges Solutions In this post you will find the answers to the real free Excel challenges. In the spreadsheet below for download you will see all the funcions and formulas used to solved the problems. Part 1. Restaurant bookings Select all the names in sheet “header”,…
-
Free Excel Exercises for Practice
Excel Exercises for Practice This post contains a free dataset for download and 22 hands-on Excel exercises designed for beginners and intermediate users who want to move beyond tutorials and actually get their hands dirty. You will work with a real table of restaurant booking…
-
Are You Proficient in Excel?
EXCEL PROFIENCY LEVELS How Do I KNow If I’m Proficient in Excel? Understanding Excel proficiency levels can be challenging. Whether you’re preparing for a job interview or aiming to upgrade your skills, knowing where you stand is crucial for professional growth. This…
-
Data Visualization Tools for Excel
Top Data Visualization Tools for Excel In today’s data-driven world, the humble Excel spreadsheet remains a staple tool for businesses of all sizes. While Excel offers a wealth of functionalities, the true power lies in transforming raw data into visually compelling dashboards…
-
Nim Game with Python
Simple Python project for intermediates Nim Game with Python Nim is a game of logic and strategy. The winner of Nim is the player who removes the last of 12 matchsticks. The goal of this simple Python project for intermediates is to write a program to play a version of the game…
-
Biorhythms with Python
Biorhythms with Python Write a Python program that calculates and displays the intellectual, emotional, and physical biorhythm cycles of a user, based on his/her birth date. The program should: 1. Prompt the user to enter his/her birth date (year, month, and day). 2. Calculate…
-
How Can I Practice Excel at Home?
How Can I Practice Excel at Home? In today’s data-driven business landscape, proficiency in Microsoft Excel has become an essential skill. Whether you’re a student, a professional, or an aspiring analyst, honing your Excel expertise can open doors to countless opportunities.…
-
Amicable Pairs
Amicable Pairs with Python Project to Learn Python Amicable numbers, also known as an amicable pair, are two different numbers such that the sum of the proper divisors of each number is equal to the other number. In other words, if the sum of the proper divisors of one number…
-
Python Class Challenge
Python Class Challenge Code a Python class named “submarine” to control the navigation of a submarine. Create an attribute named “depth” that saves the current meters under water of the submarine. Use a property to set the depth attribute and make it hidden. Add a method named…
-
Order by New Alphabet
New Alphabet Sort Challenge Given a new alphabet of 26 letters with no duplicates and arranged in the following order: ZRSTHIGMAUNOQEDPCKJYFWLVBX Write a Python program that sorts the words of a given sentence based on this new alphabet order. The program should print the words…
-
BlackJack with Python
Blackjack Simulator Python Game project Blackjack is one of the most popular card games played in Casinos worldwide. The game is also known as 21 because the primary objective is to reach a hand value of 21 or as close to it as possible without exceeding it. The goal of this…
-
Create Data Table Project
Create Data Table Project Python Data Problem Given the following sales data (EUR) of 5 shops online during the first half of the year: Sales in January of all shops [‘25000’, ‘89500’, ‘63000’, ‘45000’, ‘2600’, ‘120’] Sales in February of all shops [‘874000’, ‘895000’, ‘412569’,…
-
Zig Zag Message Encryption
Zig Zag Message Encryption Write a Python program to encrypt a message with the rail-fence method. The program will ask the user to input the message to hide and print out the encoded output, This method consists of writing the text as a zig-zag with a given height and extract…
-
How Do I Know If I am proficient in Python?
How Do I Know If I am proficient in Python? Python, with its simplicity and versatility, has become one of the most popular programming languages in the world. Whether you’re a beginner or an experienced developer, assessing your proficiency in Python is crucial for personal and…
-
Fractions Calculator Project
Fractions Project with Python Write a Python program that performs addition and subtraction operations on fractions. The program should specifically calculate the following operations: 1. Addition: 9/7 + 8/6. 2. Subtraction: 160/4 – 65/15 Ensure that your program does not use…
-
Shopping List Program
Shopping List Program Assume you’re given 5 EUR to buy vegetables for the week in the supermarket. The unit prices in cents are the following: Tomato: 50, Onion: 100, Salad: 129, Garlic: 45, Pepper: 155, Cucumber: 350 Write a Python program that prints out the combination of…
-
Decoding Project
Decoding Project with Python Imagine there is new language whose only character is case sensitive X. We know that the following X’s combinations correspond to a certain latin letter: XXx–>a xXX–>e XxX–>H xxx–>o Xxx–>r XXX–>u xxX–>w xXx–>y The goal of this project with Python is…
-
Invisible Friend Game
Invisible Friend Game Python Problem with Solutions The invisible friend game is a traditional gift exchange played in offices where everybody is randomly assigned to give a gift to other coworker. To make things exciting, the matching is random (you cannot pick your gift…