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
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.
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
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.
The main uses for Microsoft Excel are as a:
Here are some of the ways that we use Microsoft Excel for our training business.
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
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.
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:
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:
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.
In a business you can build a bigger business and make more profit by
Using Goal Seek in Microsoft Excel we discovered something that’ll help all independent contractors run a better more profitable business.
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.
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
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)
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.
