Excel Skills for Business

In this first course of the specialization, 'Excel Skills for Business: Essentials', you will master the fundamental capabilities of Microsoft Excel. Over six weeks, you will gain the confidence to expertly navigate the Excel user interface, perform essential calculations using formulas and functions, professionally format spreadsheets, and create impactful data visualizations with charts and graphs. This course is designed for aspiring business professionals, students, and anyone looking to enhance their digital skills. Whether you are new to Excel or self-taught and aiming to solidify your foundational knowledge for greater efficiency and productivity, this program provides a robust starting point. You will solve a variety of practical business problems, applying learned Excel skills and techniques through downloadable workbooks and real-world data sets. To succeed in this course, no prior Excel experience is required. You will develop highly valuable spreadsheet software skills, positioning yourself for success in today's rapidly evolving digital job market.

This advanced Excel course is designed for business professionals, data analysts, and financial analysts seeking to master complex spreadsheet software for data-driven decision-making. Building on foundational Excel skills, this program will transform you into a power user, enhancing your employability and positioning you ahead in a rapidly evolving digital job market. (Source: World Economic Forum 2023 Future of Jobs Report). By the end of this course, you will be able to: - Master advanced Excel formulas and lookup functions for efficient data handling. - Clean and prepare complex data for robust analysis using Microsoft Excel. - Apply financial functions and date formulas for business calculations and reporting. - Design and build professional, interactive dashboards in Excel for business intelligence. To be successful, you should have completed the Excel Skills for Business: Essentials, Intermediate I, and Intermediate II courses, or possess equivalent intermediate Microsoft Excel proficiency.

Spreadsheet software remains one of the most ubiquitous pieces of software used in workplaces across the world. Learning to confidently operate this software means adding a highly valuable asset to your employability portfolio. In the United States alone, millions of job advertisements requiring Excel skills are posted every day. Research by Burning Glass Technologies and Capital One shows that digitals skills lead to higher income and better employment opportunities at a time when digital skills job are growing much faster than non-digital jobs. In this second course of our Excel specialization Excel Skills for Business you will build on the strong foundations of the Essentials course. Intermediate Skills I will expand your Excel knowledge to new horizons. You are going to discover a whole range of skills and techniques that will become a standard component of your everyday use of Excel. In this course, you will build a solid layer of more advanced skills so you can manage large datasets and create meaningful reports. These key techniques and tools will allow you to add a sophisticated layer of automation and efficiency to your everyday tasks in Excel. Once again, we have brought together a great teaching team that will be with you every step of the way. Prashan and Nicky will guide you through each week (and I am even going to make a guest appearance in Week 5 to help you learn about my favourite tool in Excel - shh, no spoilers!). Work through each new challenge step-by-step and in no time you will surprise yourself by how far you have come. This time around, we are going to follow Uma's trials and tribulations as she is trying to find her feet in a new position in the fictitious company PushPin. For those of you who have done the Essentials course, you will already be familiar with the company. Working through her challenges which are all too common ones that we encounter everyday, will help you to more easily relate to the skills and techniques learned in each week and apply them to familiar and new contexts.