How to Use VLOOKUP and MATCH in Excel
[tb-youtube-iframe src="https://www.youtube.com/embed/GjjyyjSnj9k"] In this Excel tutorial, SkillForge Instructor Seth B. shows how to use the VLOOKUP and MATCH functions together in Excel to lookup data. You'll also see how to use the Evaluate Formula function in Excel, which can help you understand how a particular formula...
How to Build Websites Using HTML5
https://youtu.be/C75sZLSBwv0 Learn about the features available in HTML5 to help you build stunning, interactive websites for your users. And if you're looking for more in-depth training on HTML5, check out our HTML5 Training and other Web Development courses.
How to Start with Microsoft Teams — A Few Basics
Microsoft Teams, the messaging/meeting/hub program, allows us to centralize a few things we had to do “à la carte” before. By gathering stuff in one place, we can save time and effort. After we install it, one of the main things is to set up the...
microsoft-teams
Free Tutorial: Getting Started with Microsoft Teams
In this Microsoft Teams Tutorial, you'll learn the basics of getting started with Microsoft Teams including how to create a new team or join an existing one, how to use channels to communicate with your team and how to use chat and video calls to connect...
how to redirect page using JavaScript
Redirect a Webpage using JavaScript
Sometimes you might move a webpage to some other location but you still have people going to the old one.  We are able to redirect the users to the new page using JavaScript.  To do this, we would start with your basic HTML page, we'll pretend...
how to create a CSS class
How to create a class in HTML and CSS
In CSS you need to be able to select something on the HTML page to be able to style it.  Let's take this HTML page for example: <!DOCTYPE html> <html lang=""> <head> <meta charset="utf-8"> <title></title> </head> <body> <div>Style Me</div> </body> </html> On that page, we have...
css hover animation
How to create an animated hover link using CSS
CSS has come a long way since it's early days.  Adobe Flash used to be the only platform that would allow you to get motion or anything animated on a web page.  Those days are long gone. In this tutorial, we will go over how to...
How to Create a Resource Calendar in MS Project
The resource calendar in Project lets us take the resources' non-work  time into account. There are religious, working-two-jobs, and a few other reasons why this might come into play. So once the project calendar is established, we can create a variation of it as a resource...
CSS Relative Position
How to use relative position in CSS
Sometimes on a webpage, you need to tweak the position of something by a little bit.  Say you have an image that needs to move over a couple of pixels or a video that needs to be shifted over.  For that, we use a CSS position...
How to Use Select Case in Access VBA …and Why
The Select Case statement in Visual Basic for Applications sometimes "competes" with the If...Then...Else statement, because the two can both be used for testing information. When we want to find out about more than one thing, condition, or what have you, we sometimes need to ask...
CSS Fixed Position
How to use position fixed in CSS
Sometimes on a webpage, you'll want a part of it to never leave the screen.  No matter how much you scroll up or down, you'll want that piece of the page to always be in the same spot.  For that, we use a CSS position property...
How to Clean Up Reports in Microsoft Access
There are a few important and helpful things to watch out for in Access reports. They spring from the fact that, unlike most other database components, reports often have to stand on their own. So their formatting and layout have to be more complete and user-friendly...
default angular app page
How to run an Angular Application on a local development server
After we've created an Angular App and have it open in our text editor we will want to see what the app looks like so we can test it.  To do that, we need to run the Angular app on our machine and we can't do...
Visual Studio Code Open Folder
How to open an Angular Application inside of Visual Studio Code
After you've created a new Angular app (click the link to the left to learn how), you will need to open it up in a text editor to be able to change and add things to it.  For this, I recommend Visual Studio Code.  It's a...
Introduction to Excel PowerPivot Webinar
In this free Excel PowerPivot webinar, Excel Instructor Seth Bonder explains how to add PowerPivot functionality into Excel, how to create a data model and much more. To learn more about PowerPivot, or to enroll in one of our PowerPivot classes, please visit our Excel PowerPivot...
Create new angular app
How to create a new Angular Application
This post will talk about how to create a new Angular Application using the Angular CLI (command-line interface).  If you don't have the Angular CLI or Node installed yet, be sure to check out how to do that here. Once we have Node and the Angular...
How to Build an Error Handler in Access VBA
Dealing with errors in VBA code, especially in Access, is a vital part of setting up procedures. If nothing else, an error-handler can give the user a better idea of what’s glitching, if something does. And having a message box come up to give the user...
Angular CLI Version
How to download and install the Angular Command Line Interface (CLI)
Angular is becoming a very popular JavaScript framework that allows you to create single-page applications (SPAs).  It's backed/created by Google and it's not too hard to get an app up and running.  This post will discuss what you need to install and what you need to...
Free Webinar: Introduction to Angular
https://youtu.be/dwHe1aDR6Nc   Angular is a TypeScript-based, open-source web application framework led by the Angular Team at Google and by a community of individuals and corporations. It allows you to quickly build reactive, single-page web applications and is one of the most popular frameworks used today in...
How to Add a Calculated Field to an MS Access Query
Calculated fields are a really big help in Access; they let us derive data from existing information. And they’re flexible, too. If one of the source items changes, the calculation updates immediately, just like an Excel formula. But some people aren’t aware you can add them...