Udemyalles

Excel Avanzado Elemental

Master Excel dashboards! Learn pivot tables & functions to visualize data and gain insights. Perfect for beginners.

4.5(47)
1,227students
7h 18m
Certificate
David Calderon Sandoval
David Calderon SandovalBusiness, Technology & Operations

Course Content

Excel Avanzado Elemental is an all-levels Udemy course taught by David Calderon Sandoval. It runs 7h 18m, is taught in Spanish, and includes a certificate of completion. Learners rate it 4.5 out of 5 from 47 reviews, with 1,227 students enrolled. It is a paid course, last updated October 2021.

Unlock the Power of Excel for Data Analysis!

This course provides practical skills in manipulating and analyzing data using powerful Excel tools. You'll transform raw data into actionable insights, making informed decisions for work or studies.

Here's what you'll learn:

  • Excel Fundamentals: Refresh your understanding of essential Excel concepts, including working with tables, ranges, and basic formulas. Perfect for beginners or those needing a refresher.
  • Pivot Tables: Master pivot tables and their dynamic features. Learn to create calculated fields and insightful dynamic charts to summarize and analyze large datasets efficiently.
  • Essential Excel Functions: Dive into fundamental Excel functions, starting with autosum, text functions, and date functions.
  • Logical Functions: Become proficient with logical functions like IF, AND, OR, and IFERROR to create conditional calculations.
  • Lookup & Conditional Functions: Learn to use lookup functions and conditional functions to retrieve and analyze specific data points.
  • Basic Financial Functions: Explore fundamental financial functions to perform essential financial calculations.
  • Nested Formulas: Take your skills to the next level by mastering nested formulas. Solve complex data problems with practical examples using both values and text data formats.
  • Dashboard Creation: Integrate all learned skills to build a professional dashboard. Visualize and present your organization's information clearly and concisely, enabling automated analysis and improved understanding.

By the end of this course, you'll be equipped to confidently handle data analysis tasks in your daily work and studies.

$ whoami — the devs behind tutorialsearch.io

Need a web app built? Hire the team behind TutorialSearch.io

We ship fast, production-grade full-stack apps (Next.js, React, edge infra) — the same stack that powers this site.

5.0(18)
6h 37m
intermediate
5.0(8)
6h 54m
intermediate