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 »
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.
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 »
View two Excel worksheets at the same time by opening a second window and arranging them vertically or horizontally. For more ways to make Excel work for you, take training course from AdvantEdge Training & Consulting!
View two Excel worksheets in the same screen Read Post »
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!
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
