Quick Start Excel: Getting Started With Excel Premium class

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

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
18 Videos (1h 21m)
    • Introduce Yourself

      1:15
    • Naming And Saving a Workbook

      1:55
    • How To Add Data To A Speadsheet

      3:53
    • How To Create And Format Titles

      7:21
    • How To Use The Autofill Function In Excel

      2:28
    • How To Add More Basic Formula

      5:16
    • How To Assign Cell Formats

      4:28
    • How To Use Absolute Referencing

      5:50
    • How To Use Auto Sum And Average Formula

      3:18
    • How To Add Borders To Define A Table

      11:30
    • How To Print Your Spreadsheet Print Settings

      9:53
    • How To Sort Simple and Related Data

      8:09
    • How To Insert Headers and Footers

      5:13
    • Tip #1 How to Add Up a Column or Row With Shortcut Keys

      1:18
    • Tip #3 How To Change The Names and Colours of Worksheet Tabs

      2:29
    • Tip #4 How To Change The Colour of The Gridlines

      2:44
    • Tip #2 How to Insert Current Date and Time Using Shortcut Keys

      1:02
    • Tip #5 How To Change The Colour of Text and Fill of Cells

      2:33

About This Class

Microsoft's Excel 2013 for Windows is a very useful and powerful piece of software - but it can appear daunting if you have never used it before. Jennifer will teach you step-by-step how to create a basic spreadsheet (using the example of a basic timesheet). She covers how to format cells, enter data, autofill, basic formulas and absolute referencing which will get you started quickly.

By the end of this introductory course, Jennifer gets you feeling confident about creating your first basic Excel spreadsheet.As an example she uses a timesheet so that you can use this yourself to calculate your hours worked, overtime, net and gross pay.

92

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!