Excel Course for Data Analysis

CURS-667

New product

Learn to know different tools, which through the organization and classification of data, will allow you to generate and cross information, improving accounting and financial management processes.

Excel Course for Data Analysis


Excel allows you to automate procedures to collect, transform and analyze information. With this course you will be able to know different tools, that by means of the organization and classification of data, will allow you to generate and cross information, improving accounting and financial management processes.

Advertising.

WITH THIS COURSE YOU WILL BE ABLE TO:

Build Databases
Cross information
Analyze dynamic tables
Automate procedures
Prepare budgets
Create dynamic graphs


COURSE SUBJECT
1. Introduction to the course

Welcome to the course

2. How does Microsoft Excel think?

Feel comfortable with the menu bar
Know the structure of an Excel workbook
Protecting information in Excel
Simple drop-down lists
Dependable drop-down lists
Print in Excel? It will not be a problem anymore
Reinforce together several concepts
Challenge: Table and formats

3. Preparing the information

Databases
Separate text and then join it
Basic formulas (numerical and text)
Text formulas
Sumar.si and Average.if
Name ranges and make operations
Weighted average and data fixation
Practice the weighted average
Special Stuck
What is SearchV?
SearchV applied
Formulate your own SearchV
Now, what is SearchH?
Practice the Search
Conditional formulas. What are they?
Essential conditional formulas

4. Analyzing the information

Conditional formats
Traffic lights, color cells and formulation
Dynamic tables
Types of graphics and their different uses
Simple graphics
Dynamic graphics
Formulation with dynamic tables
Management model gathering knowledge
Find target
Macros - writing and understanding code
Macros - recording macros
Closure of the course
Exam preparation


Technical data:

Format: .MP4
Resolution: 1280x800p
Size: 2.99 GB
Spanish Language
Formators: Felipe Guzmán
Content: 04 Modules
Duration: 3h 45m
Fitness level: Beginner - Intermediate
Company: Platzi

See Captures

capture curso de excel para el analisis de datos

Totally free of viruses and malicious software, so do not wait any longer to download it now.

Do not forget to give us an opinion about the course, to improve the content.

Advertising.

Download Excel Course for Free Data Analysis


DOWNLOAD FREE HERE

Do you want to see our Full Free Course Gallery available?


To see our course gallery click here

FREE COURSES GALLERY

Follow us on our social networks


siguenos en instagran intarcesoft

NOTE: Do not forget to follow us on our facebook and twitter social networks so that you become part of our community and receive the notification every time we post something new, so you will not miss anything.

Grade 
07/19/2019

Excelente

gRAN CURSO

    Write your review!

    Write a review

    Excel Course for Data Analysis

    Excel Course for Data Analysis

    Learn to know different tools, which through the organization and classification of data, will allow you to generate and cross information, improving accounting and financial management processes.

    Ask a question

    NO registration required!

    If the question you have has not yet been answered here, use the form below to ask something about this addon.

    (optional)
    *(Required to be notified when an answer is available)

    If the download link redirects to another product that is not described in the article or is broken, report it using our Reporting Form

    Cargando...