Author name: updates

You can share Microsoft Outlook calendar information with other people by using Microsoft Outlook in three ways: By email With Microsoft Exchange Server accounts By publishing a calendar online Share Microsoft Outlook calendars by email Calendars shared by email arrive in the recipient’s Inbox as email message attachments, with a Calendar Snapshot in the message […]

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

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 

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 

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

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

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 *

1. Turn off Screen Updating This will stop the screen flickering and updating while executing or running macros, and that will greatly speed up your code. Sub Stop_ScreenUpdating ()  Application.ScreenUpdating = False  ‘… (Your Code)  Application.ScreenUpdating = True End Sub Tip: Use Application.ScreenUpdating = False at the beginning of your code and Application.ScreenUpdating = True

Create a new email Click on the Signature button, then click on “Signatures” Check the email account you wish to change, then choose “New” Type a description for the signature Now edit the signature in the large box, formatting the font/size, use of bold/italics where appropriate. Ensure New Messages and Replies/Forwards are set to pick

Most businesses use Excel, it is an essential tool in the modern business world. But many people admit to knowing only a small amount of what it can do. Do you have Excel questions you’ve always been afraid to ask? Are you perplexed by IF Statements, VLOOKUP and INDEX MATCH? Would you like to get