Skip to content Skip to site navigation Skip to service navigation

Excel Data Management: Manipulation and Transformation

Class Sessions

Date Cost
  • Thu Feb 21, 9:00 am to 4:00 pm
$405

Class Code

ITS-1226

Class Description

Do you struggle with long lists of Excel data? This class is your relief. Enroll to finally learn how to quickly and easily fix and transform your data, to prepare it for analysis. Discover powerful fast ways to solve the peskiest data problems in Excel.
 


 

Abstract

When you struggle to transform a long Excel dataset, you want to be as efficient as humanly possible. Because even a few great tips that you can learn can immediately make a huge difference in your productivity and save literally hours of time that you currently waste.

Fortunately, Excel has an amazing power to help you speed things up. If you know how, you can fix most problems, manipulate and transform your data in Excel faster than you ever dreamed possible.

That’s exactly what you’ll learn in this one-day class.

Its goal is to help you quickly acquire a solid collection of great tips and tricks. So that you finally feel that you can take a real advantage of Excel as an efficient data manipulation and transformation tool.
 

After this one-day class you'll be able to:

  • Import data into Excel the right way and prevent some problems from the get-go.
  • Quickly remove unwanted visible and invisible characters that mess up your data.
  • Efficiently replace characters or text strings to modify your data.
  • Fix case problems in your datasets.
  • Quickly transform your data with the remarkable, lighting-fast flash-fill feature.
  • Comfortably use any one of the two methods to concatenate data.
  • Creatively resurrect leading zeros that were lost on (incorrect) import.
  • Easily parse data -- extract precisely what you want from useless longer text strings.
  • Discover some little-known benefits of the Text-to-columns feature.
  • Fix some problems with dates in Excel - fast.
  • Create formulas that extract the year, the month, the day, the weekday, or the quarter from a date. 
  • Create formulas that extract Stanford quarters from a list of dates.  
  • Quickly and efficiently fill the blank cells with the values from the cells above (hugely important for pivot tables).
  • Round numbers (A real must know how - if you work in finance).
  • Quickly filter and query data to find what's important.
  • Extract the data you want from a larger dataset.
  • Append data details with VLOOKUP.
  • Discover the benefits of using Excel Tables.

 



University IT Technology Training classes are only available to Stanford University staff, faculty, or students. A valid SUNet ID is needed in order to enroll in a class.