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