Microsoft Office
How to Use the Slide Master View in PowerPoint
In this PowerPoint tutorial, we’ll show you how to use the Slide Master view. It can help you keep your presentation’s appearance consistent throughout. Adding graphics and formatting text in the view are easy once you get there. Want to learn more about these and …
How to Use VLOOKUP and MATCH in Excel
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 is …
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 …
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 …
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 …
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 …
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 …
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 …
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 …