Quick Start Excel: Manipulating Data in Microsoft Excel Free class

Jennifer Bailey, Experienced off-line and on-line tutor

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
14 Videos (1h 9m)
    • Introduce Yourself new

      1:15
    • Naming and Saving a Workbook

      4:12
    • Inserting and Naming Tables

      4:48
    • Correcting the case of names without capital letters (PROPER)

      5:12
    • Creating a Display Name Using Concatenate and Upper Functions

      4:13
    • Extracting An Initial From A Name (LEFT Function)

      2:40
    • How To Create a Drop Down List For Members Titles

      3:26
    • How To Remove Duplicate Data From a Table

      2:33
    • How To Calculate Age From Date of Birth

      4:57
    • Separating Addresses Out Into Multiple Fields

      8:47
    • Creating a Summary Sheet (VLOOKUP) new

      10:50
    • Removing VLOOKUP Error Messages (IFERROR)

      6:03
    • 12

      3:35
    • 13

      6:42

About This Class

In this course Jennifer shows you how to tidy up and extra information from data. These techniques - taking advantage of Excel's many functions which help your productivity and speed up tasks which manually could take you hours to correct! 

25

Students

--

Projects

Jennifer Bailey

Experienced off-line and on-line tutor

I achieved my BSc(Hons) in 1996, and then my Post Graduate Certificate In Education in 2001. I am also a member of the Institute for Learning.

Since qualifying I have worked in education with a spectrum of ages and abilities in colleges, the workplace and though private work.

I am a specialist in teaching English, Maths, ICT and Food Studies, both off and on-line. I also have experience in curriculum design, e-Learning and assessing.

I use technology wherever possible in my courses and I try and cater for all learning styles.I have tailored my on-line courses to promote learning using small bite-sized steps so that the learner can work at their own pace and not to be baffled by terminology, nor bored by waffle!