Course details

Level: Beginner                                              Released: 9/24/2018

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. 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.

Learning objectives

• Define “formula.”
• Identify three comparison operators.
• Name two keys used to end editing mode in a cell.
• Recall the key used to open the Help pane in Excel.
• Recognize a valid time range in the Subtotal dialog box.
• Determine which formula would calculate the sum of a Sales column in a Sales Data table.
• Identify the file type that can be opened directly into Excel.
• Explain how to enable Flash Fill.
• Summarize the purpose of a precedent in a formula.

Course details

Level: Intermediate                                                       Updated: 8/17/2020

Follow along with Excel expert Dennis Taylor as he demystifies the hundreds of formulas and functions available in Excel. Dennis starts with a few critical formula shortcuts that will speed up your work, then covers a variety of functions, such as VLOOKUP, MATCH, and INDEX, statistical functions, text functions, and date and time, math, text, and information functions. Dennis provides practical examples to help viewers easily transition to using Excel's most powerful formulas and functions in real-world scenarios. Note that this course is recorded in Excel for Office 365 but anyone using a recent version—including 2019, 2016, and 2013—will be able to follow along.

Learning objectives

• Recognize the results of the MOD function.
• Identify the Excel random number generating functions.
• Apply the ROMAN function to convert a Roman numeral to Arabic.
• Give an example where the LEFT and RIGHT functions could be used.
• Describe the TRIM function.
• Define the Excel Text functions.
• Differentiate between Information functions.

Learn how to use formulas in Excel, including the following functions & formulas.