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

The Vancouver Island Works Project acknowledges that our members, live, play and do business on the Traditional Territory of the Lək̓ʷəŋən speaking peoples. It recognizes the First Nations governments across this region — Lək̓ʷəŋən (Songhees) and Xwsepsum (Esquimalt) Nations in the core area, the W̱SÁNEĆ Nations {W̱JOȽEȽP (Tsartlip), BOḰEĆEN (Pauquachin), SȾÁUTW̱,(Tsawout) W̱SIKEM (Tseycum)} out on the Saanich Peninsula and Gulf Islands, to the west Sc’ianew (Beecher Bay), T’Sou-ke, and Pacheedaht, and MÁLEXEȽ (Malahat) and Pune’laxutth’ (Penelekut) Nations.