* Cantinho Satkeys

Refresh History
  • FELISCUNHA: dgtgtr   49E09B4F  e bom fim de semana   4tj97u<z
    15 de Fevereiro de 2025, 16:34
  • j.s.: tenham um excelente fim de semana  49E09B4F
    14 de Fevereiro de 2025, 17:06
  • j.s.: dgtgtr a todos  4tj97u<z
    14 de Fevereiro de 2025, 17:06
  • FELISCUNHA: ghyt74  pessoal   49E09B4F
    14 de Fevereiro de 2025, 11:24
  • cereal killa: ghyt74 pessoal  classic
    14 de Fevereiro de 2025, 10:08
  • JPratas: try65hytr Pessoal  classic k7y8j0 h7ft6l
    14 de Fevereiro de 2025, 03:52
  • JPratas: dgtgtr A Todos  4tj97u<z k7y8j0 yu7gh8
    13 de Fevereiro de 2025, 18:08
  • FELISCUNHA: ghyt74  pessoal   49E09B4F
    13 de Fevereiro de 2025, 11:32
  • j.s.: try65hytr a todos  4tj97u<z
    12 de Fevereiro de 2025, 21:00
  • FELISCUNHA: ghyt74   49E09B4F  e bom fim de semana  4tj97u<z
    08 de Fevereiro de 2025, 11:36
  • j.s.: tenham um excelente fim de semana  43e5r6 49E09B4F
    07 de Fevereiro de 2025, 20:23
  • j.s.: try65hytr a todos  4tj97u<z
    07 de Fevereiro de 2025, 20:23
  • FELISCUNHA: ghyt74  pessoal   49E09B4F
    07 de Fevereiro de 2025, 11:24
  • JPratas: try65hytr A Todos  4tj97u<z classic k7y8j0
    07 de Fevereiro de 2025, 04:15
  • j.s.: dgtgtr a todos  49E09B4F
    06 de Fevereiro de 2025, 14:24
  • FELISCUNHA: ghyt74  pessoal   49E09B4F
    05 de Fevereiro de 2025, 11:33
  • JPratas: try65hytr Pessoal  4tj97u<z classic k7y8j0
    05 de Fevereiro de 2025, 02:35
  • FELISCUNHA: ghyt74   49E09B4F  e bom fim de semana   4tj97u<z
    01 de Fevereiro de 2025, 11:59
  • j.s.: tenham um excelente fim de semana  49E09B4F
    31 de Janeiro de 2025, 21:20
  • j.s.: try65hytr a todos  4tj97u<z
    31 de Janeiro de 2025, 21:20

Autor Tópico: Mastering Data Analysis in Excel  (Lida 342 vezes)

0 Membros e 1 Visitante estão a ver este tópico.

Offline mitsumi

  • Moderador Global
  • ***
  • Mensagens: 118061
  • Karma: +0/-0
Mastering Data Analysis in Excel
« em: 16 de Junho de 2019, 14:55 »

Mastering Data Analysis in Excel
.MP4 | Video: 1280x720, 30 fps(r) | Audio: AAC, 48000 Hz, 2ch | 2.45 GB
Duration: 3.5 hours | Genre: eLearning Video | Language: English
Learn advanced tools and techniques for business data analysis in Excel using PivotTable, PivotChart and much more.

What you'll learn

    Working with real-world data and solving real-world tasks
    Turning data into business insights for decision-making
    Cleaning and preparing data for further analysis
    Using the important functions in Excel (Logical, Text, Date, Math, Statistical)
    Calculating descriptive statistics and relationship between sets
    Combining data from multiply tables by VLOOKUP, INDEX and MATCH functions
    Analyzing data using PivotTable and PivotChart tools
    Performing what-if analysis by Goal Seek, Data Table and Scenario Manager tools
    Visualizing data and preparing interactive dashboards
    Working in Excel by using hot shortcuts

Requirements

    Basic knowledge of Excel

Description

3.5 hours professional course for everyone who wants to learn essentials of data analysis and visualization in Excel and become an advanced Excel user. All what you need to be able to:

     - work with large data sets,

     - clean and prepare data for further analysis,

     - combine data from multiply sheets using Vlookup, Index and Match functions,

     - perform advanced calculations and sensitivity analysis,

     - summarize values by different techniques,

     - analyze data using Pivot Table, Pivot Chart, Slicer,

     - visualize your results and prepare interactive dashboards,

     - turn data into useful insights.

All this we will do on the real-world data and will solve real-world tasks. You don't need to spend weeks and months to learn Excel. Start now, take all the steps with me, and in a few days you will feel very comfortable working in Excel and solving tasks in your job.

Good luck!

Who this course is for:

    Business analysts, Data analysts, Financial analysts, Reporting specialists
       

               

Download link:
Só visivel para registados e com resposta ao tópico.

Only visible to registered and with a reply to the topic.

Links are Interchangeable - No Password - Single Extraction