Monkey business for the geek in you!
It’s common to need to calculate the difference between dates/times in Excel—whether you’re figuring out how long someone worked on a given day, or the duration of travel across multiple days. In a hands-on tutorial, I’ll show you five different examples of how to work with time in Excel. 00:00 – Example #1: Calculate amount…
MSI’s 16” convertible Windows laptop has some enticing features like its QHD+ 120Hz wide gamut display supporting pen and touch, NVIDIA RTX 3050 / 3050 Ti graphics and a CNC aluminum chassis. The laptop has 360 degree hinges so it can transform into a large tablet, and it has goodies from the Intel 11th gen…
SageMaker is Amazon’s platform to build, train and deploy machine learning models quickly and at scale. And SageMaker Studio is the Integrated Development Environment (IDE) where you’ll be doing your work. In this hands-on tutorial, I’ll walk you through how to create a SageMaker Domain and launch the SageMaker Studio app through the AWS Management…
Trying to choose between GiveWP vs Charitable as the fundraising plugin for your organization or website? These are the two most popular WordPress donation plugins and they share a lot of similarities. Both can help you run full fundraising campaigns, collect payments in a variety of ways, and manage your donations on the backend. However,…
When you’re doing a mail merge in Microsoft Word (see this video: https://youtu.be/efwtPGdOWGI), it’s common to have missing data, such as a company name or an “address 2” line. In these cases, you don’t want a blank line to appear on your label (or letter or envelope), but you want it to be skipped entirely….
Released November 30, 2021! Amazon SageMaker Studio Lab (now in Preview) is a free service available to anyone who wants to learn and get hands-on practice with machine learning. No AWS account or credit card required, and no complex infrastructure to set up. In this hands-on tutorial, I walk you through how to set up…
Sometimes you need to insert/embed a PDF directly into an Excel worksheet, such as when you want to include a marketing flyer that has product specs or pictures. In a hands-on tutorial, I’ll show you how to insert/embed a PDF in a Microsoft Excel worksheet as an icon. Once it’s inserted, you can click to…
In the early days of the web, security wasn’t a primary concern. Though, as more information shuttles about the internet, there’s a necessary need for personal and computer security. Though, the protocols we have in place to help will sometimes falter. This could produce the ERR_SSL_PROTOCOL_ERROR in your browser. To read between the lines, one…
The 2022 redesign of the Vaio SX14 premium 14” business Ultrabook addresses the improvements we wished for in previous models. The carbon fiber chassis is rigid yet extremely light and as ever there’s a great selection of ports including 2 Thunderbolt 4, USB-A, HDMI and even Ethernet. The laptop has a Sharp brand IPS display…
Color theory is a big and complex topic. But if you just understand some basic concepts, you’ll be able to use color to maximum effect in your PowerPoint slides and elsewhere. In this video, I cover the basics of the color wheel, color relationships, hues, shades, tints, and some tips on when to use certain…
When it comes to inexpensive object storage in AWS, the Simple Storage Service (S3) is the way to go. It’s scalable, reliable, and can be accessed from anywhere. In this video, I’ll provide a short overview of S3, its benefits, and why you would use it. Then in a hands-on tutorial, I’ll walk through how…
Elastic Cloud Compute, or EC2, is the core service for Compute in Amazon Web Services (AWS). An EC2 instance is effectively a virtual server that you “rent,” meaning you only pay for what you use. In this video, I’ll provide a short overview of EC2, its benefits, and why you would use it. Then in…
Redis Tutorial – the What, Why and How to use Redis as a primary database ? Use this special link https://redis.info/NANA (or code: NANA200) to try Redis Enterprise Cloud to get a $200 credit, become part of a weekly raffle, and a chance to win a Tesla Model 3 ? (Terms and conditions apply)! ?…
Released November 30, 2021! Amazon SageMaker Canvas is a visual, no-code machine learning solution by Amazon Web Services. It brings machine learning to the masses—no coding, no data science, no machine learning expertise required! In this hands-on tutorial, I walk you through how to create a SageMaker Domain and launch the SageMaker Canvas app through…
Trust us when we say that you don’t want a free-for-all on your WordPress website. An open server and file hierarchy is like blood to a shark for malicious users. Of course, your server is (in most cases) safe and sound. Meanwhile, WordPress’ file permissions take care of the folders and files within. In fact,…
If you want to do any hands-on work with Amazon Web Services (AWS), you first need an account. It’s free and easy to set one up starting at aws.amazon.com. In this hands-on tutorial, I’ll show you how to get started, briefly overview the AWS Free Tier, and walk you through the sign-up process (explaining the…
If I had to explain Amazon Web Services (AWS) to my grandmother (or any other beginner), I would not tell her it’s a comprehensive cloud computing platform that offers scalable solutions and so on (even though it is). Instead, I would keep it super simple, free of jargon, and focus on the basics. That’s my…
Searching for the best WordPress maintenance service to get a little helping hand with your site(s)? Whether you’re a beginner feeling overwhelmed by WordPress, an advanced user who just wants some help, or a freelancer/agency looking to offload client sites, you can find a ton of great WordPress maintenance services at a surprisingly affordable price…
The Lenovo IdeaPad Slim 7i Pro is a 14” Ultrabook with a more powerful CPU and a better than average 16:10 aspect ratio 90Hz high res touch screen compared to competitors in its sub- $1,000 price class. The clamshell Windows 11 laptop has Intel Core i5 and i7 35 watt 11th gen CPUs instead of…
It’s that time of year when we start thinking about sending Christmas cards. Although there are many services out there to create them, you might not know that Microsoft Word has a lot of templates that are free and easy to use. In a hands-on tutorial, I’ll show you how to create a new Christmas…