A Timeline can be inserted into your PivotChart, if dates are listed in your table. After you insert your PivotChart, add a Timeline, located in the Filters group of the Insert tab. Watch this short video to see a Timeline
Excel: Insert a Timeline Read Post »
Pivot Tables are useful for analyzing large amounts of data. Pivot Table slicers quickly filter the data being reviewed to narrow your view. Overwhelmed by Pivot Tables and Charts? AdvantEdge Training & Consulting has a class for that!
Pivot Table Slicer quickly filters data in Excel Read Post »
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 »
Professional Development can incorporate a wide range of courses, from management to communication. However, one thing is consistent in professional development training: Every profession can benefit from them. Could you improve your time management to get more accomplished each day?
Professional Development 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 »
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
