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 important 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 to solve 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 a break-even graph

Loading...

Enroll Now - Select a section to enroll in

Section Title
Microsoft Excel Fundamentals
Type
Discussion
Days
F
Time
9:00AM to 4:00PM
Dates
Sep 11, 2020
Schedule and Location
Contact Hours
7.0
Location
  • Stafford Campus
Delivery Options
In-class  
Course Fee(s)
PD non-credit $349.00