Fill data into a data set by customizing the ribbon to include Excel Data Forms. For more ways to make Excel work for you, take a training course from AdvantEdge Training & Consulting!
Creating an Excel template allows a person to reuse a workbook setup over and over, without the need to reinvent the wheel every time. The workbook being used for the template needs to have old data cleared out (i.e., the
Creating an Excel template Read Post »
Did you know that you can use the same formulas in calculation columns for SharePoint, as you do in Excel? The trick is to remember that you are using fields, instead of cells, so fields must be surrounded by brackets
Use the same formulas & calculations as in Excel – SharePoint Read Post »
Are you someone who presents or trains using computers on a regular basis? Do people have a hard time following because they are not able to see the cursor? Check out this video for an easy fix: Get what you
Windows: Can you see the cursor? Read Post »
Spice up the “Useful Links” section of your SharePoint page by selecting a “Promoted Links” app. These apps are more eye-catching, adding life to your page. Don’t like the way regular hyperlinks look? Employ this app to use pictured links.
Promoted Links – SharePoint Read Post »
If you want a presentation that does not put people to sleep and forces them to listen, then learn the art of expansion. PowerPoint slides are meant to be placeholders, not read-a-longs. When people are not sure what is going
PowerPoint: The art of expansion Read Post »
SharePoint promoted links are a great way to dress up your site. By default, however, they do not wrap to more than one row. Some of the links are hidden until you scroll right with the right arrow. This functionality
Wrap Promoted Links in SharePoint Read Post »
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 »
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
