Excel 2016: Introduction to Formulas and Functions
Offered By: LinkedIn Learning
Course Description
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.
Syllabus
Introduction
- Welcome
- What you should know
- Using the exercise files
- 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
- 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
- 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
- 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
- Manage Excel formula error indicators
- Trace formula precedents and dependents
- Identify and trace errors
- Evaluate Excel formulas step by step
- Watch cell values
- 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
- Next steps
Taught by
Curt Frye
Related Courses
Introduction to Computational Finance and Financial EconometricsUniversity of Washington via Coursera Excel 2010
Miríadax The Finance of Retirement & Pensions
Stanford Graduate School of Business via NovoEd Einführung in die Wahrscheinlichkeitstheorie
Johannes Gutenberg University Mainz via iversity Introduction to VBA/Excel Programming
Cal Poly Pomona via Open Education by Blackboard