This is a more theoretical question. I work for a P&L group where we use extensively excel.
Our objective is to reconciliate the traders data into a comprehensive profit and loss statement. For this purpose, some of the feature we use are sumif functions, vlookups, hlookups and if functions. I have heard that Access can be more poweful than excel on many instances. Could you guys share some ideas on what types of access features could nicely complement or replace excel.