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
-
"We don't pay speakers." I go check the event registration page. Early bird ticket: $3,999 per attendee. Sponsorships start at $25,000 for the…
"We don't pay speakers." I go check the event registration page. Early bird ticket: $3,999 per attendee. Sponsorships start at $25,000 for the…
Liked by Oz du Soleil
-
Here's a neat Excel challenge to get you thinking not only about the math but the layout of your worksheet. One reality of working with data and…
Here's a neat Excel challenge to get you thinking not only about the math but the layout of your worksheet. One reality of working with data and…
Shared by Oz du Soleil
Experience & Education
Licenses & Certifications
Courses
-
Excel Dashboards & Pivot Tables
-
-
Excel Forms, Validation & Input Controls
-
Projects
-
Inventory System App
-
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…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 creatorsSee project
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