Online Courses << Back to Home

Excel 2010 - Basic, Intermediate and Advanced Levels

Indicates Demo Video

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

These 3 short online video courses in Microsoft Excel 2010 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
2 hour 27 mins Total Duration
6th March 2010 Release Date
34 Videos
  • The Basics 5m 24s Introduction 4m 34s Backstage View 4m 14s Ribbons & Groups 3m 20s Quick Access Toolbar 3m 06s New Worksheets 3m 04s Open & Close 6m 13s Navigating & Selecting 4m 43s Copy & Paste 7m 20s Columns & Rows 3m 08s Worksheet Organisation 3m 44s Inserting & Deleting Cells
  • Working with Formulae & Functions 4m 11s Basic Formulae - Add 7m 52s Basic Formulae - Others 3m 16s BODMAS 3m 30s Absolute Cell References 4m 41s SUM, MAX, MIN, COUNT & AVERAGE 4m 29s Function Library 3m 49s Autofill 7m 35s Text Functions 3m 08s Dates in Excel 7m 46s Subtotals 5m 40s Named Ranges 2m 42s Named Ranges with Go To 5m 42s VLOOKUP 2m 41s Equations
1 hour 39 mins Total Duration
9th March 2010 Release Date
30 Videos
  • Working with Formatting 4m 35s Alignment 5m 29s Cell & Font Formatting 2m 42s Number Format Buttons 2m 39s Fractions 4m 32s Cell Styles 3m 28s Formatting with Icon Sets 4m 03s Formatting with Colour Scales & Data Bars 1m 30s Formatting with Highlight Rules 4m 44s Formatting with the Rules Manager 4m 01s Formatting with Top & Bottom Rules 3m 08s Working with 3D Formulae 3m 58s Using Themes 3m 38s Editing & Navigating Comments 2m 46s Format & Print Cell Comments
  • Charts. Graphs & Pictures 4m 21s Working with Charts Volume 1 5m 03s Working with Charts Volume 2 3m 23s Inserting Pictures 1m 57s Worksheet Backgrounds 3m 21s Smart Art 2m 09s Sparklines
  • Print & Print Layout 3m 32s Print & Print Layout 2m 35s Print Titles
  • Working with Views 1m 57s Scrolling your Workbook Side by Side 3m 30s Workbook Views 2m 32s Page Layout View 1m 43s Screen Shots 2m 57s Split Screens 3m 15s Arranging your Windows 2m 12s Freeze Panes 3m 14s Headers & Footers
1 hour 45 mins Total Duration
9th March 2010 Release Date
17 Videos
  • Sort, Filter, Outline & Grouping 6m 19s Sort & Filter - Volume 1 6m 26s Sort & Filter - Volume 2 4m 51s Automatic Outlining 3m 25s Grouping 3m 24s Advanced Filter Data Extraction
  • Getting to Grips with Conditional Logic 6m 15s Conditional Logic - Volume 1 8m 13s Conditional Logic - Volume 2 8m 41s Conditional Logic - Volume 3
  • Pivot Tables 6m 28s Pivot Tables 10m 46s Pivot Tables with Charts 8m 44s Pivot Tables Layout & Design 5m 27s Using Pivot Tables with Slicers 5m 41s Formatting a Pivot Table
  • Goalseek & Data Consolidation 2m 32s Using Goalseek 6m 58s Working with Solver 3m 50s Data Consolidation 6m 28s Data Consolidation with Links

Similar Courses