This project demonstrates a Data Analyst Portfolio Project using Microsoft Excel. It analyzes an E-commerce sales dataset and presents insights in a professional dashboard with key business KPIs.

I loaded the csv file into Excel and conducted EDA, using statistical analysis and Pivot charts. There are 1000 customers. The average transaction value is £456 I calculated the average age for ...

So, select any cell in your formatted Excel table, and in the Insert Tab on the ribbon, click the top half of the split ...

Discover how to use free AI tools like ChatGPT and DAX Studio to create smarter, faster, and more advanced Power BI ...

Array formulas let you perform calculations across entire ranges of data in a single formula. Hence, you can handle lightning-fast lookups, filtering, and sorting with just one po ...

Discover essential Excel hacks to save time, boost productivity, and simplify your workflow. Perfect for beginners and pros ...

Claim this complimentary eBook worth $50 for free, before the offer ends on Sep 16.

The Office Master course is your ticket to mastering Microsoft Power BI, helping you create stunning reports fast and boost ...