AST - Advanced Spreadsheet Techniques Overview
Advanced Spreadsheet Techniques Overview
As you have learned in a previous module, most of Excel’s power comes from its ability to perform data calculations. Do you remember what is the most efficient and effective way to accomplish that?
Yes, by using formulas! You have already learned a few basic functions like calculating the total (SUM), mean or average (AVERAGE), minimum (MIN), and maximum (MAX). Even though these functions are very useful, Excel can perform much more powerful and complex operations. It’s like going from the golf cart to a powerful sports car!
In this module, you will learn how to apply text and logical functions, including using relative and absolute references. In addition, you will learn the basics of visual data presentation, such as how to display data in charts and organize data in tables.
Click on the book icon to view key terms for this module.
Watch the video below to learn more about advanced spreadsheet techniques.
Click "Next" on the carousel below the video to preview the lessons for this module.
Key Terms-
Absolute Reference: Points to a specific cell and remains static even when the formula is copied to a new location.
Column or Bar Chart: Used when data falls into distinct independent categories.
Data Source: The worksheet data used to create tables, charts, and graphs.
Financial Function: Used to calculate financial information, such as interest rate, payment, and loan amortization.
IF Function: Performs an operation only if the desired condition is found.
Line Chart: Used to show change over time, measured in even intervals.
Logical Function: Used to find or analyze data based on a certain condition.
Pie Chart: Used to show how several parts add up to create a whole.
Relative Reference: Points to a location relative to the location of the formula and is very useful when copying formulas because relative reference updates the formula to its new location.
Scatter Chart: Used to show the correlation between two variables.
Text Function: Used to manipulate, format, and perform calculations from text.
IMAGES CREATED BY GAVS