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. Data querying and what-if analysisĭata set querying is also possible, and the array of compatible sources is not to be neglected. 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. Advanced formulas to match all the requirementsĮxcel's highlight is the array of formulas it can use to manipulate data. Additionally, the spreadsheet can include pictures, shapes, SmartArt figures, and even screenshots you take on-the-spot using the built-in capturing tool. Cells can contain all sorts of data, from numbers, currency, and percentages to date and time entries, zip codes, phone or social security numbers.ĭepending on your data set and what you want to illustrate, you can generate a variety of chart types (column, line, pie, bar, area, scatter, stock, surface, histogram, combo, and more). Organize data and generate chartsĭocuments in Excel have a table-like structure, with numbered rows and columns to help you easily identify a cell's position in the spreadsheet and manipulate data easier.
Included in the Microsoft Office suite, it facilitates data organizing and can run thorough analysis and complex calculations. Microsoft Excel is the spreadsheet program that needs no introduction, being one of the most popular application in its category.
0 kommentar(er)
