« Back to Class Listing

Microsoft Excel: Data Management and Manipulation

Description


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

Section:
Notice: Undefined variable: SectionNumber in /it/web/std-prod/ece.emory.edu/htdocs/catalogSectionDetail.php on line 613
Dates:
Notice: Undefined variable: StartDate2Display in /it/web/std-prod/ece.emory.edu/htdocs/catalogSectionDetail.php on line 616

Notice: Undefined variable: EndDate2Display in /it/web/std-prod/ece.emory.edu/htdocs/catalogSectionDetail.php on line 616
-
Time: 9:30 AM
Tuition:
Notice: Undefined variable: Cost in /it/web/std-prod/ece.emory.edu/htdocs/catalogSectionDetail.php on line 620
Instructor:
Notice: Undefined variable: InstructorString in /it/web/std-prod/ece.emory.edu/htdocs/catalogSectionDetail.php on line 621

Notice: Undefined variable: ButtonName in /it/web/std-prod/ece.emory.edu/htdocs/catalogSectionDetail.php on line 624

Notice: Undefined variable: ButtonName in /it/web/std-prod/ece.emory.edu/htdocs/catalogSectionDetail.php on line 626

Notice: Undefined variable: ButtonName in /it/web/std-prod/ece.emory.edu/htdocs/catalogSectionDetail.php on line 630

Notice: Undefined variable: SectionDescription in /it/web/std-prod/ece.emory.edu/htdocs/catalogSectionDetail.php on line 646

Class Schedule

Date Times Meeting Type Location
08/25/2017 9:30 AM - 12:30 PM Classroom Executive Park

Additional Information

Final Enrollment:
Notice: Undefined variable: FinalEnrollmentDate2Display in /it/web/std-prod/ece.emory.edu/htdocs/catalogSectionDetail.php on line 702

Clock Hours:
Notice: Undefined variable: ClockHours in /it/web/std-prod/ece.emory.edu/htdocs/catalogSectionDetail.php on line 707