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.
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.SIand perform conditional summing usingSUMAR.SI. - Advanced Lookup Functions: Become proficient with
BUSCARVandBUSCARHfor efficient data retrieval. - Logical Functions: Develop your skills in decision-making with
SI,Y, andOfunctions. - Automation & Problem Solving: Create automatic forms to simplify data entry and leverage the Solver tool to find optimal solutions. Utilize
COINCIDIRfor precise data matching. - Mathematical Functions: Explore essential functions like
ABS(absolute value) andALEATORIO(random number generation). - Date & Time Calculations: Master date calculations with
BDCONTARandDIAS.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.
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.