Lurking just beneath Microsoft Excel’s instantly understandable spreadsheet surface is a world of robust automation tools. Visual Basic for Applications allows you to perform complex data processing, and you can harness its power with this Microsoft VBA Bundle, available now in the Boing Boing Store for $29.99.
This duo of in-depth courses will teach you how to write VBA code like a pro. Throughout these 9 hours of video content, you’ll study the basics of defining variables, functions, and subroutines, as well as explore the crucial PivotTable object. You’ll learn how to create spreadsheets that communicate with users through inputs and messages, and even programmatically interact with Excel’s context menus and ribbon interface.
If you find yourself repeating the same actions often, this collection will help you streamline your workflow considerably. Pick up the Microsoft VBA Bundle here for $29.99.
Yoshitaka Sakurada might not be Japan’s best pick for the cybersecurity portfolio: confused by a USB drive, he was forced to admit he’d never even used a computer.
The bad news is that, due to the sheer tininess of certain components, iPhones are particularly vulnerable to going haywire in the presence of helium. The good news is that helium just isn’t a problem you run into often. Sure enough, Apple’s user guide for the iPhone and Apple watch admits this is a problem: […]
A single smut-addicted official at the US Geological Survey led to an IT crisis there, according to an official report, with visits to more than 9000 porny URLs resulting in a malware infestation. The recommendations? Filter the web, and plug those damned USB ports. Correction: More than 9000 sites, not 9000 infections.
Ever wondered what it takes to make the transition from amateur photography to a full career? If you answered “a better camera,” you’re half right. Before you get the equipment, get the know-how to use it with the Hollywood Art Institute Photography Course & Certification. Taught by experienced pros, this course is geared towards shutterbugs […]
Anyone can learn piano, but don’t tell that to the bored kids who had to endure hours of “Chopsticks” and similar drills in their music lessons. Today, there’s a better way. Pianoforall lets you jump right in to discover what makes music fun, leaving you eager to learn more. In a simple but innovative approach, […]
There are two times you never want to just “eyeball” it: Conducting brain surgery and matching shades of paint for your walls. Whether you’re painting or repainting, make sure you’re never just “close enough” to the color you want. Not when the Nix Mini Color Sensor can scan and match any color perfectly. Small enough […]