1. Home Page 
  2. /
  3. e-tests 
  4. / Data Analysis - English version

Data Analysis
English version

Rely on TEST4U because it offers:


TEST4U - Data Analysis

Being a data analyst requires a variety of skills in Excel.

If you dream of working as an analyst, but you lack a few skills in order to master MS-Excel, TEST4U Data Analyst is the ultimate know-how interactive tutor!





Cosa dicono di noi i nostri clienti
Cosa dicono di noi i nostri clienti


 

We have equipped TEST4U with the following, in order to help you acquire these valuable skills:

  • We will help you learn the usage of more than 180 Excel functions, about:

    • Text manipulation
    • Mathematical calculation
    • Logical decisions
    • All the lookup functions you can use to retrieve data from your sheets
    • Almost all the financial functions and
    • Almost all the statistical functions Excel has to offer

  • You will learn about array and multi-sheet formulas, which will give you the needed flexibility to use data from multiple sources.

  • 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).

  • No one can avoid mistakes, but the chapter about Auditing tools will teach how to minimize them

    data analysis - cell relationship diagram
  • Data Management: The chapter in data management will expand your knowledge on data manipulation showing you ways to:

    • Import data from various sources
    • Filter data
    • Sort data
    • Use form controls in order to be able to create dashboard-like sheets
    • Use the Data Analysis Tool Pak add-in.

  • The 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’s revenues or execute a Monte Carlo simulation).

  • Power Maps! One of the most impressive add-ins of Excel, for which we have dedicated a whole chapter!

    data analysis - power-maps
  • 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.

  • 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.

  • Large amounts of data from various sources are no longer a headache! These chapters will change the way you deal with them:

    • Power Pivot add-in
    • Cube
    • DAX functions

    data analysis - Power pivot
  • 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.

  • 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




How TEST4U works

TEST4U Test is an interactive, highly customizable tool that meets your personal learning needs. During the media-rich TEST4U experience, you will amplify your understanding of MS Excel, the most famous and flexible spreadsheet software, part of Microsoft Office Suite.

TEST4U Test will help you improve your skills because it contains:

  • 728 Live in ates Questions
  • 38 Quiz Questions

Instead of being just another e-lesson with a few multiple choice questions, TEST4U Test makes the difference! The questions it contains require actual tasks to be performed. For each question, you are asked to take some actions, which TEST4U will evaluate. Much like the actual working conditions: you can’t make educated guesses! In order to answer correctly, you must know which buttons to use.

If your knowledge of a topic is limited, you can watch our video-solutions which guide you step-by-step.

Try how TEST4U works.

Ultimo aggiornamento: 12 Nov 2018
Requisiti minimi di sistema
CPU: Pentium® 4 (or newer)
RAM: 512ΜΒ +
Hard disk free space: 1-10GB
Minimum screen resolution: 1152x864 (size of text, apps and other items 100%)

Operating system: Windows 10 / 8.1 / 8 / 7 (updated with newer service pack - Region Format: English (United States))
Internet Explorer: 10+
MS Office Excel 2016 or 2013 - English Version (Fully Functional) must be installed - There must be only one version installed
Continuous Internet connection is required
Programma di studio
Questo prodotto copre il seguente programma. Puoi vedere le sezioni coperte e il numero di domande facendo clic su ciascuna scheda.
TEST4U
  DOMANDE IN-ATES [?]
 
QUIZ DOMANDE [?]
 
DOMANDE IN TOTALE
 
  728 37 765
Basic Excel Training 262 11 273
SEZIONE 1 Basic Functionality DOMANDA DI CAMPIONE 44 5 49
SEZIONE 2 Cells DOMANDA DI CAMPIONE 32 1 33
SEZIONE 3 Worksheets DOMANDA DI CAMPIONE 17 1 18
SEZIONE 4 Range names DOMANDA DI CAMPIONE 4 0 4
SEZIONE 5 Formatting DOMANDA DI CAMPIONE 40 0 40
SEZIONE 6 Images and shapes DOMANDA DI CAMPIONE 11 0 11
SEZIONE 7 Charts DOMANDA DI CAMPIONE 35 0 35
SEZIONE 8 Tables DOMANDA DI CAMPIONE 10 0 10
SEZIONE 9 Sorting in Excel DOMANDA DI CAMPIONE 8 0 8
SEZIONE 10 Conditional formatting DOMANDA DI CAMPIONE 14 0 14
SEZIONE 11 Excel Settings DOMANDA DI CAMPIONE 13 0 13
SEZIONE 12 Printing DOMANDA DI CAMPIONE 24 1 25
SEZIONE 13 Save and Export DOMANDA DI CAMPIONE 10 3 13
Auditing tools 35 1 36
SEZIONE 1 Inquire add-in DOMANDA DI CAMPIONE 8 0 8
SEZIONE 2 Error Solving DOMANDA DI CAMPIONE 27 1 28
Text functions 16 0 16
Mathematical Functions 29 0 29
Logical functions 11 0 11
Date and Time functions 18 0 18
Lookup functions 13 0 13
Financial Functions 39 0 39
Statistical functions 39 0 39
Array Formulas 6 0 6
Multi sheet multi workbook formulas 6 0 6
What-if tools and Solver Add-in 19 0 19
SEZIONE 1 What-if tools DOMANDA DI CAMPIONE 10 0 10
SEZIONE 2 Solver Add-in DOMANDA DI CAMPIONE 9 0 9
Data management 56 0 56
SEZIONE 1 Filtering data and removing duplicates DOMANDA DI CAMPIONE 10 0 10
SEZIONE 2 Data Analysis Tool Pak DOMANDA DI CAMPIONE 2 0 2
SEZIONE 3 Paste Special DOMANDA DI CAMPIONE 7 0 7
SEZIONE 4 Import and Validate Data DOMANDA DI CAMPIONE 21 0 21
SEZIONE 5 Creating Grouping and Subtotals DOMANDA DI CAMPIONE 8 0 8
SEZIONE 6 Form Controls DOMANDA DI CAMPIONE 8 0 8
Statistical Analysis 17 0 17
Business Modelling 17 0 17
PivotTables and slicers 20 0 20
Advanced and Pivot Charts 31 0 31
SEZIONE 1 Advanced Charts DOMANDA DI CAMPIONE 16 0 16
SEZIONE 2 Pivot Charts DOMANDA DI CAMPIONE 6 0 6
SEZIONE 3 Trendlines DOMANDA DI CAMPIONE 4 0 4
SEZIONE 4 Power View DOMANDA DI CAMPIONE 5 0 5
Power Maps 26 0 26
Get and Transform with Excel - Power Query 19 0 19
PowerPivot 13 0 13
Cube Functions 5 7 12
DAX functions 0 11 11
Share - Publish - Save as 31 7 38

TEST4U premium quality
Controlla la qualità delle nostre domande Inserisci il tuo indirizzo e-mail qui sotto e ti invieremo immediatamente 55 domande


Avviso di prezzo diminuito

Vi informeremo non appena il prezzo di questo prodotto diminuirà.