The Excel FILTER function is a versatile yet often overlooked feature that can significantly enhance your data analysis workflow. Unlike VLOOKUP or XLOOKUP, FILTER excels at returning multiple matching results simultaneously, making it particularly useful for tasks like extracting all transactions … [Read more...] about Why Excel’s FILTER Function Outperforms VLOOKUP for Complex Data
Julian Horsey
Author Archives:
Executive Editor & Co-Founder of Geeky Gadgets
Julian Horsey is the co-founder of Geeky Gadgets and a veteran technology journalist with over 18 years of experience. A published author and multimedia designer, he specializes in emerging frontiers including Artificial Intelligence, autonomous agents, and next-gen hardware like mini PCs and wearables.
Driven by curiosity and a passion for design, Julian provides in-depth analysis on how AI workflows—from Claude to Google Gemini—are transforming productivity and creativity. His work has been cited by global tech leaders and major publications, reflecting nearly two decades of expertise in 3D printing, AR/VR, and DIY electronics. When not exploring the latest AI models, he is an avid maker and experimenter in the world of DIY tech.
Connect with Julian:
X / Twitter | Muck Rack
What Valve’s Leaked June 2026 Steam Machine Details Mean for Your Living Room
Valve’s upcoming Steam Machine has been the subject of much speculation and recent leaks suggest an official reveal is set for June 23, 2026, at 10:00 a.m. PT. According to details shared by Joshua Keith, the device combines a custom AMD Zen 4 CPU and a semi-custom RDNA 3 GPU, offering a significant … [Read more...] about What Valve’s Leaked June 2026 Steam Machine Details Mean for Your Living Room
macOS 27 Golden Gate: 10 New Features and AI Upgrades
Apple's macOS 27 Golden Gate introduces updates designed to enhance functionality and visual consistency. One standout feature is the liquid glass transparency effect, allowing users to adjust window translucency for a tailored desktop experience. As noted by MacVince, this addition, combined with … [Read more...] about macOS 27 Golden Gate: 10 New Features and AI Upgrades
New Zephyrus G16 Laptop : Intel Panther Lake Meets 14.5-Hour Battery
The ASUS Zephyrus G16 (2026) refines its reputation as a standout portable gaming laptop, blending a lightweight design with premium features tailored for both gamers and professionals. As highlighted by Jarrod'sTech, the device’s 16-inch OLED display is a key enhancement, offering a 240Hz refresh … [Read more...] about New Zephyrus G16 Laptop : Intel Panther Lake Meets 14.5-Hour Battery
How to Build a Crane Robot to Clean Your Home
Building a household cleaning robot involves combining mechanical design with smart control systems, as demonstrated by Over Engineer. This hands-on walkthrough focuses on constructing a cable-driven parallel robot (CDPR), a system valued for its lightweight and adaptable design. The project uses … [Read more...] about How to Build a Crane Robot to Clean Your Home
Why the DJI Pocket 4P Might Disappoint Modern Social Media Creators
DJI has officially launched the Pocket 4P, a compact camera aimed at content creators who demand advanced features in a portable device. As highlighted by Tech Court, the Pocket 4P combines a dual-camera system with a 1-inch primary sensor and a 60mm telephoto lens, offering flexibility for diverse … [Read more...] about Why the DJI Pocket 4P Might Disappoint Modern Social Media Creators
XREAL R1 vs XREAL One Pro vs XREAL 1S : 240Hz Gaming or 1200P Clarity
The XREAL R1, XREAL 1 Pro and XREAL 1S are three distinct models of augmented reality glasses, each tailored to different user needs. Gamers' Generation examines their technical differences, such as display resolution, refresh rates and field of view (FOV). For example, the XREAL 1S features a 1200p … [Read more...] about XREAL R1 vs XREAL One Pro vs XREAL 1S : 240Hz Gaming or 1200P Clarity
Rokid AI Glasses Three Months Later: Assessing the Real Value
Three months after their release, the Rokid AI Glasses continue to be assessed for their practicality and functionality. Jasmine Uniza notes that the 2.5K resolution camera stands out as a valuable feature, particularly for content creators needing high-quality point-of-view footage. While the … [Read more...] about Rokid AI Glasses Three Months Later: Assessing the Real Value
What Google’s New NotebookLM 2.0 Update Means for Coders and Researchers
Google's latest update to NotebookLM introduces enhanced functionality designed to support research, coding and productivity workflows. Powered by the Gemini 3.5 Flash model, the system now includes features like multi-step workflows, which break down complex tasks into smaller, actionable stages. … [Read more...] about What Google’s New NotebookLM 2.0 Update Means for Coders and Researchers
How the DwarfStar Project Fits 284-Billion Parameter AI on Your Laptop
Running advanced AI models on everyday laptops is now achievable due to advancements in optimization methods. Prompt Engineering examines how techniques like selective quantization and SSD streaming enable large-scale models, such as the 284-billion-parameter DeepSeek V4 Flash, to run on … [Read more...] about How the DwarfStar Project Fits 284-Billion Parameter AI on Your Laptop
Anker Just Built a Coin-Sized AI Voice Recorder That Transcribes 150 Languages
Anker has introduced the SoundCore Work, a compact AI voice recorder that combines portability with advanced functionality. Measuring just 23.2 mm in diameter and weighing 10 grams, this device is small enough to fit in your pocket while offering practical features for various scenarios. According … [Read more...] about Anker Just Built a Coin-Sized AI Voice Recorder That Transcribes 150 Languages
Garmin Enduro 4 : What the Garmin Connect APK Teardown Reveals
The Garmin Enduro 4 has been officially identified through an APK teardown of Garmin Connect version 5.26, where a new device entry labeled "Enduro_4" with device ID 5179 was uncovered. This discovery, highlighted by TechAvid, confirms that Garmin is actively preparing for the device's release, … [Read more...] about Garmin Enduro 4 : What the Garmin Connect APK Teardown Reveals
