Hi Mike,
I see that Windows is not detecting your hard drive during installation, which is common on newer Intel-based systems due to missing storage drivers. Since the Dell guide didn't work, let's try manually loading the drivers.
You can follow the guide just by searching for those drivers. As they are Intel drivers, they should be available out there without having to run any program, try to get the driver as-is (usually a folder without any executable inside a ZIP) and put that folder in the root of your USB. Then continue following the guide.
If the disk still doesn't appear, check your BIOS settings. Make sure your storage controller is set to AHCI mode instead of RAID, as RAID configurations may require additional drivers.
Let me know if this helps or if you need additional steps!