About this Professional Certificate
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.
What you'll learn
- Identify data analysis use cases and develop a data-centric mindset for problem solving.
- Use data models for analysis and manipulate raw data to extract insights.
- Analyze data using Formulas, Functions, Datasets, Tables, PivotTables, Pivot Charts, What-If Analysis and Decision-Making Tools.
- Create attractive data visualizations for easy consumption, including generating, modifying and formatting charts and dashboards.
| From | University of British Columbia via edX |
|---|---|
| Hours | 84 |
| Instructor | Ricardo R. Trujeque |
| Language | English |
| Subjects | Data Science |
Similar Courses
Sorted by relevance
Careers
An overview of related careers and their average salaries in the US. Bars indicate income percentile (33rd - 99th).
Institutional Research Specialist in Data Analysis $42k
Professional-Data Analysis - SQL $63k
Business and Data Analysis $67k
Data Management and Analysis Fellowship - CDC $68k
Data Analyst, Marketing & Analysis $68k
Senior Data Analyst, Marketing & Analysis $77k
Data Scientist (Social Network Analysis) $84k
Analyst, R&D IT and Data Analysis Lead $88k
Data Management and Analysis Tech. $94k
Senior Data Analysis - ITSM Analyst $101k
Senior Data Analysis Engineer u2013 Engineering Data Analysis $149k
Data Architect - Financial Planning and Analysis $156k
Courses in this Professional Certificate
Listed in the order in which they should be taken
| Starts | Course Information | |
|---|---|---|
|
On Demand |
Excel for Everyone: Data Management 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... edX | University of British Columbia |
Save
|
|
On Demand |
Excel for Everyone: Data Analysis Fundamentals 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... edX | University of British Columbia |
Save
|
|
On Demand |
Excel for Everyone: Core Foundations 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... edX | University of British Columbia |
Save
|
&
| From | University of British Columbia via edX |
|---|---|
| Hours | 84 |
| Instructor | Ricardo R. Trujeque |
| Language | English |
| Subjects | Data Science |
Careers
An overview of related careers and their average salaries in the US. Bars indicate income percentile (33rd - 99th).
Institutional Research Specialist in Data Analysis $42k
Professional-Data Analysis - SQL $63k
Business and Data Analysis $67k
Data Management and Analysis Fellowship - CDC $68k
Data Analyst, Marketing & Analysis $68k
Senior Data Analyst, Marketing & Analysis $77k
Data Scientist (Social Network Analysis) $84k
Analyst, R&D IT and Data Analysis Lead $88k
Data Management and Analysis Tech. $94k
Senior Data Analysis - ITSM Analyst $101k
Senior Data Analysis Engineer u2013 Engineering Data Analysis $149k
Data Architect - Financial Planning and Analysis $156k
Similar Courses
Sorted by relevance
