Excel for Everyone:
Core Foundations
About course
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.
outcomes
- Excel
fundamentals.
- Data
entry and editing using various formats.
- Performing
calculations using formulas and functions.
- How
to format and optimize spreadsheets.
- How
to manage spreadsheets using Filter and sort table data capabilities.
- Previewing
and printing.
- Effective
data visualization using basic charts.
Data Management
About this course
This intermediate Excel course
builds on the teachings of the introductory 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 analyze and present data. From error prevention to forecasting and automation, you’ll build an advanced layer of knowledge to manage larger
datasets and continue developing your aptitude for data modelling.
outcomes
- How
to manage multiple worksheets and workbooks.
- Analyzing
data with datasets and tables.
- How
to manage data analysis using Pivot Tables and Pivot Charts.
- Implementing
What-If Analysis and Decision-Making Tools.
- Using
Date, Logical, Statistical and Financial Functions.
Perform advanced data
wrangling, analysis and dashboard visualization to help drive strategic decision-making
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.
Outcomes
- How to apply advanced formulas and conditional logic.
How to analyze and report on data frequently.
- Automating complex or repetitive tasks.
- How to perform advanced data analysis, collaborate on workbooks with other users, and automate workbook functionality.
- Protecting your workbooks.
- Performing Formula Audits and Data Validation.
- Creating Macros and using visual Basic.
- How to use Advanced Charting Techniques to build professional dashboards.
About the instructors
Ricardo R. Trujeque
Instructor at
University of British Columbia
Ricardo is a creative entrepreneur,
executive and business consultant with a career spanning 20+ years at the
intersection of technology, marketing and education. Ricardo has co-founded
several companies and has led cross-functional teams working on projects for a
range of industries and clients, from start-ups to Fortune 500 companies.
Ricardo is an
experienced lecturer and guest speaker, working for UBC and other universities
internationally. A passionate collaborator, Ricardo develops engaging
educational content and experiences through his company Explora Studios.
Ricardo holds a BA in Communications, a Master’s of Strategic Marketing, and
reached PhD candidacy at the University of British Columbia.
No comments:
Post a Comment