In: Math
Answer the following question
What are some of the advanced features for modeling available in Excel? Based on what many of you have already seen of Excel in CS105, are you surprised that Excel has so many capabilities? Do you use Excel for anything other than school work today?
Excel 2013 has powerful data analysis features. You can build a data model, then create amazing interactive reports using Power View. You can also make use of the Microsoft Business Intelligence features and capabilities in Excel, Pivot Tables, Power Pivot, and Power View.
Data model is used for building a model where data from various sources can be combined by creating relationships among the data sources. A Data Model integrates the tables, enabling extensive analysis using Pivot Tables, Power Pivot, and Power View.
A data model is created automatically when you import two or more tables simultaneously from a database. The existing database relationships between those tables is used to create the Data Model in Excel.
Step 1 − Open a new blank Workbook in Excel.
Step 2 − Click on the DATA tab.
Step 3 − In the Get External Data group, click on the option From Access. The Select Data Source dialog box opens.
Step 4 − Select Database file.
Step 5 − The Select Table window, displaying all the tables found in the database, appears.
Step 6 − Tables in a database are similar to the tables in Excel. Check the ‘Enable selection of multiple tables’ box, and select all the tables. Then click OK.
Step 7 − The Import Data window appears. Select the Pivot Table Report option. This option imports the tables into Excel and prepares a Pivot Table for analyzing the imported tables. Notice that the checkbox at the bottom of the window - ‘Add this data to the Data Model’ is selected and disabled.
Step 8 − The data is imported, and a pivot table is created using the imported tables.
You have imported the data into Excel and the data model is created automatically. Now, you can explore data in the five tables, which have relationships defined among them.
it is suprising to see that excel has so many applications but the fact is excel is now the solution to all modern problems in modelling field specially in visualisation and analysis.
off course i use excel for more than school work .it has got uses in other sectors and fields also few are given below
Microsoft Excel is a spreadsheet program. That means it's used to create grids of text, numbers and formulas specifying calculations. That's extremely valuable for many businesses, which use it to record expenditures and income, plan budgets, chart data and succinctly present fiscal results.
It can be programmed to pull in data from external sources such as stock market feeds, automatically running the data through formula such as financial models to update such information in real time. Like Microsoft Word, Excel has become a de facto standard in the business world, with Excel spreadsheets frequently emailed and otherwise shared to exchange data and perform various calculations.
Excel also contains fairly powerful programming capabilities for those who wish to use them that can be used to develop relatively sophisticated financial and scientific computation capabilities.