Courses by Oz
Articles by Oz
-
My Latest Course: Excel VBA for the curious and uncommitted
My Latest Course: Excel VBA for the curious and uncommitted
By Oz du Soleil
Activity
-
Tip 1298 - "𝘿𝙤𝙣'𝙩 𝙡𝙚𝙩 𝙬𝙤𝙧𝙠 𝙜𝙚𝙩 𝙞𝙣 𝙩𝙝𝙚 𝙬𝙖𝙮 𝙤𝙛 𝙥𝙧𝙤𝙜𝙧𝙚𝙨𝙨." #TwinzTalk Throughout our careers, Don Tomoff, MBA and I…
Tip 1298 - "𝘿𝙤𝙣'𝙩 𝙡𝙚𝙩 𝙬𝙤𝙧𝙠 ��𝙚𝙩 𝙞𝙣 𝙩𝙝𝙚 𝙬𝙖𝙮 𝙤𝙛 𝙥𝙧𝙤𝙜𝙧𝙚𝙨𝙨." #TwinzTalk Throughout our careers, Don Tomoff, MBA and I…
Liked by Oz du Soleil
-
🚀 ChatGPT is awesome, but if you haven't tried out Claude, I encourage you to check it out! It's really good for visualizing data and creating…
🚀 ChatGPT is awesome, but if you haven't tried out Claude, I encourage you to check it out! It's really good for visualizing data and creating…
Liked by Oz du Soleil
Experience & Education
-
Excel on Fire
View Oz’s full experience
By clicking Continue to join or sign in, you agree to LinkedIn’s User Agreement, Privacy Policy, and Cookie Policy.
Licenses & Certifications
Courses
-
Excel Dashboards & Pivot Tables
-
-
Excel Forms, Validation & Input Controls
-
Projects
-
Inventory System App
-
See projectA nonprofit needed a system for tracking incoming and outgoing donations. They receive a lot of household items like clocks, chairs, bed sheets, etc. And they're used in several dozen assisted living units.
The organization had a low budget thus, a true database wasn't an option.
In Excel I was able to build an app that has a form for Incoming donations, a form for Outgoing donations, and storage for the transaction histories.
Some Requirements:
- Tracking of who…A nonprofit needed a system for tracking incoming and outgoing donations. They receive a lot of household items like clocks, chairs, bed sheets, etc. And they're used in several dozen assisted living units.
The organization had a low budget thus, a true database wasn't an option.
In Excel I was able to build an app that has a form for Incoming donations, a form for Outgoing donations, and storage for the transaction histories.
Some Requirements:
- Tracking of who processed each transaction
- Preventing users from requesting items that don't exist (e.g., I can't request 5 chairs if only 2 are in inventory.)
- The app won't accept incomplete information (e.g., incoming donations won't be accepted without an item name, category, quantity, date donated and user name.)
- Overall protections so that the formulas can't be written over. -
Stock & Mutual Fund Information Retrieval App
-
This app is designed with a Buy and a Sale component. The user can load stock or mutual fund tickers to retrieve real time stock quotes. If a person is considering sale of a stock, they can load the approximate purchase date and the app will retrieve the closing price of that day. In the case that the user chooses a Saturday, Sunday or holiday, the app chooses a price closest to the date that was input.
The app can accept up to 25 tickers at once.
The app allows users to put in…This app is designed with a Buy and a Sale component. The user can load stock or mutual fund tickers to retrieve real time stock quotes. If a person is considering sale of a stock, they can load the approximate purchase date and the app will retrieve the closing price of that day. In the case that the user chooses a Saturday, Sunday or holiday, the app chooses a price closest to the date that was input.
The app can accept up to 25 tickers at once.
The app allows users to put in their tax bracket and then approximates the net result of a sale after taxes and fees.Other creators -
Languages
-
Russian
-
Recommendations received
22 people have recommended Oz
Join now to viewOther similar profiles
Explore collaborative articles
We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.
Explore More