Quick Start Excel: Manipulating Data in Microsoft Excel | Jennifer Bailey | Skillshare

Quick Start Excel: Manipulating Data in Microsoft Excel

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

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
15 Lessons (1h 12m)
    • 1. Introduce Yourself new

      1:15
    • 2. Naming and Saving a Workbook

      4:12
    • 3. Inserting and Naming Tables

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

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

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

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

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

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

      4:57
    • 10. Separating Addresses Out Into Multiple Fields

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

      10:50
    • 12. Removing VLOOKUP Error Messages (IFERROR)

      6:03
    • 13. How to duplicate and existing worksheet

      3:35
    • 14. Updating payment information - Percentage Increase

      6:42
    • 15. Adding at Total Row and Formatting The Table

      2:47

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! 

88

Students

--

Projects

  • --
  • Beginner
  • Intermediate
  • Advanced
  • All Levels
  • Beg/Int
  • Int/Adv

Level

Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

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 ...

See full profile

Report class