About This Specialization
This specialization is intended for anyone who seeks to develop one of the most critical and fundamental digital skills today. 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 digital skills lead to higher income and better employment opportunities. At a time when digital skills jobs are growing much faster than non-digital jobs, completing this specialization will position you way ahead of others.
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.
The best way to learn Excel is to use Excel. In this specialization, learners will solve a broad range of business problems as they apply the Excel skills and techniques they learn along the way. Excel workbooks, quizzes, and challenges provide countless opportunities to practice and use spreadsheet software in a variety of business contexts.
No prior experience required.
Excel Skills for Business: Essentials
6 weeks of study, 2-4 hours per week
About the Course
In this first course of the specialization Excel Skills for Business you will learn the Essentials of Microsoft Excel. Within six weeks, you will learn to expertly navigate the Excel user interface, perform basic calculations with formulas and functions, professionally format spreadsheets, and create visualizations of data through charts and graphs.
Whether you are self-taught and want to fill in the gaps for better efficiency and productivity, or whether you have never used Excel before, this course will set you up with a solid foundation to become a confident user and develop more advanced skills in later courses.
We have brought together a great teaching team that will be with you every step of the way. A broad range of practice quizzes and challenges will provide great opportunities to build up your skillset. Work through each new challenge with our team and in no time you will surprise yourself with how far you have come.
Spreadsheet software is 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. At a time when digital skills jobs are growing much faster than non-digital jobs, make sure to position yourself ahead of the rest by adding Excel skills to your employment portfolio.
Critical Core of Excel
In this module, you will learn about key foundational features of Excel: The Excel user interface, basic Excel terminology, how to operate essential navigational controls in Excel and how to perform basic data entry with Excel spreadsheets.
The syntax of formulas is very important in Excel. In this module, you will get introduced to formulas and functions – learn how to write them, use them to perform calculations and understand the different cell references.
Formatting helps to highlight key messages and make the data presentable. This module covers several formatting tools like font formatting, borders, alignment, number formatting, as well as the Excel styles and themes.
Working with Data
This module is all about working with data – and making it easy to work with. This week you will learn how you can manage your spreadsheets – find data with Filter and Sort, retrieve and change data using Find and Replace, and use Conditional Formatting to highlight specific data.
Sometimes you need to print your spreadsheets and this module will help you with that. Learn how you can optimise your spreadsheet for printing by managing margins, orientation, headers & footers, and more.
Charts are one of the most common ways to present data visually. This module walks you through creating and modifying charts in Excel.
Excel Skills for Business: Intermediate I
6 weeks of study, 2-4 hours per week
About the Course
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.
Working with Multiple Worksheets & Workbooks
This module is all about working with multiple worksheets and workbooks. Learn how you can combine data, manage datasets and perform calculations across multiple sources. And don’t forget the Toolbox with handy shortcuts and ninja tips.
Text and Date Functions
By the end of this module, you will be an expert in Date and Text functions. This module discusses ways you can extract information and manipulate data to fulfil specific business requirements.
Learn how you can create, manage and apply Named Ranges to enhance your calculations.
Graduate to advanced formulas in this module. Learn how you can use functions like COUNTIFS to extract information from data, as well as generate graphical representations of it.
Tables, tables, tables. Start with creating, formatting and managing tables and then move on to sorting and filtering tables to get the data you need. Finally, wrap up this module automating your tables to make your work more efficient.
Pivot Tables, Charts and Slicers
This module deep dives into the popular (and very useful) pivot tables. Learn how you can create and modify them to solve a variety of business problems. Then gain skills to create interactive dashboards with pivot charts and slicers.
Excel Skills for Business: Intermediate II
6 weeks of study, 2-4 hours/week
About the Course
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 this third course of our Excel specialization Excel Skills for Business you will delve deeper into some of the most powerful features Excel has to offer. When you have successfully completed the course you will be able to
- Check for and prevent errors in spreadsheets.
- Create powerful automation in spreadsheets.
- Apply advanced formulas and conditional logic to help make informed business decisions.
- Create spreadsheets that help forecast and model data.
Once again, we have brought together a great teaching team that will be with you every step of the way. Nicky, Prashan and myself will guide you through each week. As we are exploring these more advanced topics, we are following Alex who is an Excel consultant called in by businesses that experience issues with their spreadsheets.
We kick off this course with data validation and conditional formatting. This module takes you through creating and applying data validation, as well as working with formulas in data validation. This is followed by basic and advanced conditional formatting.
Excel has several logical functions and this module explores some of them. Start by learning the concept of conditional logic in formulas, followed by how to conduct logic tests and use conditional operations, to your benefit. We will also look at nested IF functions to evaluate data.
How do find information from different parts of a workbook? This module introduces you to functions like CHOOSE, VLOOKUP, INDEX, MATCH and other dynamic lookups to find and display data from several sources.
Formula Auditing and Protection
If you are worried that errors have crept into your worksheet, this module will show you how to check for errors, trace precedents and dependents, resolve circular references, and finally, protect your worksheets and workbooks from further harm.
This module is all about data modelling. Learn to model different scenarios based on input, assumptions and/or outcomes. Also learn the use of functionalities like Goal Seek, Data Tables and the Scenario Manager to make your models more robust.
We all love a bit of automation, and this module teaches you just that. By the time you have completed this module, you will be able to identify the uses of macros, as well as create, edit and manage them to increase your efficiency.
Excel Skills for Business: Advanced
6 weeks of study, 2-4 hours per week
About the Course
Spreadsheet software remains one of the most ubiquitous pieces of software used in workplaces around the world. Learning to confidently operate this software means adding a highly valuable asset to your employability portfolio. Across the globe, millions of job advertisements requiring Excel skills are posted every day. At a time when digital skills jobs are growing much faster than non-digital jobs, completing this course will position you ahead of others, so keep reading.
In this last course of our Specialization Excel Skills for Business you will build on the strong foundations of the first three courses: Essentials, Intermediate I + II. In the Advanced course, we will prepare you to become a power user of Excel – this is your last step before specializing at a professional level. The topics we have prepared will challenge you as you learn how to use advanced formula techniques and sophisticated lookups. You will clean and prepare data for analysis, and learn how to work with dates and financial functions. An in-depth look at spreadsheet design and documentation will prepare you for our big finale, where you will learn how to build professional dashboards in Excel.
Spreadsheet Design and Documentation
As an intermediate Excel user, you have the basics down. The first module of the Advanced course focusses on creating and maintaining accurate, flexible, responsive and user-friendly spreadsheets. You will learn how to design flexible and auditable spreadsheets, construct transparent calculations, create user-friendly navigation, and use styles, themes and formatting to tie it all up in a nice bow.
Advanced Formula Techniques
Excel often requires you to perform complex analysis on large sets of data. This can be made a lot easier using array formulas, which can perform multiple calculations simultaneously and ensure the accuracy of your spreadsheet. This module covers the use of array formulas, how to build them and use them effectively.
Data Cleaning and Preparation
Been handed a messy spreadsheet? This module focuses on data cleaning and preparation. You will learn how to use dynamic and automated fixes, clean messy data, automate these processes through functions, and ensure data remains clean dynamically. We will use functions to fix dates, replaces blanks and remove unwanted characters from data – all to help us build an efficient solution that lasts.
Financial Functions and Working with Dates
This module introduces financial functions into our Excel knowledge base. Financial functions are often used in businesses and Excel has a variety of tools to help you with that. This week, you will learn to apply date formulas in calculations, create loan schedules with financial functions, as well as use depreciation functions.
Advanced Lookup Functions
It is always a good idea to make your spreadsheets (and work!) more automated. Automated lookups can make your work fast and efficient. This module builds on your array capabilities and explores a range of functions to create dynamic lookup ranges – INDIRECT, ADDRESS, OFFSET and INDEX.
Building Professional Dashboards
To bring it home, this module guides you through the steps of building a professional dashboard. Data is meaningless unless it tells a story and can be used as business intelligence. This module will help you set up a dashboard – learn how to visualise data through graphs and charts, create data models, and add interactivity.
https://www.coursera.org/specializations/excelGet eBook Info Here