![\"data-analysis_linkedin\"](\"https:\/\/www.test4u.eu\/blog\/wp-content\/uploads\/2017\/01\/data-analysis_linkedin.png\")
<\/a><\/p>\n<\/p>\n
The built-in what-if tools of Excel along with the Solver add-in are the sure way to answer everyday questions and problems you will face (for example how much should a factory increase production, to meet their quota for next month).<\/p>\n
No one can avoid mistakes, but the chapter about Auditing tools will teach how to minimize them.<\/p>\n
Data Management: The chapter in data management will expand your knowledge on data manipulation showing you ways to:
\nImport data from various sources
\nFilter data
\nSort data
\nUse form controls in order to be able to create dashboard-like sheets
\nUse the Data Analysis Tool Pak add-in.
\nThe data analysis Tool Pak add-in along with the Solver add-in are the main tools you can use to answer to more specialized questions, which are part of the daily routine for someone who is doing statistical analysis, or business modelling. You will learn how to answer these questions with over thirty examples inspired by real life (display and interpret Regression statistics, predict a company\u2019s revenues or execute a Monte Carlo simulation).<\/p>\n
Power Maps! One of the most impressive add-ins of Excel, for which we have dedicated a whole chapter!<\/p>\n
You will be able to derive useful information from the data in a Pivot Table: Once you finish your training, you will be able to use pivot Tables at their full extent, including the use of slicers, trendlines, and pivot charts. In addition, you will learn how to use all your data with Power View.<\/p>\n
Using large amount of data can prove to be a lot difficult, especially if you want to extract a fragment of them. Excel provides a tool to create database like queries on your Excel data. For this tool, that was called Power Query on previous Excel versions, we decided to devote a complete chapter.<\/p>\n
Large amounts of data from various sources are no longer a headache! These chapters will change the way you deal with them:
\nPower Pivot add-in
\nCube
\nDAX functions<\/p>\n
Sharing: All professional work you do must be shared with your boss or colleagues. We will teach you how to save your workbooks in a variety of different formats and how to share your worksheets with your team.<\/p>\n
There is an extensive chapter on basic Excel training, in case you want to refresh on your Excel knowledge, or if you are newcomer to it.<\/p>\n