Excel for Everyone
Offered By: The University of British Columbia via edX
Course Description
Overview
The world runs on data more than ever before. Regardless of your profession, data administration, analysis and visualization have become critical skills that are in high demand. Whether you need to make business projections, store inventory, conduct research or gather market intelligence, the ability to make sense of data is increasingly essential.
Everyone recognises Microsoft Excel, yet few people use it to its full potential. It’s ubiquity and ability to effectively manage large amounts of data make it an ideal data analysis tool that offers something for everyone. From the fundamentals to advanced use cases, Excel can be your ally when it comes to streamlining tasks and delivering valuable, professional data insights. In this program, even beginners can work their way up to extracting actionable intelligence from raw data, by using Excel’s powerful tools for data manipulation.
Starting with the fundamentals, and progressing to advanced data management and analysis, this hands-on Professional Certificate program will equip you with the tools and methodology to master Excel skills. Learn to carry out regular tasks faster than ever before, create models and templates with multiple scenarios, and design professional visualizations and build reports and analysis from raw data extraction.
Using data effectively goes beyond simply understanding a tool’s functionality. Drawing on real-life examples, this program will also help you integrate data analysis into your everyday thinking; to recognise how and when Excel can be used to problem solve and provide valuable insight. Developing this data-centric mindset will give you a truly competitive edge that is valued across industries.
Syllabus
Course 1: Excel for Everyone: Core Foundations
Learn Excel fundamentals including data wrangling, spreadsheet management, and basic data analysis.
Course 2: Excel for Everyone: Data Management
Further your Excel skills to manage larger datasets and more complex data wrangling, management and modelling.
Course 3: Excel for Everyone: Data Analysis Fundamentals
Perform advanced data wrangling, analysis and dashboard visualization to help drive strategic decision-making.
Courses
-
This advanced Excel course builds on the teachings of Course 1: Core Foundations and Course 2: Data Management. Designed for experienced Excel users, master the techniques needed to draw insights from vast amounts of data.
Whether you need to process numbers for personal projects or for organizational purposes like sales, inventory, human resources, or IT, knowing how to make sense of data is critical. You will develop in-demand skills to gain a competitive edge and value to your organization, including how to extract actionable organizational intelligence from raw data, and present it in a visual format to help drive organizational decision-making Learn how to get Excel to do the hard work for you with sophisticated automation, spreadsheet design and powerful dashboards.
-
This intermediate Excel course builds on the teachings of the introductory Core Foundations course, teaching you to leverage the power of data calculations and reports to make informed personal or organizational decisions.
The course is designed for learners who already have foundational knowledge and skills in Excel but wish to take advantage of some of the higher-level functionality to more effectively analyze and present data. From error prevention to forecasting andautomation, you’ll build an advanced layer of knowledge to manage larger datasets and continue developing your aptitude for data modeling.
-
This introductory Excel course will equip you with a strong foundational knowledge of Excel to organize, analyze and work with data. You will develop essential Excel skills, such as simple data wrangling and managing spreadsheets, along with a foundational understanding of business data analysis.
The course is designed for those with little or no functional knowledge of Excel, as well as those who regularly use Excel at a basic level, but wish to enhance their skills. From basic operations to an introduction to more advanced techniques, within six weeks you’ll gain the confidence to navigate the Excel interface, master essential spreadsheet functions, perform calculations and produce creative charts and graphs from your data, while building an aptitude for data analysis that is critical to the success of any organization.
Taught by
Ricardo Rosado Trujeque
Tags
Related Courses
Intro to StatisticsStanford University via Udacity Introduction to Data Science
University of Washington via Coursera Passion Driven Statistics
Wesleyan University via Coursera Information Visualization
Indiana University via Independent DCO042 - Python For Informatics
University of Michigan via Independent