Excel - Data cleanup and use as a database Short-Shot

Price: $150.00

Days: 0.5

Course Dates:

October 13 , December 15 , February 16

Learn Excel - Data cleanup and use as a database Short-Shot

Manage your information all in one

Excel – Data cleanup and use as a database Short-Shot

Course EXDC: 0.5 Days; Instructor-led by Michael Ouchi (Master Office Instructor)

 

For the vast majority of people Excel is a number crunching tool, it is good for that. But, there is another functionality . . . that is to clean up data prior importing it from one application to another or to clean it up prior to any data analytics.

  • Data cleanup
    • import a text file
    • clean up (normalize) the data
  • Database
    • sort (single/multiple criteria)
    • filter (single/multiple criterua)
    • calculations based on the filtered recordset