EzyLearn - Learn to use MYOB, Microsoft Excel and more (online training course)

You are not logged in. (Login)
 
 
 
 
Online MYOB and Microsoft Excel Training Courses

Welcome to EzyLearn Online!

Welcome to the EzyLearn online training course for MYOB accounting software, Microsoft Office (including Microsoft Excel), Computer Learners and WordPress Website Design and Blogging System.

You've arrived at the training site for our courses so if you are looking for more information about our online training courses, lifetime student access, support options, course contents and the case studies we use please visit our main online training site:

www.ezylearnonline.com.au

If you haven't done so already, take the tour and see how our online learning works otherwise login, enter your enrolment keys (if you've already enrolled) and start your course.

http://ezylearn.com.au/wordpress/2011/10/navigating-the-ezylearn-online-training-site/

Call us on (02) 9971 0000 or from anywhere in Australia on 1300 888 869 if you have any questions or want more information.

If you are not a student but you would like to enrol remember that you can enrol today and start by 5pm tomorrow (next business day).

Click here to enrol

If this is the first time you have heard about us and you'd prefer to get to know us a bit better, subscribe to our online training course blog where we write about:
  • New course content for each of our online courses (Microsoft Excel, Word, PowerPoint, Outlook, MYOB, WordPress, Computer Learners and more)
  • Free training videos and content that we release from time to time to give you some skills and demonstrate our products
  • Free Tips and Tricks relating to the software we teach in our courses
  • Information about Online Learning, Certification and Nationally Recognised Courses
  • Training Tips created as part of our EzyLearn Q&A service to give more to our existing students
Follow this link to subscribe: http://ezylearn.com.au/wordpress/subscribe/

 

Available Courses

  • Using the mouse: Most beginners to computing fail to understand and perform basic mouse commands and these flow onto future problems in using the computer.

    Get to know the parts of the startbar, learn about short-cuts and icons, using the mouse (including left click, double-click, right-click, click & drag) to launch programs, get properties, select icons and move and resize.
    RESULT: Confidence with the mouse and how to use it to perform simple commands with Desktop icons. 

    Mastering Windows: resizing & moving windows, maximise, minimise, restore, starting & using a program and closing it down. You'll also learn about the terms used in Windows like Title bar, menu bar and many more...
    RESULT: You will understand how to launch programs, switch between programs, understand active and inactive Windows and close a program when you are finished with it.

    Dialog boxes: Understanding the parts of a dialog box and when they are used, including drop-down lists, scroll bars,
    RESULT: You will end up customising the display properties of your computer, including screen savers, wall paper and Colour Schemes

  • Using a program: In this course you will start to use Paint (basic image editing software) to create a drawing and use a variety of different tools within that program, including drawing shapes, using a spray can and different brush styles.

    Saving files: Once you have created a drawing you will learn how to save a file including, filenames and where files are stored, type of image files (bitmaps). You'll also learn how to look into folders to open files and recognise the files (drawings) that you have already created.

    Files: You learn how to delete, rename and restore files, looking into your recycle bin and understand that files can be viewed a number of different ways. You see that files have different sizes depending on the type of file and that the computer keep track of when files are created and saved.

  • Windows: Confirm the ability to launch 5 programs and switch between them with ease, also maximise, minimise and understand active and inactive windows, arrange desktop icons and use Auto Arrange, creating shortcuts for programs on the desktop and QuickLaunch bars.

    Using a Word Processing program: Understanding how to change the view of a word processing program and get around it, type a basic letter using text wrapping and save the file.

  • Introduction to the My Computer icon, including different drives, looking at a files in My Computer that was created using Word, understand CD's and AutoPlay, looking at the contents (files and folders) of a CD, transfer files from a CD to Hard disc using the Winzip Self-Extractor (that comes with this course), understanding the folders and contents panel, different ways to view files (especially image files and office documents), understanding the path of files and the address toolbar, navigating to the path using the Open dialog box in programs like Word and Paint.

    Opening files using My Computer or a specific program, understand how not all programs can open all files (incompatible program errors), using click and drag and copy and paste to move files from one place to another. Searching for files by filename or for keywords.

  • Internet Explorer: Getting around the program and changing the view, understanding the address bar, go button, status bar, understand the concepts of home pages, getting around a website using hyperlinks, getting to other websites using hyperlinks, opening pdf documents using links, understand the purpose of Adobe Acrobat reader, links to email addresses, moving backwards and forward between "visited" websites, understanding the concept of frames.

    Websites: Understand the concept of waiting for website files to download, stopping a website from downloading, refreshing and revisiting websites and why they appear faster the 2nd and subsequent visits. Error messages and incorrect website address messages, understanding how popups work and how to deal simply with them, domain names and how they can change (beyond your control), adding a webpage to your favourites and setting your home page.

    Searching: Understanding the concept of search engines, the search button and searching MSN, using the address bar to search, searching online directories, search for website domain names, using the Google search engine, refining your Google search, searching the Internet for images, performing a search within a search, Smarter searching using multiple windows.

    History and Favourites: Understand how Internet Explorer keeps track of website and the webpages within a website in history, this is a great way of visiting a site that you have been to before even if you can't remember the website address, adding a website to favourites using the toolbar and the menu bar options, and where to find added favourites, organising your favourites into folders, organising existing favourites, changing the names of favourites and more...

  • Email systems: Understand the difference between web-based and computer based email (hotmail vs Outlook Express), understand the layout of Internet Explorer and how to change it, sending an email, using the tab key to move from field to field, understanding the Send/Receive button, Opening, reading, replying to and forwarding an email, Understanding message priority and message status icons.

    Attaching files: How to attach one or many files to an email, attaching different types of files, how to open an attachment, and working with files that you cannot open on your computer.

    Address book: Adding names to your address book, Creating a new entry from scratch or "on the fly", understanding CC and BCC, how to delete messages permanently.

    Understanding how to use hotmail, add contacts and send email messages.

  • The Screen: Get to know the name of all the different parts of the screen and what they do, including toolbars, menu bars, task pane, status bar etc. Customise your screen so that it is familiar to your preferences, including turning toolbars on/off.

    Change the measurement units, recently used documents and personalised menu settings. Change the zoom and understand that it only affects how you see things on the screen as opposed to how the document prints out.

    Understanding the Open dialog box and how to look into different folders to find a file and open it. Once the file is open you'll learn how to get some fundamental information about that document, including how many pages and sections are in the document.

    Editing Text: Understanding the mouse and text cursors and where text appears when you start typing. Move the text insertion point using both the mouse and keyboard, and move even faster where you want the text cursor using the Ctrl key in combination with the direction keys (also called Arrow keys).

    Use the page up, page down, home and end keys to move around your document even faster. Learn how to edit and delete text using the Backspace and Delete keys,

    Non-Printing Characters: Learn how the Enter, space bar and tab keys put a "non-printing" character on the screen. These characters do not print, but can be edited just like normall letters and numbers (in other words the can be deleted).

    Saving: Understand how to save files, where files are stored and file names, also learn the keyboard shortcuts for this command. Understand the principles involved in saving a file for the first time, subsequent saves and using Save as.

    Selecting text: Learn how to select text using the mouse, keyboard and the Select All command. Learn how to undo any changes you make because new users to Word will often accidentally delete text and the best way to get it back is to Undo it. Learn about the 3 ways of Undoing.

    Understand where the selection bar is and use it and a combination of clicks, double-clicks and tripple clicks to select words, paragraphs and the entire document. Learn also about some common problems that people encounter when selecting text.

    Use the SHIFT key on the keyboard to select text and combine it with other keys to select large amounts of text quite quickly. The more you learn to use the keyboard shortcuts, the faster it will be to create and edit your documents.

  • Formatting: Text formatting effects individual characters that first need to be selected (highlighted). You'll learn about changing the font, font size, style, colour, how to make characters bold, italic and underlined and how to make several of these changes at the same time using the mouse via the formatting toolbar and the Font formatting dialog box that is accessed via the menu bar.

    Learn about default settings, in particular how to change the default font that is used in most "Normal" documents and learn how to use Format Painter to make formatting a breeze.

    Page Formatting: Learn about the various page setup options and how to change the default Page Settings for "Normal" documents.

    This section will show you how to make the page print sideways (landscape) or tall (portrait) - this is called Orientation and how to change your side and top and bottom margins (distance that text appears from the edge of the page).

  • Paragraphs: This topic is one of the hardest concepts to master for those starting out using Microsoft Word, yet it is a fundamental skill that helps you master other like tabs, indenting, and even advanced tools like styles and templates.

    Topics include understanding how the Enter key separates each paragraph and that a line with nothing in it except the enter character (also called carriage return) can contain paragraph formatting. You'll learn how to select paragraphs to change their paragraph formatting (different from font formatting).

    Line spacing and the amount of space before and after a paragraph can also be applied using paragraph formatting tools.

    Borders and Shading: This is a very simple tool to use initially, but it can get more confusing depending on "what" you want to apply the formatting to. You can apply the formatting to text, paragraph(s) or entire pages.

    Topics Covered: Understanding the tool buttons on the borders and shading toolbar, applying borders to paragraphs that contain indenting, and to several paragraphs at once.

    You also learn about different shading options (again, you can get different formatting for text and paragraphs) and learn how to combine text and paragraph shading for that added effect in your documents.

    Bullets and Numbering: These tools provide a great way to make the information in your document easy to read. It also helps to highlight the main points and can show you main topic headings and sub-categories.

    You'll learn: How to start using bullets and numbering using some automatic tools (this is an easy way to get started and it also teaches you how to deal with automatic bullet and number formatting if it happens and you don't want it to).

    Change the type of bullets or numbering used (including the use of letters), edit and existing numbered list (to insert points in the middle) and get an introduction to how numbering styles are used (Styles are covered in more detail in a later Word module).

    Learn how to change the spacing between the margin and the bulletted list and between the bullets and the text. This is particularly important if you are going to work with large bullets.

  • Tabs: Tabs are primarily used to provide structed spacing across the page in Word documents. It is ideal where you have a list of information like a price list or a database of names. Tab is a "non-printing" character (similar to space) that doesn't print, but it makes your text cursor line up at a given marker, that you can see in the ruler.

    You should have a solid understanding about paragraph formatting before you attempt this module.

    You will learn: There are default tab markers in the ruler (usually set at every 1/2 inch) and how to use the tab key to make text line up. You'll learn about the difficulties that people have understanding the tab character and how to delete tabs to fix most common problems.

    Just like the good 'ole manual typewriter, you can actually set tabs where you want them so that you don't have to continuously press the tab key to make text line up. It also gives you much more control for when you want to change how the text lines up.

    You'll learn about the many different type of tabs that you can set and when to use them (for example, you can make a column of dollar figures line up to the decimal point). You'll learn how to use the menu bar option to set and change tabs using the tabs 'dialogue box'. This is a great tool if you get stuck and simply want to remove all 'set' tabs.

  • Tables: Tables are a great tool to help you structure your data. The concept of tables is similar to using tabs (yet much more powerful in terms of layout) and a simpler than using a spreadsheet (eg. Excel).

    There are more formatting options in relation to borders and fill colours that make Tables very powerful and you can incorporate images into each of the cells of the table.

    You'll learn: How to insert a table using the menu bar and toolbar methods, how to choose the number of rows/columns you want in your table and deleting cells/columns and rows that you don't need.

    You'll learn how to resize parts of a table visually using your mouse or using a dialog box and you'll learn how to select the various parts of a table to then apply formatting or edit the contents.

    You'll learn: how to enter information into cells, how to alter the text and  paragraph formatting within a cell using the Table properties dialog box.

    How to merge cells (ideal if you want to create a heading or have large areas within your table for information) and split them to further structure your data.

    These skills give you complete control over the more intricate tools that are available within a table.

    You'll learn how to apply text formatting to individual cells and use the format painter option to make it much easier to duplicate. You'll learn how to change vertical as well as horizontal justification (alignment).

    Table gridlines can be turned on or off for viewing and border formatting can also be applied if you want lines to appear when printing your table.

    You can also apply shading and bullets within each cell of a table and you'll learn how to perform these actions.

  • Office Clipboard: This tool enables you to "collect" many pieces of information from any office program that is running so that you can then paste them all in one document it you want to. It also enables you to collect many pieces of information (text, images etc) and then have them available for you when you are ready to paste. It takes the concept of copy and paste to the next level.

    You'll learn how to make the Office clipboard appear automatically, copy and paste text using the office clipboard and deleting all information that is stored on the office clipboard onces you have finished with it.

    Learn about: Page breaks to help keep headings at the top of the page. You can use both the mouse (an menu bar options) or keyboard shortcuts to insert page breaks and you will also learn how to view the page breaks and delete them when they are no longer neede.

    Symbols are used to produce a creative effect in documents and especially when using bullets. There are symbols that represent commonly used information like Telephone, fax and email symbols.

    You'll learn: How to insert symbols and understand symbol subsets. There are literally hundreds of symbols and you can even use keyboard combinations to make symbols appear on your screen. A good example of when these symbols are used is foreign language symbols.

    Some common symbols are © and ® and you'll learn how to get these and many more symbols like them into your document.

    Headers and Footers: This tool enables you to insert text or symbols in your document. they normally appear at the very top and bottom of your document and contain information about the document such as filename, page numbers, copyright information etc.

    You'll learn: How to move from the document to the header/footer and back to the document, how to switch between the header and footer and how to quickly move around these areas using your mouse.

    Use tabs in the header/footer to professionally align the information and insert very quickly some document information with only a couple clicks. Information like the current date/time, total number of pages, filename and many more.

    Templates: this tool enables you to create professionally laid out documents once, and use them over and over again without accidentally changing them. The most common examples are letterheads, fax headers, reports etc. Word actually comes with a large range of templates but you can also create as many as you want of your own.

    You'll learn: Where Word gets the page settings when it creates a blank new document. Where to find the many 'pre' created Word templates that come with the program, and how to start building your own professional templates.

    You'll understand the commom mistakes that people believe about templates and use them more effectively in your workplace, own business or even in a schooling environment to create professional documents over and over.

    Best of all, the great work you produce will be consistantly professional.

  • Customising toolbars: If you are familiar with the current standard and formatting toolbars you'll be happy to hear that you can do much more with them. You can turn unused buttons off and put buttons on the toolbars for tools that you use more frequently. This is a great way to put all your commonly used tools on the screen in one place.

    You'll learn: How to completely customise your toolbars, turn buttons on and off using the toolbar options button. Put a button on any toolbar for virtually any command from the menu list options. 

    Learn how to turn "Screen Tips" function on, show shortcut keys in the menu list and display each font (from the font drop down list) in it's own style. These customisations just help to make your life little easier when using Word.

    Learn how to apply your own keyboard shortcuts to commonly used commands (this is available for literally hundreds of commands and if you really want to save time by using your keyboard or impress someone in your office this tool is very handy).

    Learn how to put a button in the toolbar that inserts the date in the format of your choice. These skills can be used to put other buttons on the toolbar.

    Automatic Features: There are many automatic features in Word and many of them are turned on automatically when Word is installed on your computer. Some of these features include: AutoCorrect for spelling mistakes, initial capitalisation (THis is an example), Accidental use of Caps Lock (eg. aLBATROSS), automatic conversion of 1/2 to ½ etc etc.

    You'll learn: Where to go to see the features that have been turned on and how to turn them off if you find them too annoying. You'll learn what these features are called and how to use them in more detail to make your life much easier. For example if you work in a doctors surgery or a legal firm where you constantly use long names, you can type in an abbreviation instead and Word will fill the rest of the name in.

    You'll learn how to quickly make common symbols appear like the copyright and trademark symbols, how to convert 1st to 1st how to make sure that Word uses smart quotes (eg. replace "testing" with “testing”). You'll also learn how to make sure that when you type an email address or website address that Word DOESN'T convert it into a hyperlink.

    These skills will give you trememdous confidence and bring you to an intermediate skill level in Word.

    Program Options: This is the point where you can really make some substantial changes to how Word operates, from simple turning on and off of some view options, converting the measurement in your rulers to centimetres or inches or points etc, change the number of recently used files that you see in the File menu, to more advanced Text editing options like turning drag-and-drop on/off etc.

    You'll learn how to take complete control of Word, using features that you may never have thought you could have control of. These names may not make sense but after you have completed this module it will:

    • Typing replaces selection
    • INS Key for paste
    • Smart Cursoring
    • Smart paragraph selection
    • Smart cut and paste etc etc

    You'll learn how to turn spelling and grammar on and off and customise the rules it uses when performing these actions, and how to change the user information.

  • Symbols & clipart: Learn about Webdings, windings, ZapfDingbats and many other fonts that are actually specific fonts used to show symbols. These symbols are used in bulletted lists as well as throughout text. Also learn how to use Clipart to make your document much more colourful.

    You'll learn: How to insert symbols by choosing from a large range of options and understand that these symbols can be formatted just like text. You can enter many symbols in one go and then drag and drop them around the document to where-ever you want them.

    Clipart: Learn about the insert clipart pane and how to search for clipart using keywords. Learn how to use the Clipart organiser to accumulate any images that are currently on your computer so that you can manage those images, plus any clipart that came with the software in the one place.  Learn how to get to clipart images online. Learn how Images/clipart appear when they are first inserted into your document and much more...

    Image Files: These images are files that have either been downloaded from the Internet, taken with a digital camera or scanned from a photograph and they are full colour images (although they can also be black and white and greyscale) that are stored on your computer as a file. A good example of this is a logo. Your logo can be stored on your computer and then used in templates or fliers and brochures and price lists.

    You'll learn: How to insert images that are stored on your computer as a file, how to resize and re-colour them, plus change their contrast and brightness. These changes are only applied to the photograph while that photo is within your document (it doesn't change the actual image file). Learn how to turn the Picture toolbar on and off and also how to crop and rotate an image.

    Compress an image to make the file smaller so that the Word document can be sent faster via the Internet. Learn how text wraps around images and change it. You'll learn about "in line with text" and how an image when initial inserted acts just like any other character. Learn how to change the text wrapping to Square, In front of text and even behind the text as a watermark.

    You can now start to use these skills and the previous modules to create professional and colourful documents using images. If you want to know a bit more about how to edit images, see our module 109 and 109a.

  • This course will teach you about using the large range of drawing tools that are available with Microsoft Word. Tools like inserting charts, callouts and banners, block arrows, organisational charts, flow diagrams and connectors and much more.

    The workbook for this course is available now and videos are coming...

  • Data: Understand the structure of data, fields & records, Creating a data table, forms for working easier with data tables, table and form views, creating new records, data formats including tab and comma delimited text, Sorting data and deleting rows.

    Mail merge: mail merge basics, connecting to data sources, inserting merge fields, filtering and selecting data, editing merge recipients data,  previewing merged results, different merge options, merging to a new document, saving changes to merge files.

    Labels and envelopes: Customise your label, text formatting within the label, label size options, create new label templates for future use, printing addresses on envelopes, adding an envelope to your document and more...

  • The Screen: Get to know the name of all the different parts of the screen and what they do, including toolbars, menu bars, task pane, status bar etc. Customise your screen so that it is familiar to your preferences, including turning toolbars on/off.

    Change the measurement units, recently used documents and personalised menu settings. Change the zoom and understand that it only affects how you see things on the screen as opposed to how the document prints out.

    Understanding the Open dialog box and how to look into different folders to find a file and open it. Once the file is open you'll learn how to get some fundamental information about that document, including how many pages and sections are in the document.

    Editing Text: Understanding the mouse and text cursors and where text appears when you start typing. Move the text insertion point using both the mouse and keyboard, and move even faster where you want the text cursor using the Ctrl key in combination with the direction keys (also called Arrow keys).

    Use the page up, page down, home and end keys to move around your document even faster. Learn how to edit and delete text using the Backspace and Delete keys,

    Non-Printing Characters: Learn how the Enter, space bar and tab keys put a "non-printing" character on the screen. These characters do not print, but can be edited just like normall letters and numbers (in other words the can be deleted).

    Saving: Understand how to save files, where files are stored and file names, also learn the keyboard shortcuts for this command. Understand the principles involved in saving a file for the first time, subsequent saves and using Save as.

    Selecting text: Learn how to select text using the mouse, keyboard and the Select All command. Learn how to undo any changes you make because new users to Word will often accidentally delete text and the best way to get it back is to Undo it. Learn about the 3 ways of Undoing.

    Understand where the selection bar is and use it and a combination of clicks, double-clicks and tripple clicks to select words, paragraphs and the entire document. Learn also about some common problems that people encounter when selecting text.

    Use the SHIFT key on the keyboard to select text and combine it with other keys to select large amounts of text quite quickly. The more you learn to use the keyboard shortcuts, the faster it will be to create and edit your documents.


  • Formatting: Text formatting effects individual characters that first need to be selected (highlighted). You'll learn about changing the font, font size, style, colour, how to make characters bold, italic and underlined and how to make several of these changes at the same time using the mouse via the formatting toolbar and the Font formatting dialog box that is accessed via the menu bar.

    Learn about default settings, in particular how to change the default font that is used in most "Normal" documents and learn how to use Format Painter to make formatting a breeze.

    Page Formatting: Learn about the various page setup options and how to change the default Page Settings for "Normal" documents.

    This section will show you how to make the page print sideways (landscape) or tall (portrait) - this is called Orientation and how to change your side and top and bottom margins (distance that text appears from the edge of the page).

  • Paragraphs: This topic is one of the hardest concepts to master for those starting out using Microsoft Word, yet it is a fundamental skill that helps you master other like tabs, indenting, and even advanced tools like styles and templates.

    Topics include understanding how the Enter key separates each paragraph and that a line with nothing in it except the enter character (also called carriage return) can contain paragraph formatting. You'll learn how to select paragraphs to change their paragraph formatting (different from font formatting).

    Line spacing and the amount of space before and after a paragraph can also be applied using paragraph formatting tools.

    Borders and Shading: This is a very simple tool to use initially, but it can get more confusing depending on "what" you want to apply the formatting to. You can apply the formatting to text, paragraph(s) or entire pages.

    Topics Covered: Understanding the tool buttons on the borders and shading toolbar, applying borders to paragraphs that contain indenting, and to several paragraphs at once.

    You also learn about different shading options (again, you can get different formatting for text and paragraphs) and learn how to combine text and paragraph shading for that added effect in your documents.

    Bullets and Numbering: These tools provide a great way to make the information in your document easy to read. It also helps to highlight the main points and can show you main topic headings and sub-categories.

    You'll learn: How to start using bullets and numbering using some automatic tools (this is an easy way to get started and it also teaches you how to deal with automatic bullet and number formatting if it happens and you don't want it to).

    Change the type of bullets or numbering used (including the use of letters), edit and existing numbered list (to insert points in the middle) and get an introduction to how numbering styles are used (Styles are covered in more detail in a later Word module).

    Learn how to change the spacing between the margin and the bulletted list and between the bullets and the text. This is particularly important if you are going to work with large bullets.

  • Tabs: Tabs are primarily used to provide structed spacing across the page in Word documents. It is ideal where you have a list of information like a price list or a database of names. Tab is a "non-printing" character (similar to space) that doesn't print, but it makes your text cursor line up at a given marker, that you can see in the ruler.

    You should have a solid understanding about paragraph formatting before you attempt this module.

    You will learn: There are default tab markers in the ruler (usually set at every 1/2 inch) and how to use the tab key to make text line up. You'll learn about the difficulties that people have understanding the tab character and how to delete tabs to fix most common problems.

    Just like the good 'ole manual typewriter, you can actually set tabs where you want them so that you don't have to continuously press the tab key to make text line up. It also gives you much more control for when you want to change how the text lines up.

    You'll learn about the many different type of tabs that you can set and when to use them (for example, you can make a column of dollar figures line up to the decimal point). You'll learn how to use the menu bar option to set and change tabs using the tabs 'dialogue box'. This is a great tool if you get stuck and simply want to remove all 'set' tabs.

  • Tables: Tables are a great tool to help you structure your data. The concept of tables is similar to using tabs (yet much more powerful in terms of layout) and a simpler than using a spreadsheet (eg. Excel).

    There are more formatting options in relation to borders and fill colours that make Tables very powerful and you can incorporate images into each of the cells of the table.

    You'll learn: How to insert a table using the menu bar and toolbar methods, how to choose the number of rows/columns you want in your table and deleting cells/columns and rows that you don't need.

    You'll learn how to resize parts of a table visually using your mouse or using a dialog box and you'll learn how to select the various parts of a table to then apply formatting or edit the contents.

    You'll learn: how to enter information into cells, how to alter the text and  paragraph formatting within a cell using the Table properties dialog box.

    How to merge cells (ideal if you want to create a heading or have large areas within your table for information) and split them to further structure your data.

    These skills give you complete control over the more intricate tools that are available within a table.

    You'll learn how to apply text formatting to individual cells and use the format painter option to make it much easier to duplicate. You'll learn how to change vertical as well as horizontal justification (alignment).

    Table gridlines can be turned on or off for viewing and border formatting can also be applied if you want lines to appear when printing your table.

    You can also apply shading and bullets within each cell of a table and you'll learn how to perform these actions.

  • Office Clipboard: This tool enables you to "collect" many pieces of information from any office program that is running so that you can then paste them all in one document it you want to. It also enables you to collect many pieces of information (text, images etc) and then have them available for you when you are ready to paste. It takes the concept of copy and paste to the next level.

    You'll learn how to make the Office clipboard appear automatically, copy and paste text using the office clipboard and deleting all information that is stored on the office clipboard onces you have finished with it.

    Learn about: Page breaks to help keep headings at the top of the page. You can use both the mouse (an menu bar options) or keyboard shortcuts to insert page breaks and you will also learn how to view the page breaks and delete them when they are no longer needed.

    Symbols are used to produce a creative effect in documents and especially when using bullets. There are symbols that represent commonly used information like Telephone, fax and email symbols.

    You'll learn: How to insert symbols and understand symbol subsets. There are literally hundreds of symbols and you can even use keyboard combinations to make symbols appear on your screen. A good example of when these symbols are used is foreign language symbols.

    Some common symbols are © and ® and you'll learn how to get these and many more symbols like them into your document.

    Headers and Footers: This tool enables you to insert text or symbols in your document. they normally appear at the very top and bottom of your document and contain information about the document such as filename, page numbers, copyright information etc.

    You'll learn: How to move from the document to the header/footer and back to the document, how to switch between the header and footer and how to quickly move around these areas using your mouse.

    Use tabs in the header/footer to professionally align the information and insert very quickly some document information with only a couple clicks. Information like the current date/time, total number of pages, filename and many more.

    Templates: this tool enables you to create professionally laid out documents once, and use them over and over again without accidentally changing them. The most common examples are letterheads, fax headers, reports etc. Word actually comes with a large range of templates but you can also create as many as you want of your own.

    You'll learn: Where Word gets the page settings when it creates a blank new document. Where to find the many 'pre' created Word templates that come with the program, and how to start building your own professional templates.

    You'll understand the commom mistakes that people believe about templates and use them more effectively in your workplace, own business or even in a schooling environment to create professional documents over and over.

    Best of all, the great work you produce will be consistantly professional.

  • Customising toolbars: If you are familiar with the current standard and formatting toolbars you'll be happy to hear that you can do much more with them. You can turn unused buttons off and put buttons on the toolbars for tools that you use more frequently. This is a great way to put all your commonly used tools on the screen in one place.

    You'll learn: How to completely customise your toolbars, turn buttons on and off using the toolbar options button. Put a button on any toolbar for virtually any command from the menu list options.Â

    Learn how to turn "Screen Tips" function on, show shortcut keys in the menu list and display each font (from the font drop down list) in it's own style. These customisations just help to make your life little easier when using Word.

    Learn how to apply your own keyboard shortcuts to commonly used commands (this is available for literally hundreds of commands and if you really want to save time by using your keyboard or impress someone in your office this tool is very handy).

    Learn how to put a button in the toolbar that inserts the date in the format of your choice. These skills can be used to put other buttons on the toolbar.

    Automatic Features: There are many automatic features in Word and many of them are turned on automatically when Word is installed on your computer. Some of these features include: AutoCorrect for spelling mistakes, initial capitalisation (THis is an example), Accidental use of Caps Lock (eg. aLBATROSS), automatic conversion of 1/2 to ½ etc etc.

    You'll learn: Where to go to see the features that have been turned on and how to turn them off if you find them too annoying. You'll learn what these features are called and how to use them in more detail to make your life much easier. For example if you work in a doctors surgery or a legal firm where you constantly use long names, you can type in an abbreviation instead and Word will fill the rest of the name in.

    You'll learn how to quickly make common symbols appear like the copyright and trademark symbols, how to convert 1st to 1st how to make sure that Word uses smart quotes (eg. replace "testing" with “testing”). You'll also learn how to make sure that when you type an email address or website address that Word DOESN'T convert it into a hyperlink.

    These skills will give you trememdous confidence and bring you to an intermediate skill level in Word.

    Program Options: This is the point where you can really make some substantial changes to how Word operates, from simple turning on and off of some view options, converting the measurement in your rulers to centimetres or inches or points etc, change the number of recently used files that you see in the File menu, to more advanced Text editing options like turning drag-and-drop on/off etc.

    You'll learn how to take complete control of Word, using features that you may never have thought you could have control of. These names may not make sense but after you have completed this module it will:

    • Typing replaces selection
    • INS Key for paste
    • Smart Cursoring
    • Smart paragraph selection
    • Smart cut and paste etc etc

    You'll learn how to turn spelling and grammar on and off and customise the rules it uses when performing these actions, and how to change the user information.

  • Symbols & clipart: Learn about Webdings, windings, ZapfDingbats and many other fonts that are actually specific fonts used to show symbols. These symbols are used in bulletted lists as well as throughout text. Also learn how to use Clipart to make your document much more colourful.

    You'll learn: How to insert symbols by choosing from a large range of options and understand that these symbols can be formatted just like text. You can enter many symbols in one go and then drag and drop them around the document to where-ever you want them.

    Clipart: Learn about the insert clipart pane and how to search for clipart using keywords. Learn how to use the Clipart organiser to accumulate any images that are currently on your computer so that you can manage those images, plus any clipart that came with the software in the one place. Learn how to get to clipart images online. Learn how Images/clipart appear when they are first inserted into your document and much more...

    Image Files: These images are files that have either been downloaded from the Internet, taken with a digital camera or scanned from a photograph and they are full colour images (although they can also be black and white and greyscale) that are stored on your computer as a file. A good example of this is a logo. Your logo can be stored on your computer and then used in templates or fliers and brochures and price lists.

    You'll learn: How to insert images that are stored on your computer as a file, how to resize and re-colour them, plus change their contrast and brightness. These changes are only applied to the photograph while that photo is within your document (it doesn't change the actual image file). Learn how to turn the Picture toolbar on and off and also how to crop and rotate an image.

    Compress an image to make the file smaller so that the Word document can be sent faster via the Internet. Learn how text wraps around images and change it. You'll learn about "in line with text" and how an image when initial inserted acts just like any other character. Learn how to change the text wrapping to Square, In front of text and even behind the text as a watermark.

    You can now start to use these skills and the previous modules to create professional and colourful documents using images. If you want to know a bit more about how to edit images, see our module 109 and 109a.

  • This course will teach you about using the large range of drawing tools that are available with Microsoft Word. Tools like inserting charts, callouts and banners, block arrows, organisational charts, flow diagrams and connectors and much more.

    The workbook for this course is available now and videos are coming...

  • Data: Understand the structure of data, fields & records, Creating a data table, forms for working easier with data tables, table and form views, creating new records, data formats including tab and comma delimited text, Sorting data and deleting rows.

    Mail merge: mail merge basics, connecting to data sources, inserting merge fields, filtering and selecting data, editing merge recipients data,  previewing merged results, different merge options, merging to a new document, saving changes to merge files.

    Labels and envelopes: Customise your label, text formatting within the label, label size options, create new label templates for future use, printing addresses on envelopes, adding an envelope to your document and more...

  • 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.


  • Selecting information: Understanding the mouse cursors used within Excel, how to select cells, columns and rows and multiple ranges of information, how to select cells using the keyboard.

    Copy and Paste: Drag and drop, cut, copy and paste in a worksheet and from one worksheet to another and even between different software programs.

    Editing cells: Typing and entering information, editing existing information and entering the changes, using the status bar information, escaping out of cells. Changing column width and row height for single and multiple columns as well as making all the columns the same width and using AutoFit.

    Database: Creating a simple database, understanding simple database structure (ideal knowledge for mail merge with Microsoft Word), Inserting and deleting columns, using Undo and redo options.

    Autofill: Automatically fill numbers, dates, number patterns, days, months and years and much more. The fast way to insert sequential numbers and words. Understanding date formatting (this forms the basis for future calculations based on date format).

  • Formulas: Entering formulas using the keyboard, arrow keys and the mouse, understand the importance of relative cells references, common formula errors, using multiplication and division and how to combine two formulas in one.

    AutoCalculate: Get quick additions and basic functions quickly without having to enter formulas.

    Functions: Introductions to functions and function syntax, Autosum, Autosum for several and selected ranges and an introductions to other basic functions like Maximum, Minimum, Average and more...

    Functions: Sum function in more detail, using the formula bar and editing functions, using the F2 key, using Autofill to save a lot of time copying (or filling) functions using relative cell references.

    Formatting: This effects the way your spreadsheet looks, everything from lines, colours, shading, and even the format of text and numbers. Topics include: Currency formatting, date and text formatting, merging cells and centering, Alignment formatting and text control within single and  merged cells, fill colour, font colour and Borders.

    Advanced formatting: Autoformats that allow you to quickly make your spreadsheet look very professional, repeat last action, and format painter make it faster for you to duplicate commands and formatting, using format painter with entire spreadsheets to apply multiple formatting in just a couple clicks.

  • Views: There are several ways you can view your spreadsheet on the screen and each has its own purpose. The most important thing to note is that none of these views affect the way your spreadsheet prints. Topics include: Zoom (set and custom), Print Preview and page break preview versus Normal view.

    Page Setup: Including page orientation, Scaling and margins, and changing these settings.

    Print areas: Setting and clearing defined print areas, understanding the difference between default and set page breaks, Inserting and moving page breaks, Changing the print order of pages, centering the spreadsheet when printing and showing/hiding gridlines and headers.

    Introduction to headers and footers, using preset and custom headers and footers, including the use of file information and common fields.

    Freezing panes when viewing so that certain information headers remain on the screen while you scroll through lists, and Repeating rows so that when the information is printed rows or column headers are repeated.

    Printing options.

  • Charting: Creating a simple chart and learning that charts are dynamic and based up on the information stored somewhere else within the spreadsheet, Inserting labels for heading, the x & y axis, values and more. Learning how to chart mutliple rows and columns

    Charting: Organising your sheet tabs, especially for new chart sheets, changing the data range within the chart wizard, charting several separate data ranges, charting options and different types of charts (pie charts)

    Chart formatting: Understanding chart objects for the purpose of formatting, understanding the buttons in the chart toolbar, and using right-click to format. Formatting a data series, and parts of a pie chart, having 2 different data formats within the one chart and how to get charts into Microsoft Word documents.


  • Number and percentage formatting: Understanding the various ways of formatting, including the understanding form percentages to better use them in formulas and functions.

    Understand that cells can be formatted (even without data in them) so that when you enter data, it can look completely different to what you expected to see.

    Sometimes cells can be formatted in such a way that even though you enter numbers, a date may be shown. Learn about why in this section.

    Relative and Absolute Cell references: Understand how relative cell referencing works to help you copy formulas and functions quickly. Also understand where they don't work and why.

    Absolute cell referencing is a powerful way to reduce the amount of calculations you have to create and can save several columns or rows of typing. Learn the different types of and how to use absolute cell references in this section.

    Learn and understand some fundamental mathematical functions that will help you perform most formulas and functions. These are fundamental skills that will help make more complicated functions easier to understand.

    Understand how to combine two formulas into one and as a result write much better formulas and get to know the order of mathematical calculations.

    Using Functions like Maximum, Minimum and average

    Getting to know the "Insert Functions dialog box", how to search for a particular function and understand the concept of "arguments" (or syntax) in functions and function categories such as financial, Date and time, maths and trig, etc.

    Understanding and constructing an IF Statement.

    Comments: Understand the uses for comments. Insert comments that help to explain the purpose of a cell, choose the size and location of the comments and control the way they appear on the spreadsheet.

    Edit comments and change the formatting within a comment, change the name of the person who made the comment, and make sure that the comment appears all the time or only when you move the mouse to it.

    Show/Hide Columns/Rows: Learn how to hide columns or rows that contain confidential information. This way you can print the spreadsheet out without the confidential information, but use the confidential information to perform the necessary calculations.

  • 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. 
  • 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.
  • 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.
  • Start creating great looking presentations within 2 hours. This module takes you through the fundamentals of slides, the outline pane, notes pane, plus slide transitions and how to navigate through and control a presentation.

  • Once you understand the basics of PowerPoint, this course will take you through how to format text and all the contents of text frames, how to select multiple frames and apply broad formatting, understand bullet formatting and how to customise bullets and change indenting using the ruler. You'll learn about using tabs in PowerPoint (slightly different to using Microsoft Word) and also Format Painter to repeat existing formatting much faster.

    You'll insert a PowerPoint chart and see the why this is more beneficial than copying and pasting a chart from Excel (much better for visually showing different components of the graph to your audience).

    You'll learn how to use the Outline Pane to create a powerpoint presentation quickly, and the function of promoting and demoting as well as re-arranging various parts of a presentation.

    Slide Sorter to arrange the slides in your order of preference and also how to very quickly give a presentation a professional appearance with the use of Design Templates. These can also be created for companies so that all presentations have the same look and feel.


  • Welcome to our online MYOB training video tutorials. You are welcome to look through twenty of our training videos covering various aspects from setting up a company file and your invoice forms to entering day to day transactions using MYOB accounting software.

    If you enjoy and learn from our videos, then you can save a lot of money by learning online from the comfort of your own home/office and you'll be able to keep watching and referring to the information in these videos for as long as you have access.


  • If you see this information and you've already enrolled, scroll to the bottom to enter your enrolment key (password)... You WILL need to refer to your WELCOME EMAIL from EzyLearn to get this.

    This MYOB Setup course uses MYOB AccountRight Plus version 15-19.5 which is ideal if you already have the software. See our other Setup course if you are using the latest version of MYOB.

    This section contains video and workbook exercises to show you how to set up your company information, chart of accounts (Accounts list) and Entering opening balances. You'll learn about the MYOB data file, the setup of your sales module, invoice layouts, setup your default payment terms, Create customer cards, enter opening balances, Setup the purchases module and understand how to modify your preferences. There's an introduction to tax codes, chart of accounts and linked accounts.

  • If you see this information and you've already enrolled, scroll to the bottom to enter your enrolment key (password)... You WILL need to refer to your WELCOME EMAIL from EzyLearn to get this information.

    This MYOB Setup course uses MYOB AccountRight Live Plus version 2012 Which is ideal if you don't already have the software on your computer

    This section contains video and workbook exercises to show you how to set up your company information, chart of accounts (Accounts list) and Entering opening balances. You'll learn about the MYOB data file, the setup of your sales module, invoice layouts, setup your default payment terms, Create customer cards, enter opening balances, Setup the purchases module and understand how to modify your preferences. There's an introduction to tax codes, chart of accounts and linked accounts.

  • If you see this information and you've already enrolled, scroll to the bottom to enter your enrolment key (password)... You WILL need to refer to your WELCOME EMAIL from EzyLearn to get this.

    This MYOB Setup course uses MYOB AccountRight Plus version 15-19.5 which is ideal if you already have the software. See our other Setup course if you are using the latest version of MYOB.

    This course gives you the MYOB skills that most businesses need on a daily basis. Including creating quotes, then orders and then invoices, changing (product or inventory) item information, credit terms, using the different invoice formats, including time billing, how to create and delete text headings, finding historical transactions, understanding the Sales Register, Sales Journal, To Do list, Accounts Receivable and Payable reports and Custom lists, plus an introduction to Statements. You also learn about the statement option, recording cash sales, entering credits, settling credits, how to deal with bad debts, deleting sales payments, and reversing credits. Receiving payments while invoicing, after invoicing, part payments, and over payments. Purchases: Creating a purchase order, convert a PO to a bill, creating an item credit, settling and reversing credits, and analyse purchases. Banking: Learn to enter income and expense transactions with recording sales invoices or purchase orders.


  • If you see this information and you've already enrolled, scroll to the bottom to enter your enrolment key (password)... You WILL need to refer to your WELCOME EMAIL from EzyLearn to get this.

    This MYOB Setup course uses MYOB AccountRight Live Plus version 2012 which is ideal if you already have the software. See our other Setup course if you are using the latest version of MYOB.

    This course gives you the MYOB skills that most businesses need on a daily basis. Including creating quotes, then orders and then invoices, changing (product or inventory) item information, credit terms, using the different invoice formats, including time billing, how to create and delete text headings, finding historical transactions, understanding the Sales Register, Sales Journal, To Do list, Accounts Receivable and Payable reports and Custom lists, plus an introduction to Statements. You also learn about the statement option, recording cash sales, entering credits, settling credits, how to deal with bad debts, deleting sales payments, and reversing credits. Receiving payments while invoicing, after invoicing, part payments, and over payments. Purchases: Creating a purchase order, convert a PO to a bill, creating an item credit, settling and reversing credits, and analyse purchases. Banking: Learn to enter income and expense transactions with recording sales invoices or purchase orders.

  • If you see this information and you've already enrolled, scroll to the bottom to enter your enrolment key (password)... You WILL need to refer to your WELCOME EMAIL from EzyLearn to get this.

    This MYOB Setup course uses MYOB AccountRight Plus version 15-19.5 AND version 2012 and 2013 for newer content including bank feeds.

    Pre Requisite: You should completed the Day-to-Day Transactions Course before attempting this course.

    This course demonstrates the skills to reconcile a bank account, including entering automatic payments like bank charges, direct debits etc and receipts from Credit card purchases. Bank Reconciliation ensures that the information you've entered into your MYOB accounting software matches the information on the bank statements. Sometimes there are missing entries and finding and entering these transactions to balance the accounts can be time consuming and finicky. This module flows on from and re-enforces the Banking Command Centre information (spending and receiving money) included in the latter part of MYOB Day-to-Day Transactions Course (code 502).

  • This course will take you through various aspect of using MYOB Reporting features to generate reports that you give you useful data about business performance. This course covers Balance Sheet and Profit and Loss Reports as well as GST reports and how to complete your BAS using MYOB's BASlink. You'll learn how to setup your BAS Info and backup the completed BAS report for that period. We've also included training on setting up and using Jobs (used widely to match income and costs for specific jobs in the building trade) including budgets, allocating revenue and expenses, reporting for jobs and setting up and closing a job.

    Assets and Depreciation, including Motor Vehicle purchase, accelerated depreciation, general small business pools, and more..


  • If you see this information and you've already enrolled, scroll to the bottom to enter your enrolment key (password)...

    This course shows you how to navigate around the Payroll and Card File command centres in MYOB for the purpose of viewing, creating and editing information and transactions regarding payroll for employees.

    The course goes through various payroll categories like hourly and salary wages, allowances and re-imbursements, bonuses and commission, deductions, superannuation and tax.

    You'll learn how to view and reprint historical transactions, products reports and perform end of period activities. You'll also learn how to setup employees, assign payroll categories, perform pay runs, provide pay slips, create payment summaries, run reports to reconcile your wages and perform end of year activites relating to payroll.

  • Microsoft Outlook is used more and more by both small business and corporate users because it incorporates some tremendous time management and people management resources.

    This course takes you through the different tools that are available in this program including: Emailing, Contact Management, Calendar and managing appointments, Tasks and Notes.

    Learn how to change how you view these tools on the screen and turn panes and toolbars on and off.

    Learn how to store information about your contacts (suppliers, clients, friends etc) and how to categorise and group them for some excellent reporting.

    Learn how to create appointments, block appointments in your day, include details about other people who will be at those appointments, and much much more.

  • Understanding the components of a WordPress website, how to get to the administration area and how to login. Once you have logged in get to know about your Website Dashboard and administration area.

    Understand the difference between pages and posts and how WordPress can be used simply as a website management system OR a blog. The Blog functionality can simply allow you to create press releases or news articles for your business.

    Once you understand how pages work you can create as many pages as you like and even structure nested pages which create a drop down menu system. Learn about posts and start creating short articles with tags and categories to improve your google page ranking using on page Search engine optimisation (SEO).

    Learn how to manage the use of images within your website: including header image, images within posts and in other areas of your site.

    Learn how to create hyperlinks to other pages or posts within your website as well as external links and even PDF’s and other downloadable files.

    Using WordPress is similar to using a Word Processing program, but you also have the ability to work in HTML code. This is very handy when you want to get Google Analytical code onto your pages or insert a PayPal button.

    A Blog (or the posts part of your WordPress website) can be syndicated and used on other websites across the world using a format called RSS (Really Simple Syndication), we explain how it works and also show you how to convert your blog into a fully anti-SPAM compliant email newsletter.


  • Selling is something most people do when they really want something. Some people are good others not so good, but selling is not really about pushing a product or service, it's about find people who need what you have and then finding out how much they need it and how you could help them using it. This course takes you through some videos to help demystify the sales process.
  • This course will demonstrate how an online business manages its website contents and online marketing to increase website traffic, provide better support and enable customers to understand how the business provides it's services.