Online Courses << Back to Home

Excel 2007 - Basic, Intermediate and Advanced Levels

Indicates Demo Video

3 Short Courses to take you from Zero to Hero in Excel 2007

These 3 short online video courses in Microsoft Excel 2007 have been specially designed for you.

We know you want to learn all about Excel 2010 but we also know that your time is precious and that's the exact reason why we've created them in such small chunks to enable you to dip in and out when it suits you.

You can spend as little as 3 minutes to learn something new or refresh your memory if you've simply forgotten something. Or if you've a little more time available you could start to crack through one of the courses on your journey to becoming an Excel Wizard and supercharging your efficiency and career.

Remember: You are in control of your own learning and development and you will decide just how much you want to learn and when and where you want to learn it - at the office, whilst working away from the office, at home or even on holiday - perhaps not to so much the last one.

One thing's for sure though - You're really going to enjoy your learning experience and as you watch more and more content, you'll get used to the training style and come to recognise just how much your own Personal Trainer that sits right by your side 24/7 is there to help you.

You'll notice that all our videos are short so you'll be able to get right to the information you need really quickly. Watch the video - pause, rewind or replay if you like and then test your new skills directly on your live version of Excel - Enjoy!

Our videos are short, to the point and on average about 3 minutes long and let you learn when and how you want. Start taking control of your learning and efficiency at work, not to mention your career and life.

  • When you've watched all the videos in this series
      • Understand and apply a vast range of Excel skills
      • Familiarise yourself with topics from All levels
      • Apply your skills to your day to day work
      • Refresh your skills if you forget
      • Dip in and out whenever you want
      • Select any topics you need regardless of levels
1 hour 50 mins Total Duration
4th January 2010 Release Date
23 Videos
  • The Basics 5m 40s Introduction 4m 27s Ribbons & Groups 2m 57s Quick Access Toolbar 1m 48s Creating a New Workbook 4m 10s Open & Close 7m 27s Navigating & Selecting 4m 33s Copy & Paste 6m 04s Columns & Rows 5m 55s Worksheet Organisation 3m 32s Inserting & Deleting Cells
  • Working with Formulae & Functions 3m 30s Basic Formulae - Add 7m 33s Basic Formulae - Others & AutoSum 3m 35s BODMAS 5m 18s SUM, MAX, MIN, COUNT & AVERAGE 5m 10s Absolute Cell References 1m 46s Function Library 3m 29s Autofill 6m 58s Text Functions 3m 25s Calculating with Dates 8m 49s Subtotals 5m 48s Named Ranges 2m 03s Named Ranges with Go To 5m 51s VLOOKUP
2 hours 2 mins Total Duration
4th January 2010 Release Date
25 Videos
  • Working with Formatting 3m 42s Alignment 3m 34s Cell & Font Formatting 6m 29s Formatting Numbers 2m 21s Display as Fractions 1m 56s Cell Styles 3m 42s Formatting with Icon Sets 3m 16a Formatting with Colour Scales 4m 18s Formatting with Top & Bottom Rules 2m 57s Working with 3D Formulae 3m 52s Using Themes 2m 50s Cell Comments 2m 58s Format & Print Cell Comments
  • Tables, Charts. Graphs & Pictures 3m 00s Creating a Table 5m 36s Working with Charts 1m 49s Inserting Pictures 1m 53s Worksheet Backgrounds 3m 37s Smart Art
  • Print & Print Layout 7m 44s Print & Print Layout 4m 25s Print Tables
  • Working with Views 2m 34s Scrolling your Workbook Side by Side 6m 14s Viewing your Data Differently 3m 24s Split Screens 2m 40s Arranging your Windows 3m 28s Freeze Panes 3m 33s Headers & Footers
1 hour 25 mins Total Duration
4th January 2010 Release Date
15 Videos
  • Sort, Filter, Outline & Grouping 7m 45s Sort & Filter - Volume 1 4m 40s Sort & Filter - Volume 2 2m 27a Sort by Icon & Colour 5m 42s Automatic Outlining 3m 43s Grouping 4m 10s Advanced Filter Data Extraction
  • Getting to Grips with Conditional Logic 4m 23s Conditional Logic - Volume 1 5m 38s Conditional Logic - Volume 2 6m 52s Conditional Logic - Volume 3
  • Pivot Tables 10m 36s Pivot Table Layout & Design 8m 53s Pivot Tables with Charts
  • Goalseek & Data Consolidation 2m 57s Using Goalseek 7m 28s Working with Solver 4m 27s Data Consolidation 5m 35s Data Consolidation with Links

Similar Courses