Excel Archives

How-To copy Excel values to a custom lookup table

Posted by: Khurram Jamshed on September 14, 2017

Creating project custom fields and lookup tables is a common activity in a life of PPM consultant. While doing this fun activity, there is often a challenge when we try to copy/paste values from Excel to a custom lookup table. This process often tries to paste all the copied values in a single cell along

Blog Posted In: Blog, How to, Project Online

How to convert an Excel formula from SSRS report

Posted by: Ahmed Taee on October 25, 2016

In your report, create a field that will be a formula field when the report is exported to Excel. In the example below, the cell underneath Results column header will be the summation of First Value plus Second Value. The expression content will be “=C3+D3” Run the report and export it to Excel To convert

Blog Posted In: Blog, How to, Reporting, Uncategorized