Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

# Excel: Introduction to Formulas and Functions

### Overview

Get a beginner-level introduction to Excel formulas and functions. Learn how to summarize and analyze data using these powerful data analysis features.

### Syllabus

Introduction
• Introduction to formulas and functions
• What you should know
1. Introducing Excel 2019 Formulas and Functions
• Familiarize yourself with functions and formulas
• Create a formula
• Introduce arithmetic operators
• Use cell references in formulas
• Use absolute and relative references in formulas
• Copy and paste formulas and values
• Edit a formula
• Get help using Excel functions
2. Creating Basic Summary Functions
• Create a SUM or AVERAGE formula
• Create an AutoSum formula
• Create MIN, MAX, MEDIAN, and MODE formulas
• Create formulas to count cells
• Create formulas to summarize cells conditionally
• Summarize data using conditional functions
• Summarize data on the status bar
• Round cell values up and down
3. Managing Named Ranges and Excel Tables
• Summarize data using named ranges
• Create a dynamic named range
• Edit and delete named ranges
• Summarize list data by creating subtotals
• Group and outline list data
• Summarize data using an Excel table
• Refer to Excel table cells in formulas
• Find data using VLOOKUP formulas
4. Preparing Data for Analysis in Excel
• Import data into Excel
• Connect to an external data source
• Clean data imported into Excel
• Convert text to columns
• Create data validation rules
• Use lists to limit values entered into a cell
5. Auditing Worksheet Formulas
• Manage Excel formula error indicators
• Trace formula precedents and dependents
• Identify and trace errors
• Evaluate Excel formulas step by step
• Watch cell values
6. Performing What-If Analysis
• Create and apply scenarios to an Excel worksheet
• Edit, delete, and summarize scenarios
• Create a single-input data table
• Create a two-input data table
• Find target values using Goal Seek
Conclusion
• Further information

Curt Frye

## Reviews

4.7 rating at LinkedIn Learning based on 791 ratings

Start your review of Excel: Introduction to Formulas and Functions

### Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.