Microsoft Excel: Data Management and Manipulation
Control data without data controlling you!
In this half-day course, we will discuss how Excel can be used to manage and manipulate data in Excel, both in flat file databases and relational databases. Create and import databases and tables in Excel while handling multiple sorting and filtering tasks using a variety of criteria. We will also discuss how to format tables and databases in a professional manner while using Excel’s Format as Table feature.
Discover how to retrieve the information you need quickly and easily using multiple filters and custom views. We will also employ Excel’s terrific Name Box and Name Manager features to make data clearer and easier to reference.
We will use advanced functions to repackage data into more useful forms—such as correctly formatted addresses—using the CONCATENATE function to pull data together from two or more columns. Split data using delimiters and the Text to Columns feature to deconstruct names, dates, and other data into more useful formats.
Audience: We designed this course for current, experienced users of Excel who want to know more about managing and manipulating data
Software: This class is taught using Microsoft Excel 2016 on our lab PCs, but the content applies to Excel 2007, 2010, 2013, and 2016 for Windows. Material learned in this course may not apply to Excel for Mac.
After completing this course, participants will be able to:
- Sort and filter data using multiple criteria in order to get needed information with little effort
- Download databases from other applications and servers
- Create a data table or database avoiding common pitfalls
- Format a professional and attractive table
- Use the Name Box and Name Manager to efficiently navigate, print select, and add other functionality for your database and tables
- Create the CONCATENATE function to bring columns together
- Employ Text to Columns to separate data from one column into multiple columns