Skip to main content

Master data analytics and become an insightful Excel professional

Professional Certificate in
Excel for Everyone
UBCx

What you will 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.

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.

Expert instruction
3 skill-building courses
Self-paced
Progress at your own speed
5 months
3 - 5 hours per week
Discounted price: $402.30
Pre-discounted price: $447USD
For the full program experience

Courses in this program

  1. UBCx's Excel for Everyone Professional Certificate

  2. 4–6 hours per week, for 6 weeks

    Learn Excel fundamentals including data wrangling, spreadsheet management, and basic data analysis.

  3. 2–4 hours per week, for 6 weeks

    Further your Excel skills to manage larger datasets and more complex data wrangling, management and modelling.

  4. 2–4 hours per week, for 6 weeks

    Perform advanced data wrangling, analysis and dashboard visualization to help drive strategic decision-making.

    • More than 8 in 10 middle-skill jobs (82%) require digital skills, spreadsheets and word processing remain the baseline for digital skills, with 78% of middle-skill jobs calling for these at a minimum. (Capital One and Burning Glass)
    • Two of the LinkedIn’s Top 10 Hard Skills for 2020 - Analytical Reasoning (#3) and Business Analysis (#6) - rely heavily on data analysis abilities.
    • Between 2017 and 2020 there was a 750% increase in Canadian job postings that ask for ‘Data Analysis’ as a hard skill (Emsi)
    • Excel remains the most popular tool for market research, used by 86% of researchers.

Meet your instructor

from University of British Columbia (UBCx)
Ricardo R. Trujeque
Instructor
University of British Columbia

Experts from UBCx committed to teaching online learning

Enrolling Now

Discounted price: $402.30
Pre-discounted price: $447USD
3 courses in 5 months
Pursue the Program

Propelling

Drive your career forward with university-backed credit programs and verified certificates

Convenient

Study and demonstrate knowledge on your schedule

Flexible

Try a course before you pay

Supportive

Learn with university partners and peers from around the world