Oz du Soleil

Oz du Soleil

United States
73K followers 500+ connections

Join to follow
Excel on Fire

Courses by Oz

See all courses

Articles by Oz

  • Apple iOS, Facebook & Privacy
    Feb 28, 2021

    Apple iOS, Facebook & Privacy

    Have you been paying attention to the battle Apple started when it announced that the forthcoming iOS 14.5 will require…

    16 Comments
  • My Latest Course: Excel VBA for the curious and uncommitted
    Feb 12, 2021

    My Latest Course: Excel VBA for the curious and uncommitted

    I'm writing this article about this course because it speaks to something more broadly about learning. Have you ever…

    13 Comments
  • Excel & the Missing Covid Cases
    Oct 6, 2020

    Excel & the Missing Covid Cases

    I've seen the articles about Excel being blamed for 15,841 lost Covid cases in England. Here's what I see: A clickbait…

    76 Comments
  • Excel Weekly Challenge: Filtering with Dynamic Arrays
    May 8, 2020

    Excel Weekly Challenge: Filtering with Dynamic Arrays

    This week's challenge involves the new Dynamic Arrays function: FILTER. We want to filter a list of venues based on the…

    6 Comments
  • Excel Weekly Challenge: Find the Power Query Result
    Apr 20, 2020

    Excel Weekly Challenge: Find the Power Query Result

    This short challenge is to find the result of a Power Query query and load it onto a worksheet. Our friend Tony insists…

    3 Comments
  • Excel Weekly Challenge: Pivot Table Prep
    Apr 7, 2020

    Excel Weekly Challenge: Pivot Table Prep

    Back in the olden days, when I taught pivot tables in live sessions there was always a disappointed groan. This weekly…

    12 Comments
  • Extract the 7 Largest Donations (plus BONUS VIDEO!)
    Mar 27, 2020

    Extract the 7 Largest Donations (plus BONUS VIDEO!)

    This week's challenge asks users to extract the Top 7 Donations from a list and specifically, use the LARGE function…

    9 Comments
  • Excel Weekly Challenge: Tables & Hyperlinks
    Mar 23, 2020

    Excel Weekly Challenge: Tables & Hyperlinks

    Excel is more than formulas and pivot tables. There's a lot that we can do in Excel to customize our experience.

    11 Comments
  • Excel Weekly Challenge: COUNTIFS with Wildcards
    Mar 11, 2020

    Excel Weekly Challenge: COUNTIFS with Wildcards

    This week's challenge is a short one: count the number of projects that contain FF2W and projects that end with W. (And…

    9 Comments
  • Excel Challenge: What Does this Formula Do?
    Mar 2, 2020

    Excel Challenge: What Does this Formula Do?

    The Scenario We're taking over a workbook that someone else was using and there's an important but complicated formula…

    5 Comments
See all articles

Activity

Join now to see all activity

Experience

  • Excel on Fire

    United States

  • -

  • -

    Portland, Oregon Area

  • -

  • -

  • -

    Greater Chicago Area

  • -

  • -

  • -

    Greater Chicago Area

Licenses & Certifications

Courses

  • Excel Dashboards & Pivot Tables

    -

  • Excel Forms, Validation & Input Controls

    -

Projects

  • Guerrilla Data Analysis for Microsoft Excel 2nd Ed. for 2010/2013

    Co-Author

    Other creators
    See project

  • 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.

    See project

  • 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
    See project

Languages

  • Russian

    -

Recommendations received

22 people have recommended Oz

Join now to view

More activity by Oz

View Oz’s full profile

  • See who you know in common
  • Get introduced
  • Contact Oz directly
Join to view full profile

Other similar profiles

Explore top content on LinkedIn

Find curated posts and insights for relevant topics all in one place.

View top content

Add new skills with these courses

See all courses