Courses by Oz
-
Excel: Advanced Formulas and Functions5h 10m
Excel: Advanced Formulas and Functions
By: Oz du Soleil
Articles by Oz
Activity
-
This past weekend was one of the most exciting times I’ve experienced as a student at the University of Nevada, Reno. On Monday, I received the…
This past weekend was one of the most exciting times I’ve experienced as a student at the University of Nevada, Reno. On Monday, I received the…
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