Hello
I am able to use xcelsius and make little bit of things , but when it comes to make a dashboard or make some components work with each other , i usually got stuck there , i know xcelsius works on excel formula base but how to make sense of formulas in excel when making something.When to put formula ? label shld show " This data " but when i hit toggle button " data shld be there which i selected " . I want to ask if you guys can recommend me any website to learn few excel formulas that is needed in xcelsius to make things work , Really thanks in advance
Thank you , I know how to use xcelsius , But dont know much Excel , can you recommend me someplace to learn excel better and make to sense of formulas. i want to be strong in excel formulas so i can accomplish my requirements
Not all excel formulae are supported in xcelsius. You’d really be better off working out what you want to do in your dashboards and then figuring out a way of achieving it rather than learning formulae out of context.
debbie
ETA: the formulae I use most often are IF statements, VLOOKUPS and simple CONCATENATION. Occasionally I use NOW() and other date generations and TEXT - but for anything more complex, I do it on the database side instead as it’s faster.
(BOB member since 2008-06-05)
(BOB member since 2005-03-01)