Enter your email address:

Receive news and the latest training videos

Microsoft Excel

Learn all about our online Microsoft Excel training courses, course outline, demonstration video and details about our ONE PRICE offer at our new online training course website.

Want to take a brief tour about how EzyLearn online training courses work click here.

Remember that although these courses are displayed as separate courses the enrolment price includes access to all courses for the one price!

This one low price includes LIFETIME membership so you can access the course as a resource when you need to brush up on some unused skills at any time in your working life.

The One Price offer also includes ALL versions of Microsoft Excel (including 2000 and 2003) as well as current (2007 and 2010) and Office 365 content as we create it.

Do you know that EzyLearn online Microsoft Excel courses include not only video tutorials, but also each course comes with a training workbook filled with screen shots and exercises for you to complete? 

EzyLearn's online Microsoft Excel training courses are not just a collection of amateur videos, but are based on training material that was used in our three Sydney training centres (we closed them all by the end of 2006) and our existing corporate customers. We also provide training materials and online Excel training courses to government organisations and private companies as well as home users across Australian and even around the world.

Read our Case Study about how we trained the staff at EnergyAction to help their clients save tens of thousands of dollars in energy costs each year. It's a great story and we are proud to play a part. Microsoft Excel Training Course Case Study.

 There are also over 75 excel files that you are free to use as you please in our Online Microsoft Excel course that are used in the 9 training workbooks. This includes spreadsheets to work out loan repayments and the amount of money you can borrow for a home.

Are you new to online computer training courses? Not sure that you will like it? We are so confident that you will love our online course and LIFETIME resource that we offer a 100% money back guarantee. There is not booking fee, no non-refundable registration fee. If you are not satisfied you will receive a 100% refund of your total enrolment fee.

  

Microsoft Excel Online Training Course Outline

  

Microsoft Excel (module 301)  

The Excel screen including toolbars, formula bar, name box, column and row headings, sheet tabs… uses for Excel (Worksheet, Database & Charting). Getting around a spreadsheet using keyboard & mouse, moving between workbooks. Selecting (or highlighting) cells, columns and rows & entire spreadsheets. Entering information into workbooks and resizing columns. 

This course comes with a workbook that contains exercises that you can practise on your home or office computer.

Microsoft Excel (module 302)

Select cells, columns & rows, range names, select several ranges, drag & drop, cut copy & paste, enter data & edit cells, insert, resize and delete columns, use AutoFit, AutoComplete, create a database, understand hyperlinks in Excel, undo & redo, AutoFill, working with series, series options,   

This course comes with a workbook that contains exercises that you can practise on your home or office computer.

Microsoft Excel (module 303)

Formula basics, formulas keys, enter formulas using keyboard, mouse and arrow keys, AutoSum and function basics, AutoCalculate, Copying formulas & Functions quickly, merging cells, alignment, currency & percentage formatting, borders & shading and indentation, date and number formatting, format painter, AutoFormats, repeating actions quickly   

This course comes with a workbook that contains exercises that you can practise on your home or office computer.

Microsoft Excel (module 304)

Print & page break preview options, changing break positions, orientation, scaling, inserting & deleting page breaks, margins, normal, preset and custom headers and footers, set and clear print area, page printing order, showing titles and gridlines when printing, keep headings on the screen, printing multiple sheets.   

This course comes with a workbook that contains exercises that you can practise on your home or office computer.

Microsoft Excel (module 305)

Charting basics, chart types, data source, chart titles, axis labels, legend, data tables, pie charts, chart wizard, editing charts specifications after it is created, plot area, category and value axis, formatting a chart, have several different types of chart in one, charting multiple ranges, getting a chart into Word, Linking a chart in Word. 

This course comes with a workbook that contains exercises that you can practise on your home or office computer.

Microsoft Excel (module 306)

Working with formulas and functions, using percentage, Functions including average, sum, maximum, minimum and looking at more functions and the syntax of functions, copy formulas & functions & understanding relative & absolute cell references, inserting, viewing and editing comments. Hiding and un-hiding columns and rows.

This course comes with a workbook that contains exercises that you can practise on your home or office computer.

Microsoft Excel (module 307)

Looking at Excel program options, automatic calculation, error checking rules, customising the ribbon and quick access toolbar. The format of databases: delimiters, headers, records, fields, flat file vs relational data, filtering and sorting data and different data formats like Comma Separated Values (CSV), TXT, Tab separated values and how to open data in different programs. Naming Ranges and using Named Ranges in formulas. Data validation and drop down lists and mastering find and replace.

This course comes with a workbook that contains exercises that you can practise on your home or office computer.

Microsoft Excel (module 308)

Understand 3D formulas between worksheets, cleaning up data using advanced filter, create a pivot table and change the value field settings, create a pivot chart to visually show the stats, using advanced functions like CHOOSE, VLOOKUP, HLOOKUP, MATCH and INDEX, look at advanced functions within functions (Nested Functions) and how to protect the worksheet and workbooks.

This course comes with a workbook that contains exercises that you can practise on your home or office computer.

Microsoft Excel (module 309)

Find out how much you can afford to pay for a house using goal seek and financial functions, consolidate the information from several sheets, understanding the grouping of data, use solver to explore possible outcomes depending on input variables.

This course comes with a workbook that contains exercises that you can practise on your home or office computer.

©2013 EzyLearn Pty Ltd

Email Newsletter   Wordpress Blog   EzyLearn Affiliates