Join us and learn how to automate your spreadsheets, use functions to solve complex problems, and transform raw data for better decision making.
Start to organize your data more efficiently, plus communicate your ideas and results better! 90-Minute Workshop | Live AND On-Demand Microsoft Excel: Intermediate Training for Today's Top Professionals Wednesday, March 17th, 2021 at 1PM (ET) Elevate your skills from basic and make your life much easier.
You'll learn the following and more:
The Most Useful Formulas & Functions You Must Know - Create a dashboard with Excel's database formulas - DSUM, DAVERAGE, DCOUNT
- Use of free-form calculations as well as Relative & Absolute references
- View sheet tabs side-by-side in the same workbook
- Build 3D formulas from linking spreadsheets
- Define cell and range names for use in formulas
- Manipulate groups of data using outlining
- VLOOKUP formulas
Advanced Reporting with Excel's Analytical Tools - Goal Seek
- Scenario Manager
- One & Two-Input Tables
|