|
 
How to Use This website
- Register as a student (it's free) - (look for the "Create New Account" link in the Login box at the top right)
- Sign in and Click on Excel course 301 to enrol and start the Microsoft Excel Beginners course now. It's also free and there is over an hour of training videos to watch!!
- Watch the videos, print the workbook and use the exercise files to master your new skills today
- If you like what you see in the Microsoft Excel beginners course (301), enrol in each of the courses one at a time for only $49 each (scroll down), OR all 5 following courses for only $199.00
REMEMBER: The first course is FREE (Microsoft Excel Beginners - Course 301). So, register for free now and see how our system works.
All the courses at this website will provide you with the skills you'll need to get to an Intermediate to Advanced level in Microsoft Excel. It contains information about Formatting, Formulas & Functions, Charts, database use, printing options, manipulating data and much more....PLUS, unlike most courses, you have access to the training material for 12 months. You can go over and over the training material as often as you want, when you need it.
There's a free Excel Beginners workbook that you can print and keep as a reference AND exercise files for you to practise what you see in the videos!
Our training content has been used and recommended by Employment agencies, CRS Australia, Workplace re-training for those who need to perform office jobs after an accident etc.
The skills taught in the entire series (courses 301 to 306) cover 90% of the skills most employees need in the office. When you register you don't pay any more to learn the new content that is scheduled to come online over the coming months.
So, in summary,
- the training content has proven successful, popular and useful for employees, employers and small business owners,
- the pricing is very economical compared to one day at a training centre,
- no matter how you prefer to learn we have multiple training delivery methods AND
- you can test us out by enrolling in the first (Beginners) course for free.
You have nothing to lose and lots to gain. Join us and let me know what you think of our EzyLearn training system.
Sincerely,
Steve Slisar (Director)
EzyLearn Pty Ltd
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), Course cost: $49 (inc GST) click the buy now button to enrol
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. Course cost: $49 (inc GST) click the buy now button to enrol
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. Course cost: $49 (inc GST) click the buy now button to enrol
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. Course cost: $49 (inc GST) click the buy now button to enrol
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. Course cost: $49 (inc GST) click the buy now button to enrol
| |
