Microsoft Excel is industry-standard software for organizing data and running repeated mathematical calculations. Its capabilities expand into data visualization, analysis, and automation while plugins enable advanced features including programmatic Bloomberg data access. This guide is designed to help introduce you to typical Excel features. Use the tabs to navigate through the guide.
Excel is available at all public library computer stations and available to full-time Penn faculty, staff, and students at participating Schools and Centers as part of the Microsoft Office suite.
The Lippincott Library offers live Excel workshops during the fall and spring semesters. Sessions cover keyboard shortcuts, pivot tables, lookups, and more with a focus on consulting and industry use cases. Explore the Excel Basics slides and exercises or sign up today.
Find more instruction through these and other sources: