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

LinkedIn Learning

Excel 2007: Introduction to Formulas and Functions

via LinkedIn Learning

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
  • Create powerful Excel formulas
  • What you should know before starting
1. Introducing Excel 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
2. Creating Basic Summary Functions
  • Create a SUM or AVERAGE formula
  • Create an AutoSum formula
  • Create formulas to count cells
  • Create formulas to summarize cells conditionally
  • Summarize data on the status bar
3. Managing Named Ranges and Excel Tables
  • Summarize data using named ranges
  • Edit and delete named ranges
  • Summarize data using an Excel table
  • Refer to Excel table cells in formulas
4. Managing Data in Excel
  • Manage data using text functions
  • Separate data using Flash Fill
  • Create data validation rules
  • Restrict data entry using lists
5. Auditing Worksheet Formulas
  • Trace formula precedents and dependents
  • Evaluate Excel formulas step by step
  • Identify and trace errors
  • Manage Excel formula error indicators
Conclusion
  • Further resources

Taught by

Curt Frye

Reviews

4.8 rating at LinkedIn Learning based on 2391 ratings

Start your review of Excel 2007: Introduction to Formulas and Functions

Never Stop Learning.

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

Someone learning on their laptop while sitting on the floor.