Planilha de Estudos para concurso publico feito no Excel varias fรณrmulas como: SE, SOMASE, PROCV, PROCH, CORRESP, SEERRO,, SUBTOTAL . Tambรฉm usado Macros e VBA
-
Updated
Mar 17, 2024
Planilha de Estudos para concurso publico feito no Excel varias fรณrmulas como: SE, SOMASE, PROCV, PROCH, CORRESP, SEERRO,, SUBTOTAL . Tambรฉm usado Macros e VBA
Dragonfly Analyzer is a tool that automatically compiles and generates statistical reports based on field observations of dragonflies. Co-developed with @lbrezgin.
Data cleaning and insight generation using Kaggle Data Science Survey 2017-2021.
Interactive HR Recruitment Analytics Dashboard built in Excel to analyze hiring trends, evaluate candidate profiles, compare candidates, and estimate hiring probability using data-driven insights.
Excel-based crash incident analysis (2019โ2023) with data cleaning, pivot tables, visualizations, and an interactive dashboard.
This project includes Data Analysis using excel.
This project presents an analytical study of customer churn behavior using Microsoft Excel. The main objective is to identify patterns and drivers behind customer churn and provide actionable insights to improve customer retention and profitability. The analysis is performed entirely in Microsoft Excell.
This is my first Excel project: Vrinda Store Data.
Deloitte Australia Data Analytics Job Simulation (Forage) โ Gender pay equality analysis using Excel classification logic and Tableau dashboard visualization. Includes forensic data assessment and business insights.
A Streamlit-based tool for analyzing financial documents (CSV, Excel, PDF) with automated KPI extraction, statistical analysis, and interactive visualizations to help professionals gain quick insights.
"Retail Sales Analysis & Inventory Risk Modeling using MS Excel. Features advanced Pivot Tables, Multiple Linear "Regression and Correlation Analysis to optimize boutique revenue and markdown strategies."
This is excel analytics platform.
The Crowdfunding-Analysis with Excel project analyzes 1,000 crowdfunding projects and concludes that the US, theater, film and video, and music industries have the most campaigns, with a success rate of 50-60%. The dataset lacks some key data points such as gender and age of backers and distribution of campaigns across different US states.
Using shadcn ui made a Excel analysis Dashboard
A data-driven pricing optimization project using Excel and Python to increase revenue while adhering to business constraints.
This project analyzes sales performance of a coffee store between 2019 and 2022 using Microsoft Excel for data analysis and visualization, with final results presented in Microsoft PowerPoint. The objective was to track sales trends, evaluate product performance, and identify customer insights that could support long-term strategic growth.
Excel Dashboard to analyze data of a hotel over the past three years.
๐ Raw Sales Data โ ๐งน Clean & Transform โ ๐ Model Relationships โ ๐งฎ Build KPIs โ ๐ Visualize Dashboard โ ๐ฏ Analyze Trends โ ๐ก Generate Insights โ ๐ Drive Business Decisions
Analyzed a Starbucks dataset to evaluate marketing promotions using A/B Testing and Statistical Significance. I calculated P-values and "Lift" in Excel to determine offer effectiveness, then built Tableau dashboards to visualize customer conversion. This project demonstrates data-driven decision-making to optimize marketing ROI.
Add a description, image, and links to the excel-analysis topic page so that developers can more easily learn about it.
To associate your repository with the excel-analysis topic, visit your repo's landing page and select "manage topics."