Advanced formulas to match all the requirementsĮxcel's highlight is the array of formulas it can use to manipulate data. It uses functions to perform simple to complex calculations, from a trivial sum to financial, mathematical and statistical operations, or even engineering and web-related tasks.ĭesigned for complicated data sets and spreadsheet collections as much as it is for simple calculations, it bundles tracing options for precedents and dependents, which work together with other formula auditing tools to help you create a fully-working workbook. Data querying and what-if analysisĭata set querying is also possible, and the array of compatible sources is not to be neglected. Visually represent your data to make better decisions It includes locally-stored files, some of the most popular database servers, Microsoft Azure, or online sources, Sharepoint, Active Directory, Microsoft Exchange, Facebook, and Salesforce.įurthermore, Excel can perform what-if analysis, testing different scenarios and generating forecast worksheets.
0 kommentar(er)
