A quick primer on database design to help you properly plan your database.
In this hands-on workshop, participants will become familiar with the basic tools for data management in Microsoft Excel 2016. Participants learn how to import, extract, and manipulate spreadsheet data. Participants will also use some of Excel’s tools to help manage multiple worksheets, visually compare workbooks, and work more efficiently in Excel.
Objectives
• Create tables and pivot tables
• Explore workbook and worksheet protection
• Import, sort, filter and validate data
• Create built-in and custom lists
The Gartner research library, available via a Penn State Libraries subscription, provides articles and information for technical professionals. Gartner, Inc. is the world's leading research and advisory company. The company helps business leaders across all major functions in every industry and enterprise size with the objective insights they need to make the right decisions.