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!
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 »
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
