In this class we will move beyond the basics of spreadsheet creation. Topics will include data manipulation/troubleshooting and advanced functions to summarize and analyze data having multiple attributes. We will also introduce Pivot Tables, advanced graphs, and macros. Class exercises will be utilized to facilitate understanding.
Students will learn how to effectively streamline and analyze data using some of the more advanced features of Excel.
A basic understanding of the Excel spreadsheet layout and Pivot Tables
Common uses such as entering data into a blank spreadsheet and copying/pasting
An understanding of common functions such as SUM, IF, and VLOOKUP
Ability to create a graph from two or more sets of data points
Instructions for setting up the Developer tab for Macros:
Enter your email to start following
You’re following Advanced Excel: Beyond the Basics.
Start following any program. No need to enter your email again.