frpe,
Properties exports many methods (available as macros in Excel) which allow to calculate all usual properties as density, viscosity, cp, cv, isothermal compressibility etc. in addition there are methods for less common properties as for example the speed of sound for mixed (vapor+liquid) mixtures (with HEM model)
=StrMSS(stream,t,p)
in Excel my preferred approach is to utilize the macros which include operating conditions,
in your example
=EStrLIC(1,$A1,$A2)
where the value of temperature is defined in cell A1 and pressure in cell A2,
you can easily change the values and this activates the macro EStrLIC(), the procedure solves a isothermal flash at specified t,p , calculates the values of isothermal compressibility for liquid phase and returns the value, results are almost immediate.
You can define a sequence of operations, for example temperature and/or pressure could be the result of some previous operation, this allows to simulate simple units, you can utilize the Solver (included in Excel) to change some variables to reach a desired value.
Also you can create tables of values, graphs etc. there are examples provided with the software.
In Properties You can define operating conditions with a flash operation,
for example the isothermal multiphase flash has the macro
=setOp(stream,t,p)
but all the methods for H-P, H-T, S-P, S-T, V-P, V-T operations are available,
some are (in my opinion) of limited use, for example the constant energy flash, but you may need them, in some cases.
Also you may define streams, solve all unit operations etc. from Editor, this is a quick way to get results.
To answer your questions,
I would suggest for Excel pages the methods which include operating conditions while other methods are probably more useful in union with VBA (in my opinion)
In Properties (as in other simulators) you can define operating conditions with a flash operation, in Excel via macro or Properties Editor.