LINKEDIN LEARNING EXCEL INTRODUCTION TO FORMULAS AND FUNCTIONS-BiFiSO
Submitted by milohaze on Wed, 11/14/2018 - 12:44
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. This course shows how to create formulas with mathematical operations such as addition, subtraction, multiplication, and division, and how to use cell references in your formulas. It explains how to summarize data with functions like SUM and AVERAGE, and work with data in named ranges and Excel tables. This course 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.