create better visuals and much more
waterfallswaterfall charts give a great visual bridge between 2 or more measures such as variances between forecast and actual.
gantt chartsplan projects and other activities. select time periods. link start and end dates of dependent tasks.
speedo gaugesshow variances. adjust the background segments, targets, sizes and number formats. then edit any chart features using the standard microsoft excel chart design functions.
progress ringshighlight percentages for key metrics. automatically change color based on current set values, change inner values to currency or text. connect several rings for comparisons.
menu navigation barscreate great looking menu links to any parts of your spreadsheet, email links and web pages in seconds.
fix and speed up old filesslow running file? fix it before it becomes unusable. see if you have any of this dirty dozen. fix them with airt magic. check these:1. file tries to link to external documents when opening.2. may be warnings that the external linked file can't be found.3. maybe you believe your file shouldn't be linked to these files but can't find the link cells. airt magic can fix these quickly.4. data connection warnings when saving file.5. named ranges with errors.6. named ranges to external documents returning errors.7. too many formats warning.8. custom styles duplicated or not required. check menu {home}{styles}9. file size mb unusually high.10. {ctrl}+{end} in sheet goes to a cell far to the right or down.11. file takes a long time to recalculate.12. many formats to the right or below your data.
concatenate with seperatorsmaybe you have a list of names and want that list in a single cell but separated by ";" so you can copy to an email 'to' field? airt magic concatentate function is much more flexible than excel's standard function.
create your file then send to anyone who has excel or export to powerpoint.
