Loading...

Course Description

Microsoft Excel is a spreadsheet application widely used by employees in various roles in organizations to solve important problems. The goal of this course is to address essential features of Excel. Students will build Excel spreadsheets from scratch using various features such as pivot tables, data validation, and conditional logic to help solve basic business problems. This course assumes limited prior knowledge of Microsoft Excel and is ideal for students who are new to Excel or who want to enhance their knowledge of Excel.

Learner Outcomes

After taking this course, students should be able to setup a new Microsoft Excel spreadsheet that solves a basic business problem, such as break-even analysis. Students should be able to use the features of Microsoft Excel:

Basic functions such as SUM, COUNT, AVERAGE

Absolute and relative cell referencing

Named ranges

Formatting

Create a basic pivot table

Conditional logic functions such as IF and VLOOKUP

Data validation

Create basic Excel charts and graphs

Loading...
Enroll Now - Select a section to enroll in
Section Title
Microsoft Excel Fundamentals
Type
Online
Days
F
Time
9:00AM to 4:00PM
Dates
Sep 09, 2022
Schedule and Location
Contact Hours
6.5
Location
  • Online Course
Delivery Options
Online  
Course Fee(s)
PD non-credit $349.00