Udemybeginneres

Inteligencia de Negocio para el análisis de Datos con Excel

Learn to make data-driven decisions! Go beyond opinions and unlock insights with data analysis. Improve your understanding and make better choices.

4.3(277)
10,281students
1h 59m
Certificate
Jefersson Jimenez
Jefersson JimenezArtificial intelligence ...

Course Content

Inteligencia de Negocio para el análisis de Datos con Excel is a beginner-level Udemy course taught by Jefersson Jimenez. It runs 1h 59m, is taught in Spanish, and includes a certificate of completion. Learners rate it 4.3 out of 5 from 277 reviews, with 10,281 students enrolled. It is a paid course, first published November 2019.

Unlock powerful data analysis skills with this comprehensive course! Master essential Excel functions and techniques to streamline your work and gain valuable insights.

  • Data Manipulation & Calculation: Learn to count and concatenate data effectively. Calculate averages with PROMEDIO.SI and perform conditional summing using SUMAR.SI.
  • Advanced Lookup Functions: Become proficient with BUSCARV and BUSCARH for efficient data retrieval.
  • Logical Functions: Develop your skills in decision-making with SI, Y, and O functions.
  • Automation & Problem Solving: Create automatic forms to simplify data entry and leverage the Solver tool to find optimal solutions. Utilize COINCIDIR for precise data matching.
  • Mathematical Functions: Explore essential functions like ABS (absolute value) and ALEATORIO (random number generation).
  • Date & Time Calculations: Master date calculations with BDCONTAR and DIAS.LAB.INT.
  • Scenario Management: Effectively manage and compare different scenarios using the Scenario Manager.
  • Linear Equations & Projections: Understand and apply the equation of a line and its projection for data analysis.
  • Boosting Productivity: Discover strategies to enhance your productivity and understand key metrics like the productivity index.
  • Forecasting & Seasonality: Learn to create accurate forecasts with seasonality incorporated.
  • Descriptive Statistics: Gain a solid understanding of descriptive statistics to summarize and interpret data.
  • Financial Indicators: Analyze key financial indicators to assess business performance.
  • Financial Ratio Analysis: Perform crucial acid-test ratios, calculate gross margin, and determine the break-even point.
  • Inventory & Asset Management: Understand and calculate inventory turnover and portfolio turnover.
  • Investment Evaluation: Learn to evaluate investment opportunities using a robot-based approach.
  • And Much More! This course covers a wide range of topics to elevate your data analysis capabilities.
$ whoami — the devs behind tutorialsearch.io

Need a SaaS MVP shipped fast? Hire the TutorialSearch.io team

Auth, billing, dashboards and AI features — a launch-ready product built by the devs behind this site.

Prográmate para incrementar tus ingresos

by Juan Antonio Guerrero Cañongo

5.0(172)
1h 34m
beginner
5.0(7)
8h 41m
beginner
5.0(48)
6h 10m
beginner
5.0(19)
13h 22m
intermediate