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 how Timeline
Timelines with Excel PivotCharts Read Post »
Unhide all hidden columns in an Excel spreadsheet by selecting the entire spreadsheet and selecting Unhide. . For more ways to make Excel work for you, take a training course from AdvantEdge Training & Consulting!
Unhide Columns in Excel 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. Read Post »
Trace Excel Precedents by selecting a cell with a formula, and hitting Control [ For more ways to make Excel work for you, take a training course from AdvantEdge Training & Consulting!
Trace Excel Precedents with Control [ Read Post »
Make large numbers more readable in Excel by changing their format. For more ways to make Excel work for you, take a training course from AdvantEdge Training & Consulting!
Make large numbers more readable in Excel Read Post »
Use the Add background button in Excel to add a background. Use cell fill colors to keep data readable. For more ways to make Excel work for you, take a training course from AdvantEdge Training & Consulting!
Add a background image in Excel Read Post »
The count function counts the number of cells containing a numeric value. Count A returns the number of cells containing anything. For more ways to make Excel work for you, take a training course from AdvantEdge Training & Consulting!
Count and Count A functions in Excel Read Post »
Use this tip to return a blank field from an IF statement. For more ways to make Excel work for you, take a training course from AdvantEdge Training & Consulting!
Leaving Blank values in Excel Read Post »
Are you frustrated with the new look of SharePoint? Did developers build your site, and now it does not visually look the same? You can set the default view of libraries, lists, and sites back to the Classic view by
SharePoint: Frustrated with the new look of SharePoint? 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.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
