Excel: Introduction to Formulas and Functions

( 0 Reviews )

Created by: Curt Frye

Produced in 2018

Quality Score

Content Quality

Video Quality

Qualified Instructor

Course Pace

Course Depth & Coverage

Overall Score : 0 / 100

Live Chat with CourseDuck's Co-Founder for Help

Need help deciding on a excel course? Or looking for more detail on Curt Frye's Excel: Introduction to Formulas and Functions? Feel free to chat below.

Join CourseDuck's Online Learning Discord Community

Course Description

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. Plus, get an introduction to the What-If Analysis toolset, in an example that combines scenarios, data tables, and Goal Seek to generate accurate revenue projections.

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

Beginner Level

Time: 2h 34m

Instructor Details

Curt Frye

0.0 Rating
0 Reviews

Curt Frye is the president of Technology and Society, Incorporated.He is the author of more than 40 books, including Microsoft Excel 2019 Step by Step for Microsoft Press, and has created and recorded more than 60 courses for Lynda.com and LinkedIn Learning. As a speaker, he has presented talks on topics including "Rhetorical Mathematics" for CLE credit at the Law and Magic conference, "Business Storytelling Using Microsoft Excel" at the ATD-Cascadia annual conference, and his Improspectives approach to applying the techniques of improv theater to business and life for numerous audiences. As a performer, he has appeared in over 1,300 improv comedy shows with ComedySportz Portland and presents his Magic of the Mind show to theatrical and corporate audiences.Curt earned his BA in political science from Syracuse University and his MBA from the University of Illinois.