This tip explains how to use conditional formatting in Excel to show values greater than and less than a figure. For more ways to make Excel work for you, take a training course from AdvantEdge Training & Consulting!
Conditional formatting simplifies reading data Read Post »
Did you find you chose the wrong design for your PowerPoint presentation? No need to close it and open a new one. Quickly change to a new design from the Themes group in the Design tab. Themes are live galleries,
PowerPoint: Quickly change to a new design Read Post »
To combine text in Access, there is no Concatenate function, like there is in Excel. You must use the & symbol, instead. The formula would be written as such: =[City]&”, “&[State]&” “&[Zip Code] The results of this example would calculate
Access: Combine Text Read Post »
When using Excel, is there information that you are constantly scrolling to find? Use “Groups” to bring the information to you.Drag-select the columns (or rows) that you wish to groupThen click the Group command in the Outline group of the
Use “Groups” to bring the information to you – Excel Read Post »
One SharePoint feature allows a user to follow a document or site, or be notified when it has been modified.To set this up, you simply select the document you wish to follow, then click the Follow option in the Document
Following a document or site in SharePoint Read Post »
You can Auto Archive folders in Outlook, in order to keep excess emails from becoming an issue. Click on the Auto Archive command, under the Folder tab, in the Properties group. A dialog box appears that allows you to set
Outlook: Auto Archive folders Read Post »
Insert videos into your Word document by selecting the Insert tab, and clicking the Online Video command in the Media group. This will open a dialog box that helps you load the video. Search for videos by entering keywords in
Word: Insert Videos Read Post »
Subtracting dates can be easy. However, formatting the answer to be shown as a countdown to an event is a little tricky. But we can create a countdown timer in Excel to do just that: First, let’s subtract our dates,
Creating a countdown for two dates – Excel Read Post »
We recently completed a SharePoint project for a small business in Denver called Pillar Properties. The project went very well, and we wanted to create a case study to show off the work. The company needed to solve collaboration and
Small Business SharePoint Case Study Read Post »
We’re pleased to announce the creation of our new SharePoint Business Consulting Website. It offers information on our SharePoint consulting services and blog articles on everything SharePoint.We just posted the first in a series of articles on SharePoint Calendars.As always,
New SharePoint Site Announcement Read Post »
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
