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

Provider Logo

Excel 2016: Introduction to Formulas and Functions

via LinkedIn Learning

Overview

Learn how to work with functions and formulas in Microsoft Excel. This course covers creating formulas, managing named ranges and tables, importing, exporting, and more.

Starting to build a spreadsheet from a blank worksheet is less intimidating if you are familiar with functions and how to create formulas in Excel. This course covers creating formulas, managing named ranges and tables, importing, exporting, validating data, and more. Learn how to maintain the integrity of your original data, audit your formulas for correctness, and adjust values to be able to calculate how to reach outcome goals.

Syllabus

Introduction
  • Welcome
  • What you should know
  • Using the exercise files
1. Introducing Excel 2016 Functions and Formulas
  • 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 Formulas
  • 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 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. Importing, Exporting, and Validating Data
  • 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
  • Next steps

Taught by

Curt Frye

Related Courses

Reviews

0.0 rating, based on 0 reviews

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

Never stop learning Never Stop Learning!

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

Sign up for free