End-to-End Data Analysis Projects with Microsoft Excel

Analyze the mini super store dataset in Excel and pivot tables. Convert currency, fill blanks with null, classify sales as high or low, create a dashboard showing revenue and trends.

Learn to build a comprehensive Excel data dashboard from a mini super store dataset, creating and formatting pie and donut charts, cards, pivot tables, a line chart, and slicers.

Analyze data scientist salaries with Excel: use pivot tables and the Data Analysis Toolpak to compute mean, median, and standard deviation, and identify top countries by mean salary.

Select United States, Germany, and United Kingdom for a 2018–2019 salary dataset. Concatenate country and year, then design a box plot of salaries by country to identify outliers.

Develop a dataset of mean salary, years of professional coding, and job satisfaction by country and year, build scatterplots with trend lines in Excel, and compare salary trends across countries.

Compute school xyz students' ages across three years in Excel, calculate per-student totals and averages, determine pass rates with countifs, and identify youngest and oldest graduates.

Master 3D summation and 3D references in Excel to calculate subject totals and averages across three students, and identify each student's favorite subject using index, max, and maximum functions.

Demonstrates calculating gender ratio with countif in Excel, creating charts, and analyzing pass rates by subject across years; identifies top students using conditional formatting and averages.

Analyze sales transaction data by merging transaction details, returns, and regional manager datasets in Excel using Power Query, then apply pivot tables to reveal top managers, regional insights, and profitability.

Explore end-to-end sales data reporting in Excel by calculating revenue and profit. Build a Power Pivot model to uncover monthly revenue trends with a pivot table.

Explore how to build executive sales reports in Excel: identify top products by revenue, percent contribution, top sales teams, and top states with population and median income.

Create an Excel dashboard linked to pivot tables, with slicers by product category and a month timeline for executive sales reporting.

Merge phase one and phase two data with Power Query, unpivot monthly funds, and build pivot tables to compute totals and averages by phase and contractor, and password-protect the workbook.

Create an automated Excel dashboard for Flourish Fish Farm that uses data validation and VLOOKUP to compute price, cost, revenue, and profit per transaction.

Learn to build an end-to-end Excel dashboard for Flourish Fish Farms by creating pivot tables, cards, and charts (bar, pie, donut, line) with slicers by state and month.

Build an end to end excel data analysis dashboard for Tunia Technologies, using pivot tables, charts, and slicers to analyze sales, profits, discounts, and top customers by region and year.

Clean and organize a dirty quick job applicant dataset by structuring columns as seniority level, employment type, job function, and industries, using text to column and replace with not specified.

In Power Query, clean messy job applicant data by removing undesirable characters with text.select, trim spaces, replace empties with not specified, and load the cleaned data back to Excel.

Analyze the 2023 Nigeria presidential poll in Excel using pivot tables to summarize PVC status across six geopolitical zones from 1,000 respondents. Export a png visualization.

Explore end-to-end data analysis in Excel by updating salaries with conditions, generating staff IDs with Power Query, calculating contract end dates, and identifying lay-offs for a 2023 scenario.

Explore RushTech financials in Excel, summing sales and expenses with pivot tables, and build a dashboard with sales and expenses cards, charts, and a monthly dual-line view.

Learn to design and format an Excel dashboard with styled backgrounds and borders, add images and charts, configure slicers and report connections, and build stable totals with formulas.

Explore end to end data analysis of credit card spending in India, including extracting city and month, using pivot tables, and building an interactive dashboard of spending trends.

Design an interactive Excel dashboard to analyze credit card spending by city in India, displaying a spending trend with line charts and male, female, and total expenses, plus slicer filters.

Analyze credit card spending habits in India using pivot tables and dashboards. Link filters to show the top five cities by category such as bills, entertainment, food, grocery, and travel.

Master Excel data analysis by converting data to a table, naming and styling it, adding totals, unpivoting with Power Query, and using VLOOKUP, INDEX MATCH, and nested IF.

Extract masked codes starting with IHS from a Malawi dataset, replace missing codes with not available, and clean the data in Excel using Power Query before loading to a sheet.

Clean, transform, and validate web-scraped Nigerian state population data in Excel using Power Query, splitting combined fields into state and 2006/2019 populations, handling ranks, and calculating year-over-year growth.

Develop Excel proficiency for the UK job test by formatting a dataset, calculating totals and statistics, applying conditional formatting, using VLOOKUP and pivot tables, and creating charts.

Learn to apply a weighted sum in excel to select the best two candidates by balancing cgpa, salary, interview score, and experience with assigned weights.

perform pivot-table analysis of a staff welfare survey in excel, grouping ages in ten-year brackets and summarizing by gender, age group, and department with monthly income and average salary insights.

Build an end-to-end data analysis project in Excel by creating the Vrinda store annual dashboard for 2022, analyzing revenue, orders, gender, age groups, and top states with slicers.

Clean and transform the Rokrai Shipping Company dataset by delimiter-based splitting. Create pivot tables and a zone-filtered dashboard to analyze orders, occupations, and revenue.

Learn to clean and transform Facebook data in Excel using Power Query, extracting date and time, formatting names, dates, and times from thousands of requests while maintaining client confidentiality.

Use Power Query to separate date and time from sales upload records by promoter ID, extract month, and identify top five late submitters by month with a pivot table.

Learn to reconcile a data set with positive and negative amounts in Excel by identifying numbers without opposites, separating positives and negatives, and creating a clean, ordered report.

Clean form entry data in Excel using functions and macro, organizing names, emails, country, phone, and how you heard about us, and automate updates for new records.

Design a sales recording template in Excel or Google Sheets that automates price, quantity, and totals as you select items and payment method (bank or cash), tracking sales and inventory.

Build an end-to-end sales transaction template in Excel that automates item selection, pricing, inventory balance, and monthly totals using data validation, vlookup, and date functions.