Online Courses << Back to Home

Excel 2013 - Basic, Intermediate and Advanced Levels

Indicates Demo Video

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

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

We know you want to learn all about Excel 2013 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 15 mins Total Duration
21st January 2014 Release Date
24 Videos
  • Let's Get Started 2m 53s Creating new files 4m 34s The Ribbons 3m 16s The Quick Access Toolbar 3m 57s Customise the Ribbons 3m 00s The Help tool 3m 56s Opening a file 2m 21s Opening files from previous versions 3m 35s The Formula bar 2m 36s The Status bar
  • How to Enter your Data 3m 39s Save and Save as 2m 15s Saving files for older versions 3m 36s Entering and editing data 2m 18s Undo and Redo 5m 11s Dates and times 2m 15s Autofill 3m 18s Working with comments
  • First Look at Formulas & Functions 2m 12s Autofill 6m 46s Basic formulae 4m 46s Absolute Cell References 3m 58s The AVERAGE function 3m 06s The MAX function 2m 13s The COUNT function 1m 22s The MIN function 4m 08s Year to date calculations 2m 28s Counting cells
2 hour 30 mins Total Duration
21st January 2014 Release Date
38 Videos
  • Working with Formatting 2m 49s Formatting fonts 4m 11s Adjusting columns and rows 6m 11s Formatting numbers 4m 23s Using Borders 4m 23s Text alignment and wrapping 3m 52s Merging cell options 4m 06s Inserting images 3m 58s Creating and formatting shapes 4m 53s Tables 3m 54s Creating and modifying font styles
  • Using Conditional Formatting 5m 15s Conditional formatting 4m 43s Conditional formatting with Icon sets 1m 58s Creating custom Icon sets 3m 31s Creating templates
  • Adjusting your Worksheet Data 4m 08s Inserting and deleting columns and rows 4m 37s Moving, copying and inserting data 3m 54s The Find tool 2m 48s The Replace tool
  • Using Page Setup & Printing 4m 21s Page setup options 9m 00s Page layout 4m 53s Page breaks 3m 01s Setting the print area
  • Getting to grips with Charts 6m 04s Chart types 3m 32s Creating charts and graphs 4m 15s Formatting a chart 3m 09s Chart elements 3m 32s Updating data ranges 4m 28s Using Sparklines - Mini Charts
  • All about Views 3m 22s Changing views 2m 31s Zoom options 3m 43s Proofing option 1m 53s Freeze Panes 1m 51s Split screen 4m 14s Hiding data 4m 01s Creating an outline group
  • Workbooks & Worksheets at a glance 2m 21s Add, Delete & Rename Worksheets 3m 13s Moving, copying and delting worksheets 2m 21s Grouping worksheets
2 hour 19 mins Total Duration
21st January 2014 Release Date
32 Videos
  • IF, VLOOKUP and HLOOKUP 3m 51s IF functions 4m 07s SUMIF functions 5m 17s Nested IF 4m 06s Using IF with AND 3m 39s Using IF with OR 5m 52s VLOOKUP 5m 20s HLOOKUP 3m 56s Using the COUNT IF Function 5m 39s Hyperlinks
  • Security, Sharing & Protection 3m 31s Recovering lost files 4m 33s Protecting your workbooks and worksheets 2m 47s Sharing workbooks and track changes
  • Database Functions 4m 26s Sorting your data 4m 15s Using autofilters 2m 58s Splitting data 3m 53s Linking Data to Database Functions 3m 52s Subtotals 2m 52s Removing duplicates
  • Options 2m 06s Language options 5m 53s Advanced options 3m 21s Formula options
  • Pivot Tables Uncovered 4m 36s Creating a Pivot Tables 3m 47s Pivot tables tools ribbon 4m 55s Formatting a pivot table 2m 46s Changing a pivot table 3m 28s Grouping data in a pivot table 3m 31s Using slicers in pivot tables 3m 07s Using external data in pivot tables 3m 43s Creating a pivot table chart
  • Using the Data Analysis Tools 3m 26s Goalseek 4m 50s Creating and using scenarios 3m 48s Creating scenario reports 3m 26s Managing scenarios
  • Simple Macros 4m 53s Simple macros

Similar Courses