Courses by Oz
Articles by Oz
Activity
-
It's been an intense few weeks and it's not over! I was in London for the #GlobalExcelSummit produced by Tea Kuseva, Elena Lalovska and the main…
It's been an intense few weeks and it's not over! I was in London for the #GlobalExcelSummit produced by Tea Kuseva, Elena Lalovska and the main…
Shared by Oz du Soleil
-
Really happy to share I got the opportunity to be a commentator in the Microsoft Excel European Championship last Saturday! It was an amazing event…
Really happy to share I got the opportunity to be a commentator in the Microsoft Excel European Championship last Saturday! It was an amazing event…
Liked by Oz du Soleil
Experience & Education
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 creatorsSee project
Languages
-
Russian
-
Recommendations received
21 people have recommended Oz
Join now to viewOther similar profiles
-
Ibrahim Salako
Ibrahim Salako
<br>Remote Administrative Support | Freelance Document & Research Assistant<br><br><br>I’m a freelance admin and virtual support specialist, offering remote help with personal and business tasks from document editing and formatting to online research, email handling, form filling, and organizing digital files. <br>I’ve worked with clients from different parts of the world, mostly on one-time and short-term projects. My focus is on fast, discreet, and reliable delivery, tailored to whatever support my clients need. I’m always open to helping people simplify their workload — especially with those little time-consuming tasks.
Explore top content on LinkedIn
Find curated posts and insights for relevant topics all in one place.
View top content