Coursera – Excel Skills For Business Specialization [FCO]
Learn Excel Skills for Business. Master Excel to add a highly valuable asset to your employability portfolio.
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.
What You Will Learn
– Be comfortable navigating the Excel user interface, entering, manipulating and formatting data.
– Use formulas and functions to perform calculations on data. Automate choices and data lookups using functions.
– Analyze data and present the results in a user-friendly way. Create charts and tables that effectively summarize raw data.
– Create easy-to-use spreadsheets. Validate data, find and correct errors. Create navigation aids for large workbooks.
Skills you will gain
– Data Validation
– Microsoft Excel
– Microsoft Excel Macro
– Pivot Table
– Pivot Chart
– Lookup Table
– Microsoft Excel Vba
There are 4 Courses in this Specialization
1. Excel Skills for Business: Essentials
2. Excel Skills for Business: Intermediate I
3. Excel Skills for Business: Intermediate II
4. Excel Skills for Business: Advanced
Nicky Bull, Nicky Bull is a dynamic corporate trainer and consultant. She has 15 years of commercial experience as a computer programmer and analyst, and over ten years designing and delivering a range of educational programs…
Professor Yvonne Breyer, Professor Yvonne Breyer is an award-winning academic with expertise in online learning, student engagement, and digital transformation in the higher education sector. Yvonne has led several strategic initiatives with national and international reach…
Dr Prashan S. M. Karunaratne, Dr Prashan Karunaratne is an inspirational and innovative lecturer of commerce, economics, and business analytics – and is well-known for his catchphrase, #EveryoneSayWow. He is also a curriculum developer and an instructor of the hugely popular Excel Skills for Business course that received the Coursera Outstanding Educator Award for Student Transformation in 2018…
Offered by Macquarie University
Author(s): Nicky Bull, Professor Yvonne Breyer, Dr Prashan S. M. Karunaratne
Videos Duration: 16h 42m 19s
Files In Folders:2,225 Files, 4 Folders
NOTE:Each course folder zipped due to the files count and large filenames to avoid torrent creation errors, contains all material.