Excel Skills for Business by Macquarie University

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

Fiddling around in Excel sheets just doesn’t suit a digital jedi. In Switzerland, PwC’s Digital Upskilling Academy helps our people move from zero to digital hero. PwC is upskilling 284,000 people because the right digital skills make us agile, adaptable and fit for the future. We use powerful Data Analytics tools to help solve business problems.

Sri Venkateshwara University (SVU) strives to create professionals who are not only adept in academics but also in application for the benefit of humanity. We foster a culture of learning by doing. We believe in nurturing students who are at the forefront of innovation by offering an environment of research & development to make us Best University in Uttar Pradesh (UP). SVU believes in experiential learning. To facilitate this, we have an ultra-modern infrastructure that motivates students to experiment & excel in their area of interest. The Best University of Moradabad has laboratories & workshops that signify our commitment to core research, thus enabling innovation. SVU is the only institution to have set up labs in collaboration with the industry. This way we can train our students on the latest skills & make them employable. Students sharpen their practical skills under the watch full eyes of trainers & become competent professionals. For the overall development of the students, we organize cultural programs. Students take part in these programs & exhibit their talent to become confident professionals. The annual fest attracts students from all over the country & showcase their talent to make us the Top University in India. We equipped the computing labs with the latest software & hardware to augment the technical skills of the students. SVU’s library is an epitome of knowledge. It has over 3000 books & journals that ensure the students are never short on intellectual input. The team of industry trainers educate them on the key skills so crucial for employment & make us the Best University in Gajraula. The specially created engineering labs assist engineers to refine their technical acumen so much needed for the country. The Chairman Dr. Sudhir Giri believes in removing all the economic & social barriers that can hinder education. Hence, SVU provides many scholarships & grants to meritorious students. Up till now, the college has enabled over 500000 students to attain their academic desires to make us the Best Private University in Uttar Pradesh (UP). The group is running a dozen educational institutions that include medical colleges in India & abroad. Our commitment towards education & healthcare has enabled Dr Sudhir Giri to win the International Glory Man of the year Award 2021. The Best Private University in Moradabad is on the Delhi Moradabad highway, well connected with rail & road. The green surroundings provide peace of mind that enables research based learning. The carefully recruited faculty is the pride of the university. They have years of industrial & academic experience so vital for the students. They transfer key skills & make us the Best Private University in Gajraula. The faculty encourages students to undertake research & sharpen their skills that will enable them to get jobs. Majority of the faculty members are doctorates who educate the students to become competent professionals. The faculty takes part in FDP in order to develop a culture of research. The specialty of SVU is the internship. We have partnered with leading industries for providing internship to the students. We believe that education without applicability is incomplete. Students gain hands on exposure through internship & become job ready. We place most of the students during internship to make us the Top University in India. SVU, the Best University in Uttar Pradesh (UP), adopts a futuristic teaching pedagogy. We strive for experiential learning of our students through role plays, projects & presentation. The students take part in the learning activity & imbibe concepts that enable their placements. The AC seminar & conference halls allow knowledge dispersion for the development of the students. The University is running over 150 undergraduate (UG), postgraduate (PG) courses, (Ph.D.), diploma and certificate courses in various fields of Applied Sciences, Medical Science, Humanities & Social Sciences. We also run courses in Languages, Design, Agriculture, Engineering & Technology, Nursing, Pharmacy, Paramedical, Commerce & Management, Law, Library & information Sciences, Mass Comm. & Journalism to enhance the employability of the youth. SVU has a culture of project based learning. Students do projects in each semester under the guidance of faculty. They complete these projects in earmarked industries to garner hands-on skills. Through these projects, we train students on the hot skills so crucial for employment to make us the Best University in Moradabad. SVU’s Research & Development (R&D) wing encourages students to work on research areas important for the country. We have partnered with leading research institutions to undertake research. The breath-taking infrastructure of the best university in Gajraula motivates researchers to achieve their goals for research. Owing to our dedication, SVU has received grants from GOI for research on areas of national importance. The faculty members provide guidance to the scholars until they achieve their aim. We have set up the incubation center to provide fillip to new ideas that foster entrepreneurship. We want to be an institution that supports the ‘Make in India’ vision of the government. The center supports new ideas that enable the young entrepreneurs to create startups & become successful. Under the strong leadership of Dr. Sudhir Giri, till date we have successfully incubated 150 start-ups. This speaks of our exemplary education & make us the Best Private University in Uttar Pradesh (UP). These startups are not only creating wealth but also providing employment to the needy. The industrialists have lamented that the epicenter for entrepreneurship will be the educational institutions. We need to provide them with the support & infrastructure for this. The annual hackathon attracts individuals who showcase their business acumen to make us the Best Private University in Moradabad. SVU has a dedicated International Research & collaboration Cell (IRCC) that collaborates with universities abroad. Faculty & students who want to pursue studies abroad the IRCC starts admission formalities for them. We have partnered with reputed institutions for providing excellent research collaborations. Those who wish to do P. HD abroad the IRCC help them gain admission & make us the Top University in India. A lot of our faculty members are pursuing their research internationally & contributing to the welfare of humanity. SVU strives to make our students feel comfortable at the campus. Separate hostel for boys & girls with 24 hour security is available at SVU. The cafeteria serves nutritious food to the students. Gym, recreation hall & the sports ground help to relax our students & make us the Best University in Uttar Pradesh (UP). The campus has an in house ATM & convenience store for the benefit of the students. SVU enables placement through exemplary training. We train on communication & interpersonal skills in order to refine the personality of the students. We make them practice mock interviews & group discussion that help to clear placement tests. Ninety percent of the students get placed before their last semester to make us the best university in Moradabad. We have hired industrial trainers in order to provide training on block chain, machine learning, artificial intelligence (AI), and python & data science. These trainers have years of experience that enables them in training the students. The students gain key insights on these technologies & sharpen their acumen to make us the Best University in Gajraula.

In this Specialization, learners develop advanced Excel Skills for Business. Upon completing the four courses in this Specialization, learners can design sophisticated spreadsheets, including professional dashboards, and perform complex calculations using advanced Excel features and techniques. Learners have acquired the skills to manage large datasets efficiently, extract meaningful information from datasets, present data and extract information effectively. In addition, learners have mastered the skills needed to validate data and prevent errors in spreadsheets, create automation, apply advanced formulas and conditional logic to help make decisions and create spreadsheets that help forecast and model data.

Final Project : Project based on a real life Business Problem. In this Project, you will be using all the skills that you have acquired throughout this course. Problem Statement Your client is a retail banking institution. Term deposits are a major source of income for a bank. A term deposit is a cash investment held at a financial institution. Your money is invested for an agreed rate of interest over a fixed amount of time, or term. The bank has various outreach plans to sell term deposits to their customers such as email marketing, advertisements, telephonic marketing and digital marketing. Telephonic marketing campaigns still remain one of the most effective way to reach out to people. However, they require huge investment as large call centers are hired to actually execute these campaigns. Hence, it is crucial to identify the customers most likely to convert beforehand so that they can be specifically targeted via call. You are provided with the client data such as : age of the client, their job type, their marital status, etc. Along with the client data, you are also provided with the information of the call such as the duration of the call, day and month of the call, etc. Given this information, your task is to predict if the client will subscribe to term deposit. Data You are provided with following files: 1. train.csv : Use this dataset to train the model. This file contains all the client and call details as well as the target variable “subscribed”. You have to train your model using this file. 2. test.csv : Use the trained model to predict whether a new set of clients will subscribe the term deposit. Data Dictionary Here is the description of all the variables : Variable Definition ID Unique client ID age Age of the client job Type of job marital Marital status of the client education Education level default Credit in default. housing Housing loan loan Personal loan contact Type of communication month Contact month day_of_week Day of week of contact duration Contact duration campaign number of contacts performed during this campaign to the client pdays number of days that passed by after the client was last contacted previous number of contacts performed before this campaign poutcome outcome of the previous marketing campaign Subscribed (target) has the client subscribed a term deposit? How good are your predictions? Evaluation Metric The Evaluation metric for this competition is accuracy. Solution Checker You can use solution_checker.xlsx to generate score (accuracy) of your predictions. This is an excel sheet where you are provided with the test IDs and you have to submit your predictions in the “subscribed” column. Below are the steps to submit your predictions and generate score: a. Save the predictions on test.csv file in a new csv file. b. Open the generated csv file, copy the predictions and paste them in the subscribed column of solution_checker.xlsx file. c. Your score will be generated automatically and will be shown in Your Accuracy Score column You can also check out the baseline Python Notebook provided to get started.

This course introduces the technical skills required for data-driven analysis of business and financial data. Emphasis is placed on applying statistical methods to summarize and make inferences from complex data and to develop quantitative models to assist business decision making. The software packages Excel and R will be used to obtain quantitative solutions to financial problems. Topics include: understanding the concept of risk, portfolio construction and analysis, regression and time series models used in finance and simulation techniques.

Position Description The Report Developer will be a key member of a team responsible for implementing a critical reporting initiative. The individual will work with a team in IT to create key financial and operating metrics. Responsibilities include report development, dashboard development, and assisting the business with data requests and analysis. Report and dashboard development requirements will span across multiple systems and will include integration of data from multiple sources. Responsibilities • Design and implement enterprise reporting and business intelligence solutions. • Gather requirements from business users. • Prepare ad hoc customer, product, and labor analysis. • Dashboard development using Dundas Data Visualization software. • Report development using Microsoft SQL Server Reporting Services (SSRS). • ETL using SQL Server Integration Services (SSIS). • Set up routines within SQL Server to consolidate data from multiple data sources. • Maintain data marts of extracted data. • Conceptual, logical and physical data modeling. • Develop optimized stored procedures. Required experience and attributes • At least 3 years of experience in software development and database design, with emphasis on the SQL Server 2008 (primarily SSRS and SSIS). • Solid experience with MS SQL Server development (stored procedures, views, triggers, functions, query optimization). • Experience with web and browser based applications and technologies. • Attention to detail and possession of a *data stewardship* attitude. • Strong problem solving skills. • Ability to write stored procedures and complex SSIS packages. • Proficient with Microsoft Excel, especially pivot tables, reports, and charts. • Self-motivated and a high degree of intellectual curiosity. • Demonstrated organizational skills & ability to multi-task in a fast-paced environment with competing priorities. • Financial and Operating metrics reporting experience a plus!

Completed Goldman Sachs' Excel & Spreadsheets Certification program, mastering essential skills and tools used by professionals in transformative deals and business projects worth hundreds of billions of dollars.

This project is ideal for demonstrating data analytics skills in HR Analytics requiring Excel proficiency and business problem solving

This repository contains real-world Excel projects focused on data cleaning, analysis, and visualization. Includes dashboards, pivot tables, formulas like VLOOKUP, IF, and automation with macros. Great for showcasing practical Excel skills in business and data-driven scenarios.

This project presents an end-to-end analysis and solution for a real-world business case focused on **reducing Total Order Time** and **improving delivery efficiency** in a fast-growing foodtech startup. It demonstrates strong data analysis, business insight generation, and dashboarding skills using Excel and Power BI.

📊 A complete Data Analytics Portfolio 🚀 showcasing projects in Excel 📊, SQL 🗄️, Python 🐍, Power BI 📈, and Machine Learning 🤖. Includes real‑world case studies on sales 🛍️, HR 👥, insurance 💰, and AI assistants 🤖. Designed for recruiters & collaborators to explore skills, insights, and business impact.

Md Mehraj Hossain Known as an Musical Artist and Founder of GM STUDIO . aged 19 . he lives in Dhaka Bangladesh with his family. Who Is Md Mehraj Hossain ? Md Mehraj Hossain is an Businessman and an music artist also. he started online business company named GM STUDIO at 2020. he is the Founder of this company and his family member also included this company managers. He has also an Musical Studio Named GM STUDIO at 2021. after his collage study has complete he starting singing and record from his won company. he has released so many song. What Is GM STUDIO  ? GM STUDIO is a online business/ Online Shopping Services. Md Mehraj Hossain are Founder of this company. he started this company at 2020.Its Located also in Dhaka Bangladesh. his family member also included into this company. his brother named Ashraful Islam is the Co-Founder of this company and the managed the London brunch from London. his brother lives in London. Mehraj's company specializes in all internet marketing fields ranging from celebrity management, internet marketing for upcoming and established businesses, individual long term or short term internet marketing, and entertainment marketing via the internet. Services that the company offers include SEO (Search Engine Optimization), Internet Marketing Services, Link Building, Remarketing, Content Writing, and Dynamo logic Services. What Is GM STUDIO ? GM STUDIO is a Music video/Audio Recording Studio and also Music makes. Md Mehraj Hossainl also fonder on this studio. he started this studio at 2021 for recording his own music. he recorded so many music on his studio and he published all of this music on all platform. Since then, his every project has been handled by implementing innovative strategies which has sky-rocketed his clients' businesses in an astounding manner. Today, Md Mehraj Hossain has become an expert in the social media field where many even call him a Mehraj Media . He excelled in the field of social media marketing with his intelligence, skills & talent. His associations with some of the leading media firms helped Mehraj build a stronger contact list which drove him much closer to his journey towards the same.

No description available

This repository collects all of the assessments from Coursera's 'Excel Skills for Business' course

Excel Skills for Business Forecasting Specialization

Repository for Excel Skills with Business Specialisation by Coursera.

Repository for Excel Skills with Business Specialisation by Coursera

Excel Skills for Business practice repository with assignments, projects, and examples (Macquarie University – Coursera)

In this repository, I share my projects and assignments that I completed in the field of Excel Skills for Business Forecasting.

"Dynamic Superstore Excel Dashboard showcasing sales, profit, and customer insights with interactive charts and KPIs. Designed for real-world business analysis, reporting, and data-driven decision making. Ideal for demonstrating advanced Excel skills and analytical expertise."

Sales Performance Dashboard - Excel Analysis Interactive Excel dashboard featuring pivot tables, advanced formulas, and dynamic charts. Demonstrates data cleaning, KPI tracking, and visualization skills to transform raw sales data into actionable business insights for strategic decision-making.

An interactive Excel dashboard analyzing coffee sales data for a fictional online shop, Daily Grind Coffee Co. Includes a professional report summarizing key findings and recommendations. This project highlights data cleaning, pivot tables, advanced Excel skills, and actionable business insights.

End-to-end Excel sales analytics project for Ferns & Petals using Power Query, Power Pivot, Pivot Tables, DAX, and dashboard design to demonstrate ETL, data modeling, retail analytics, and business insight storytelling skills.

Interactive Superstore Sales Dashboard built with Excel and Power BI. Analyzes sales, profit, delivery time, and category trends across regions. Designed to showcase data storytelling, visualization skills, and business insight for analytics roles.

Built an Excel project applying IF and logical formulas to real-world sales data. Implemented single and multi-column conditions to flag high sales, bulk orders, discounts, regional trends, customer loyalty, and product-category insights. Strengthened Excel skills for business rule validation and data analysis.

This project focuses on analyzing retail sales data using Microsoft Excel. The goal is to transform raw sales data into meaningful business insights through data cleaning, calculations, pivot tables, and charts. The project demonstrates practical Excel skills commonly required for data analyst internships and entry-level roles.

Repository showcasing data analytics projects completed through PwC's Power Data Analytics Tasks. Includes end-to-end analysis using Excel, SQL, Tableau and Power BI across case studies. Demonstrates data visualization, manipulation skills for business insights.

This repository contains data analysis and visualization projects, including an Amazon sales dashboard and Power BI dashboards. It showcases skills in using Excel Flash Fill for data transformation and calculating total sales to inform business decisions.