Excel: Introduction to Formulas and Functions

Focused View

Curt Frye

1:53:54

116 View

01 - Introduction

01 - Create powerful Excel formulas.mp4

00:29

02 - What you should know before starting.mp4

00:47

02 - 1. Introducing Excel Formulas and Functions

01 - Familiarize yourself with functions and formulas.mp4

04:01

02 - Create a formula.mp4

07:25

03 - Introduce arithmetic operators.mp4

05:31

04 - Use cell references in formulas.mp4

05:02

05 - Use absolute and relative references in formulas.mp4

05:20

06 - Copy and paste formulas and values.mp4

05:34

07 - Edit a formula.mp4

03:58

03 - 2. Creating Basic Summary Functions

01 - Create a SUM or AVERAGE formula.mp4

05:27

02 - Create an AutoSum formula.mp4

03:42

03 - Create formulas to count cells.mp4

03:14

04 - Create formulas to summarize cells conditionally.mp4

07:09

05 - Summarize data on the status bar.mp4

03:06

04 - 3. Managing Named Ranges and Excel Tables

01 - Summarize data using named ranges.mp4

06:41

02 - Edit and delete named ranges.mp4

03:18

03 - Summarize data using an Excel table.mp4

05:52

04 - Refer to Excel table cells in formulas.mp4

03:19

05 - 4. Managing Data in Excel

01 - Manage data using text functions.mp4

05:21

02 - Separate data using Flash Fill.mp4

02:32

03 - Create data validation rules.mp4

07:03

04 - Restrict data entry using lists.mp4

05:21

06 - 5. Auditing Worksheet Formulas

01 - Trace formula precedents and dependents.mp4

03:31

02 - Evaluate Excel formulas step by step.mp4

03:15

03 - Identify and trace errors.mp4

04:10

04 - Manage Excel formula error indicators.mp4

01:49

07 - Conclusion

01 - Further resources.mp4

00:57

Description

To unlock the power of Excel, you need to use formulas and functions. These calculation tools help you bring information to the surface and make better decisions. Excel: Introduction to Formulas and Functions shows beginner-level users how to summarize and analyze data with these powerful data analysis features. Instructor Curt Frye shows how to create formulas with mathematical operations such as addition, subtraction, multiplication, and division, and how to use cell references in your formulas. He explains how to summarize data with functions like SUM and AVERAGE, and work with data in named ranges and Excel tables. Curt also covers procedures to ensure data integrity, such as data validation, and demonstrates auditing techniques to ensure formulas are correct.

Note: This course was recorded on Excel for Microsoft 365. Most of the course contents will also be useful to those working with the most recent standalone versions of Office, including Office 2021.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Excel Formulas and Functions

Curt Frye

Instructor's Courses

I'm president and founder of Technology and Society, Incorporated, an Oregon "C" Corporation that encompasses my work as a course developer, writer, and speaker. I offer programs on effective teamwork, personal development, and business storytelling. BA (political science) and MBA.

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.