Microsoft Excel Level 2 builds on Level 1 to provide more advanced tools for analysis and presentation of complex, realistic data.
1: Managing workbooks
Module A: Managing worksheets
Module B: Customizing Excel
2: Named ranges
Module A: Using names in formulas
In this course, you will learn how to manage complex workbooks, build more complex functions, use data analysis tools, make an impact with powerful chart and presentation features, and collaborate with other users.
Students will benefit most from this course if they want to use Excel to perform real-world tasks such as rearranging and presenting complex data.
Using Microsoft Windows
To ensure your success in this course, you should have end-user skills with any current version of Windows, including being able to start programs, switch between programs, locate saved files, close programs, and access websites using a web browser.
Also, you should have equivalent introductory experience (knowledge of basic concepts and skills) with Excel.
Bring your own laptop with full version of Microsoft Office already installed and its charger.
1-month free trial of Word, Excel, PowerPoint, Outlook, and more is available at Microsoft.com.
Course Materials Included
Handout and data files
Please arrive 15 minutes early to leave time to settle in and allow the workshop to begin promptly at the scheduled start time.
Within each class, the material taught builds on prior class meetings, so attendance is key.