This Repository Contains Solution to the Assignments of Excel Skills For Business - Macquarie-University on Coursera Taught by Nicky Bull, Dr Prashan S. M. Karunaratne, Professor Yvonne Breyer
-
Updated
Jun 17, 2024
This Repository Contains Solution to the Assignments of Excel Skills For Business - Macquarie-University on Coursera Taught by Nicky Bull, Dr Prashan S. M. Karunaratne, Professor Yvonne Breyer
A sample server with Flexmonster Accelerator as a DLL
Dashboard with useful KPI shown, created using pivot table and pivot chart
Mastered Excel Pivot Tables with a comprehensive Udemy course. Enhanced data analysis skills, learned advanced functionalities, and gained proficiency in creating dynamic and insightful reports.
RevoGrid Pivot: multidimensional analytics, drill-down, totals, filtering, charts, and four framework examples.
"Excel BootCamp: A comprehensive guide covering essential Excel functions, formulas, data analysis, and automation techniques. Perfect for beginners and professionals looking to enhance their Excel skills!"
Career Aspiration Of Gen-Z ,To explore the industries, roles, and pathways using Excel .
📊 Excel Projects Portfolio – A collection of 5 projects showcasing skills from basic formulas to advanced dashboards using Excel, Pivot Tables, Power Query and Power Pivot. Includes Payroll System, Advanced Charts, Student Marksheet, and Interactive Sales Dashboards.
Interactive Excel sales dashboard built with PivotTables, PivotCharts, and Slicers.
n interactive Sales Performance Dashboard built in Microsoft Excel using Pivot Tables, Pivot Charts, Slicers, Conditional Formatting, and KPI analysis to evaluate sales executives' performance against targets.
Interactive Microsoft Excel dashboard analyzing Apple product pricing, discounts, ratings, inventory, and sales events (2020–2026).
Finding out potential target customers for personal loans using HBFC data.
Excel assignment covering conditional formatting, formulas, PivotTables, and PivotCharts (Due: 03-06-2021)
Interactive Sales & Accounting Dashboard built in Microsoft Excel using Power Query, Pivot Tables, Pivot Charts and accounting automation.
Excel dashboard analyzing 1,500 global AI job postings across 50 countries. Explores salary by experience, continent and specialization, remote work, automation risk and job growth using formula-driven KPIs, charts and a Calculation sheet.
Interactive Excel Sales Performance Dashboard built with Pivot Tables, Pivot Charts, KPI Cards, Slicers, and Dynamic Filtering using the Superstore dataset.
Dashboard of road accidents occured during the period of 2021-22 with different reasons behind. Using Ms excel for the data processing and creating pivot tables , using fucntions and may more features of excel to create the final dashboard to give quick overview of data
Using Excel to Analyse and Visualize Data
Interactive Excel sales dashboard built using the Superstore dataset. Analyzes revenue trends, YoY growth, seasonality, and sales distribution across categories and regions. Features dynamic KPIs, pivot charts, slicers, and a business-focused dashboard design using Excel only.
Over $2 billion was raised using the successful crowdsourcing service, Kickstarter, but not every campaign found success. Crowdfunding Campaigns were analyzed to determine what led to success.
To associate your repository with the pivot-charts topic, visit your repo's landing page and select "manage topics."