|
Welcome to EzyLearn Online!
Welcome to the EzyLearn online training course for MYOB accounting software and Microsoft Office. If you haven't done so already, take the tour and see how our online learning works otherwise login, enter your enrolment keys (if it's your first time) and start your course.
Please call us on (02) 9971 0000 or from anywhere in Australia on 1300 888 869 if you have any questions or want more information.
Click here to enrol 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 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 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 12 months. Your online educational library. If you see this information and you've already enrolled,scroll to the bottom to enter your enrolment key (password)... 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 and where it is stored and how to customise the features of MYOB software. You'll learn about the setup of your sales module, the various layouts that are available to you and how to choose the best one for your business and setup your default payment terms (how long you give people to pay you). Create customer cards (your database with customer details) and enter opening balances (eg. sales that have been recorded before MYOB was setup). Setup the purchases module and understand how to modify your preferences (particularly relating to Sales and data file security). There's an introduction to tax codes, chart of accounts and linked accounts (makes the double entry of accounting easier than performing manual tasks). You'll discover the sales module and inventory in more detail and learn about the different types of Cards (supplier, customer etc), including where to store client bank account details, email address (if you want to email your invoices) etc. You'll learn how to set different payment terms and invoice layouts for selected customer cards and more.. You'll learn about session reports and activating your company file, delaying your company file activation while you are learning so that you can practise. You'll discover the results of the preferences that you set up in previous videos, like prompts for backup, session reports and more. Learn how to backup your MYOB data including file location and backup file types and how to restore that file in case you need to. If you see this information and you've already enrolled, scroll to the bottom to enter your enrolment key (password)... This course gives you the skills that you will need in most businesses to use MYOB software on a daily basis. Including creating quotes, then orders and then invoices in the sales system, changing item information and credit terms "on the fly" while you are creating an invoice. Understand the different invoice formats, including time billing, how to create and delete text headings and more. Finding historical transactions is a major part of accounting software. In this course you'll learn about the Sales Register, Sales Journal, To Do list, Accounts Receivable and Payable reports and Custom lists, plus an introduction to Statements so that you can supply your clients with a summary of funds owing to you. You also learn about the two main type of statement so you can choose the one that suits your needs. This course also includes recording cash sales, entering credits, settling credits, how to deal with bad debts, deleting sales payments, and reversing credits. Receiving payments: You'll learn how to do this while invoice, after invoice, part payments, and over payments. Purchases: You'll how to keep track of your purchases whether you pay for them straight away or receive an account. Creating a purchase order and convert it to a bill, creating an item credit, settling and reversing credits, and analyse purchases. Banking: If you make purchase or income transactions that have nothing to do with the sales or purchases modules, then you'll learn how to make these entries using the banking module. If you see this information and you've already enrolled,scroll to the bottom to enter your enrolment key (password)... 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 module 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 and other aspects of the business operations. 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. 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. 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.
| |
