Posted on 1 Comment

Microsoft Excel 2016 & Gantt Charts for Your New Website/Business/Project

Project plans and gantt chart templates in Microsoft Excel 2016 training courses online

 

GANTT CHARTS ARE just one of the many wonderful features  Microsoft Excel and help enormously in the workplace. 

Many project managers oversee the project management and implementation of, say, a staff induction system, a new computer system or procedural changes.

Our Online Excel Training Course includes training on how to create your own project plan using Gantt charts. Continue reading Microsoft Excel 2016 & Gantt Charts for Your New Website/Business/Project

Posted on

Learn MYOB and Microsoft Excel, get help finding work with Career Academy

Learn MYOB and Microsoft Excel and get Microsoft Word Course for free

One more rest for Australia Day before the year REALLY gets under way and it’s a great time to set your priorities straight for 2016.

Our two most popular online training courses are our MYOB Course and our Microsoft Excel course. They’re complicated programs and most businesses need them for their financial management, reporting and forecasting so they’re great skills to learn if you are looking for a new job.

MYOB AccountRight Sign In Screen for MYOB Training Course

If you’ve followed this blog you’d also be aware that despite significant growth in the number of enrolments for our Xero Cloud Accounting courses the dominant player in the Australian market is still MYOB and MYOB accounting software also has cloud-based capabilities that make it more and more powerful.

Continue reading Learn MYOB and Microsoft Excel, get help finding work with Career Academy
Posted on

Beginners to Advanced Microsoft Excel Course for $197 inc Exercise Files

$197 Beginners to Advanced Microsoft Excel Course includes Exercise Files

Microsoft Excel Training Course exercise files

One of the best ways of learning how to use a program is to use that program during your training. Some people can sit with programs like Microsoft Excel and learn by trying something out and making mistakes and then trying again.

[box type=”tick”]We’ve discovered that Microsoft Excel course students want to work with real world files in a logical step-by-step method that uses the exercise files for the basic skills and then keep using that file for the more advanced skills.[/box]

By the end you’ll have a powerful Microsoft Excel spreadsheet using advanced skills and because you learnt in a logical and methodical way, using gradually more complicated tools, you’ll have learnt most of the Microsoft Excel skills you’ve wanted and won’t even notice the time go by.

Real World Use of Microsoft Excel Spreadsheets

Excel training course exercise filesThe main uses for Microsoft Excel are as a:

  • Worksheet that enables you to lay out information in a logical fashion and then perform calculations with that data
  • Database that lists all of the information in a tabular format that can then be filtered and manipulated into a format that can be used in mail merges etc, and
  • Charts and graphs that visually present the information in a worksheet or table so that we humans can make sense of the information

Here are some of the ways that we use Microsoft Excel for our training business.

Present information for use in newspaper ads

In Microsoft Excel Course 303 we look at formulas and formatting and one exercise file we share with students and an example of what’s possible using Excel is the artwork we created for the newspaper ads for our courses at our training centres in Sydney. The table structure of Excel enables us to lay the information out precisely and if we need to change the dates

What costs us the most money

Yes, you can see the costs of running a business in a simple table, but when you put it in a chart you can visually see the differences in costs and in our 305 course on charting we’ll show you how to create the various different types of pie, line and bar charts as well as many other types. You’ll learn how to format the charts to make certain areas stand out and you’ll learn how to demonstrate trends.

Budgets and forecasting

It’s great when you have historical information to work with because you can spend a lot of time working out percentages, margins, budgets etc to try to figure out how you will go in the future. We include many exercise files in Microsoft Excel Course 306, including files to help you:

  • Maintain a household (or business budget)
  • Calculate sales margins and commissions for sales people (we have several different versions of this file to demonstrate how the file should look at the various stages of creating it).
  • Create a price list (including all wholesale product costings – that will be hidden from view)

 Making the right decisions

When we operated our training centres in Sydney we spent a lot of our time scheduling courses. We had to allocate training rooms, roster on our great trainers, print training materials and we needed to know when people where coming to courses. We discovered that most people who wanted to learn Microsoft Excel did a night class. We had these variables to work with:

  • The courses
  • What days people had come to these courses in the past
  • The time of the day that students had enrolled into these courses: morning, midday, evening or weekend.
  • Different training methods (class-based and Flexible Learning)

By discovering the best days and times that students had enrolled into courses from the past we were able to better schedule our courses to get the most students. It means we didn’t need to cancel courses.

See the contents of Microsoft Excel Course 308 for more information.

Figure out how to make more profit

In a business you can build a bigger business and make more profit by

  • increasing sales,
  • cutting costs,
  • focussing on your most profitable customers,
  • focussing on your most profitable products,
  • decreasing the time it takes to get your money (cash sale or terms).

Using Goal Seek in Microsoft Excel we discovered something that’ll help all independent contractors run a better more profitable business.

 

Posted on 1 Comment

EzyLearn’s Excel Course: Helping Energy Action Show Savings in Energy Cost and Consumption

IN THESE TIMES OF GLOBAL WARMING the need for businesses to reduce energy consumption and greenhouse gas emissions has never been more important.

Australian company, Energy Action, prides itself on helping businesses reduce energy usage and save money. Energy Action provides an innovative flagship service it terms the ‘Australian Energy Exchange’ through which energy suppliers can competitively bid against one another for the supply of an organisation’s energy. With a best-fit contract usually secured in only 15 minutes, more than 5000 businesses have now partnered with Energy Action to maximise their energy savings, culminating in more than $5 billion worth of energy contracts.

Energy Action provides their clients with quality monthly reports showing clients’ energy demand, power factor, load factor, energy consumption, emissions and more. Their daily monitoring flags when clients’ demand targets are approached or exceeded.

Microsoft Excel Online Course 308 - pivot table value field settings
Microsoft Excel Online Course 308 - pivot table value field settings

Read how Energy Action staff learnt about Pivot Tables and Charts, Conditional Formatting, VLOOKUP and much, much more to provide a higher level of knowledge to their customers: Energy Action Case Study

Posted on Leave a comment

MYOB Training: Exporting MYOB Data for an Excel Mail Merge

MYOB Training Course Exported Accounts list

We recently created 9 new training videos for our online MYOB training course and one of them demonstrated how to export and import data from an MYOB training company datafile. Exporting and importing is used to extract transaction and sales information and also customer or supplier card files from MYOB to use with Microsoft Excel in performing mail merges.

We have included the simple accounts list that we use in our online MYOB bank reconciliation course as a file you can download and open up in Notepad or Microsoft Excel. The image above shows what the file looks like when opened up in Notepad. It’s called a TAB-DELIMITED text file and this example includes a header record that gives you the name of each field (column)

ACCOUNTS

If you want to learn more about TEXT format (including CSV – comma separated values) files and how to manipulate this type of data using Microsoft Excel, take a look at our Microsoft Excel course 307 (visit this link and scroll down until you see the course contents of course 307: http://ezylearnonline.com.au/courses/microsoft-excel/excel-course-outline-2/).

If you need training on Microsoft Excel and data storage types you’ll be thrilled to hear that this course is one of 9 courses that are all included for one low price and LIFETIME student membership at the EzyLearn online Microsoft Excel course. Click here to enrol.