Updating data in an Excel worksheet is fast and easy. All you need to do is insert the new data and configure the sheet so that calculations are updated whenever the data changes. Storing your data in Excel also enables you to run reports on the data, perform calculations, print your work to share with others, and much more. In this course, you will use Microsoft ® Office Excel ® to create spreadsheets and workbooks that you can use to store, manipulate, and share your data. You will learn about auditing tools, how to perform what-if analysis and use Lookup functions. Level 3 is full of time-saving efficiency tools that will streamline your work in Excel.
See specific content information below in sections "Expected Outcomes" and "Attend and You Will Learn."
Who Should Attend
This course was designed for students desiring to gain the skills necessary to create basic macros, collaborate with others, audit and analyze worksheet data, consolidate multiple data sources, and use linking formulas and Lookup functions.
Attend and You Will Receive
Upon successful completion of this course, you will receive a certificate of completion from NC State University.
To ensure your success, you will need to have a comfort level with the basic skills of Excel like entering data, working with data, using functions, and working with formulas.
Attend and You Will Learn / Expected Outcome
In this course, you will learn to automate worksheet functionality, analyze, and present data and audit worksheets; you will also learn how to work with multiple worksheets and import and export data.
Attend And You Will Learn
Working with Multiple Worksheets and Workbooks Simultaneously
- Using 3-D References in Formulas
- Using Links and External References in Formulas
- Consolidating Data Using the Consolidate command
Sharing and Protecting Workbooks
- Collaborate on a workbook
- Protect worksheets and workbooks
Automating Worksheet Functionality
- Adding data validation criteria
- Working with forms and controls
- Creating and editing a basic macro
Applying Conditional Logic
- Using Lookup Functions
- Combining Functions
- Using Formulas to apply Conditional Formatting
- Tracing cells
- Troubleshooting invalid data and formula errors
- Watching and evaluating formulas
Using Automated Analysis Tools
- Determining potential outcomes with Data Tables
- Creating scenarios
- Performing what-if analysis using Goal Seek and Solver
Presenting Your Data Visually
- Using Advanced Chart Features
- Creating Sparklines