Microsoft Excel VLOOKUP troubleshooting tips How to Fix Common Excel VLookup Problems Quickly If you use the VLOOKUP function to look up values in a list or table, it’s possible to end up with #N/A errors, particularly when you’re looking for exact matches. Although these errors are annoying, they occur for a good reason—either the […]
Troubleshooting VLOOKUP functions in Microsoft Excel Read More »
Know the Basic Scheduling Formula Duration = Work/Units Understanding of the meaning of these three terms (See Project Help), as well as the formula itself, is key to understanding how Project schedules a task. To anyone who has changed any of these three parameters on a task, without understanding this formula, the changes that Project
Three Crucial Points for Proper Resource Assignments in Microsoft Project Read More »
Know the Basic Scheduling Formula Duration = Work/Units Understanding of the meaning of these three terms (See Project Help), as well as the formula itself, is key to understanding how Project schedules a task. To anyone who has changed any of these three parameters on a task, without understanding this formula, the changes that Project
Three Crucial Points for Proper Resource Assignments in Microsoft Project Read More »
Following on from our recent PowerPoint Top Tips, we’ve added these five simple ideas, to help make the most of your use of Microsoft PowerPoint presentations. 1. Display Information Clearly Think about the effect of the design of your slide. You may choose one of the existing design themes that come with PowerPoint, or create one
Five More Useful Ideas for Microsoft PowerPoint Read More »
A guide to developing a learning plan Meeting needs in a challenging climate — smaller budgets, greater needs Organisations need to ensure realistic returns on their investment in employee training programs. For many, identifying benefits from training such as improved performance, increased efficiency and reduced time on everyday tasks are difficult to measure. Often, when
Developing a Learning Plan Read More »
The Bang! (Exclamation Operator) in VBA In Visual Basic for Applications the ! operator, called the “bang” can often be confused with the . operator, called the “dot”.It is particularly common in code for Microsoft Access, where you may see things like this: strCriteria = “EmployeeID = ” & Me!txtEmplID Set rst = CurrentDb.OpenRecordSet(“SELECT *
Using the Bang (!) or Dot (.) in Microsoft Access Read More »