MYOB Accounting

These courses are available at www.myobcourse.com.au, and if you 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!

MYOB Setup (501)

Accounting basics, Starting MYOB, Navigating around the MYOB program, Creating a company file, Setting up accounts, Data Entry and Record selection options, Contact log, to-do list, Creating and deleting accounts, Opening balances, Sales & purchases layout options, Invoicing and Payment defaul settings, Linked accounts,

Creating Cusomter Cards, Historical sales, Security and Sales preferences in MYOB. Tax code intro, Edit and delete linked accounts, Extra card file details, Create items and extra item information, Inventory opening balances and adjusting inventory balances.

Closing and backing up your MYOB datafile, using multiple disks, opening a newly created file (Activating a company file), Restoring an MYOB backup datafile.

MYOB Invoice form layout options, tax inc versus tax ex, text fields and data fields, deleting, moving and resizing fields, customising toolbar, MYOB printed form properties, field text formatting, copy and paste logo into your MYOB form, inserting logo image, and performing an Initial Bank reconciliation in MYOB.

MYOB Day to Day (502)

Processing Sales using MYOB (entering items, editing item details, changing payment terms, time-billing and printing, creating a quote or sales order, converting quote to order and order to invoice, using the sales register for quick conversions, insert and delete lines and headings)

Finding transactions in MYOB (Sales register, transaction journal, To MYOB Do list, accounts payable and receivable, Intro to and finding statements, MYOB keyboard shortcuts, receiving payments and paying bills, custom lists in Sales and purchasing modules)

Printing MYOB receipts (also emailing MYOB forms instead, printing one at a time or in batches, printing statements, statement types, activity statements)

Recording a cash sale in MYOB, entering credits, settling credits and returns, bad debts, deleting payments and sales, reversing transactions, creating a card on the fly, creating an MYOB inventory item. Applying a payment while invoicing in the MYOB sales screen, undeposited funds account, receiving part payments, receiving over payments.

MYOB Bank Reconciliation (503)

Learn how to create a loan account, transfer money into it, setup the accounts payable linked account, editing and deleting transactions (important at reconciliation time), the difference between sales and purchases modules and entries in the banking module, reconciling bank account entries with your statement, opening balance, closing dates and more…

MYOB Payroll – beta (505)

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.

[button link=”https://ezylearn.com.au/products-page/”] Enrol Now[/button]

Microsoft Excel

All of these courses are available at www.excelcourse.com.au, and if you 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!

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.

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,

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

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.

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.

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.

[button link=”https://ezylearn.com.au/products-page/”] Enrol Now[/button]

Microsoft Word

All of these courses are available at www.wordcourse.com.au, and if you 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!

Microsoft Word (module 201)

Get to know the Word screen, Toolbars (turning on and off and moving them), view icons, show/hide and zoom, default settings, browse objects button, Find & Goto, Highlighting text using the mouse, keyboard & selection bar. Drag & drop, insert & delete text, show/hide, carriage returns, recently used file list.

Microsoft Word (module 202)

Automatic and as you type Spelling checking, quick ways to correct mistakes, saving files, text formatting, repeating common commands, character spacing and snazzy text effects, stretching and compressing text, format painter, copy, cut and paste within and between different documents, repeated pasting, collect and paste, undo and redo, print preview toolbar, printing options…

Microsoft Word (module 203)

Working with the ruler, paragraphs and page formatting, left and right indents, hanging indents, orientation, alignment & justification, font formatting, line spacing, bullets, Paragraph and page borders & shading, create professional letters.

Microsoft Word (module 204)

Understand different tab types, default tabs, combing tab key with tab stops, use tabs on the ruler, tabs as paragraph formatting, using and deleting set tabs, set tabs, leaders using the menu bar, create a price list, convert a tabulated pricelist into a table.

Microsoft Word (module 205)

Understanding rows, columns and cells, inserting a table, changing the number of columns or rows, deleting, editing cells, selecting and formatting a table and cells within a table, merging cells, splitting and resizing cells & columns, paragraph formatting like bullets within a cell, borders and shading of a table.

Microsoft Word (module 206)

Inserting & deleting page breaks, inserting symbols, viewing headers & footers, tab formatting in header & footer, inserting page number and file name fields, header and footer toolbar, using existing templates, editing a template, saving the template as a file, the template wizard, creating a letterhead or fax template, converting a document into a template, using your new letterhead template.

Microsoft Word (module 207)

Quickly add / remove buttons from toolbars, put buttons on the toolbar for commonly used commands, use drop caps, insert date button, change the default date format, adding an automatic date to a template, inserting symbols like copyright, registered trademark etc, editing AutoCorrect & AutoText so that Word automatically performs tasks you would normally do, AutoFormat.

Microsoft Word (module 208)

Understanding image files, Inserting images from file, image handles, changing image properties, resizing and positioning images, cropping & rotating and wrapping text around images, brightness and contrast, cropping, set transparent areas, change an image to a watermark or greyscale and put it behind text, compress files, produce a party invitation, WordArt and 3D headings, using gradients and more…

Microsoft Word (module 209)

Inserting a chart in Word, edit and format the chart, how to find clipart, getting images from the net, understanding the clipart organiser, searching for free images on the Internet, text boxes, organisational charts, AutoShapes, arrows, callout boxes, connector lines, changing the order of objects (desktop publishing), select an object that is behind text and more…

Microsoft Word (module 210)

Data & Mail merge: Understand the structure of data, fields & records, forms for easier way of working with data tables, data delimiters, tabs and commas, navigating through records, mail merge basics, form letters, merge fields, working with data sources, other sources of data, previewing merged results, performing the merge…

Microsoft Word (module 211)

Sections, breaks and drawing objects: Understanding how sections work, continuous, column and page break sections, different page formatting for individual pages, make one page print sideways, choosing the number of columns, combining a section of 2 and 3 columns on the one page, making text start at the top of the next column, having different headers and footers for different sections, decide where you want the page numbering to start, inserting reference fields in the header/footer…

Microsoft Word (module 212)

Bookmarks hyperlinks and styles: inserting and naming bookmarks, getting to a bookmark, linking to a bookmark from another part of the document, exploring other places a hyperlink can point to, removing hyperlinks, hyperlink to an email address, using styles to give your document structure, inserting a table of contents, looking at a document map, understanding style formatting

[button link=”https://ezylearn.com.au/products-page/”] Enrol Now[/button]

Windows, typing, file management, email and Internet

These skills are considered fundamental in any office environment today so we have decided to make them freely available from our donation based website. Please feel free to acces the Windows and file management online training courses at no charge. We call these 6 courses our Computer Learners series.

Absolute Beginners (module 101)

OH&S, hardware, software, Turning on & shutting down, mastering Windows, desktop, startbar, short-cuts, using the mouse: double-click, right-click, click & drag, resizing & moving windows, dialog boxes, drop-down lists, scroll bars, display properties, maximise, minimise, restore, starting & using a program and closing it down. Customise your computer.

Software and Files (module 102)

Creating a new file (picture) and save files (file names), hard drives and disk drives, menu bar commands, save as, introduction to file management, creating and managing folders, opening files, moving files, file views (detailed, large, small icons etc). Learn to run several programs at once and switch between them and lots more…

Text editing & keyboard skills (module 103)

Title bars and menu bars, type a letter, text wrapping, moving around text, deleting and inserting text, file types, learn about the keyboard (Ctrl, Alt, Shift, Esc, Tab, Num Lock and lots more) and keyboard shortcuts. Saving files several ways, where to store and what to call files, understand file types.

File Management (module 104)

Delete files, recycle bin, restore files, Move files from hard disk to disk drive & vice versa. Work with Word, Excel and JPEG image files and programs that can edit then, understand the “path” as you look at folders and sub-folders and different “drives”, you’ll create a folder to put your files into and look at several ways of opening files.

The Internet (module 105)

Fundamentals: domain names, following hyperlinks, ISP’s, Webmail, html, Getting connected, Surfing: Going to web sites, temporary Internet file, Back, forward, stop, refresh & home, adding to and organising favourites, using a search engine, history (who has been where), opening multiple windows (save lots of time).

Email (module 106)

Email: Customise your screen, Send & receive emails, use coloured stationary, inbox, outbox, sent items folders, reply and forward, the address book, CC, BCC, broadcast to all your friends, managing emails, attaching files, Webmail when travelling & more…

[button link=”https://ezylearn.com.au/products-page/”] Enrol Now[/button]