New videos and training workbooks and exercises for Microsoft Excel 2007
Are you only using 10% of Microsoft Office? Are you taking 2 hours to do something that can actually be done in 30 minutes? Microsoft Office software had a feature that could identify your productivity score in reports to managers.
The technology was designed as a sales tool for Microsoft to help identify software that could be utilised better at Microsoft corporate clients but it unveiled a whole privacy issue.
Continue reading Can you lose your job because of Microsoft’s productivity police?
Do you know how to use Microsoft Word? Oh, yes.
Can you show me how to change the alignment of these paragraphs, put bullet points here and make the image aligned to the right side of the text? Um, I’ll give it a go.
This is a common scenario in conversations I’ve had with students looking for office admin and support jobs. Some people think that just because you can type they can use Microsoft Word but that’s not the case and when I look at the high number of office jobs that require good data entry skills it makes these skills very important! Here’s our offer for October. Continue reading Office Academy gives Microsoft skills to all staff, online, remotely – October $200 OFF
There’s new content in our Advanced Microsoft Excel Course about Excel Macros that automate the reformatting of database information, exported from Xero Accounting so it can easily be imported into MailChimp for email marketing.
If any of these words don’t make sense to you, you need to upskill to get up to speed because this terminology is becoming common in most workplaces.
Continue reading Xero Accounting to Excel Spreadsheets to MailChimp & Email Marketing
So you want to learn Excel quickly and you’re on a budget? Buy our Excel Beginners’ to Intermediate training workbooks (with exercise files) and start getting a handle on how to master the world’s number one business productivity software program.
Continue reading Announcement: Microsoft Excel Training Workbooks Instant Download
Many experienced BAS agents have told me that data entry, accounts receivable and accounts payable skills are the ones that they’re looking for in potential employees.
Many students who’ve completed a Cert IV in Bookkeeping and Accounting however think they’re above these skills and here’s how you can beat them in job interviews.
Continue reading What do employers really look for in Accounts Receivable and data entry jobs?
ONE OF THE GREAT THINGS about Excel is that it has so many applications. It can be used to create financial budgets and forecasts, monitor stock levels in a retail shop, roster staff, and also determine how much money an investor can borrow to buy a property.
A lot of the time, however, people enrol in an Excel online training course or Xero online training course because they need to refresh a specific set of skills for their job, which means they don’t have the time to focus on other areas that don’t have an immediate relevance for their work.
With our Lifetime Access courses for Excel and Xero and many other online cloud accounting and business options, students can continue learning in their own way and at their own pace, either as part of continuing professional development or for their own personal interest — our course content includes real-world case studies, like building a granny flat, to give context to the functions of Excel.
The other benefit of our Lifetime Access for Excel online training courses and Xero online training courses is that it means you can quickly brush up on where functions have been moved to when new versions of Xero and Excel are released.
We update our course content every time a new version of software is released, and with Lifetime Access, you’ll be able to access all of this new content, along with previous versions of course — so you can keep learning on the most current versions of Excel and Xero.
Stop wasting time, and start learning for less. Visit our website for more information about Microsoft Excel training courses and our Xero training courses, and to enrol.
We are constantly refreshing the content of our online training courses so that you can benefit from all the new information that is always coming in about being in business, or running your own business as a bookkeeper or looking for bookkeeping work.
Our Xero online training courses include EVERYTHING for ONE LOW PRICE. Furthermore, if you select our Lifetime Membership option, you’ll have LIFETIME access to our ongoing course updates. All EzyLearn courses are accredited by the Institute of Certified Bookkeepers (ICB) and can be counted towards Continuing Professional Development (CPD) points. Find out more about our Xero online training courses.
WHEN XERO FIRST ENTERED the accounting space, it gave MYOB a real run for its money — something Xero continues to do to this very day.
When Xero first entered the market, it was with a bang. You see, even though Xero and MYOB share many of the same features, Xero was cheaper and easier to use than MYOB, but perhaps even more so, it was also cloud-based. Being cloud-based meant you didn’t have to buy and install pricey software that would be out-of-date within 12 months. A huge advantage.
Since then, however, a number of cloud-based accounting applications have entered the market — QuickBooks Online (now distributed by their US-based parent company Intuit), Reckon One, Saasu, Zoho, and so on.
As business owners have more choice than ever before, it’s got a lot of people wondering about whether the two market leaders (Xero and MYOB) are really all they’re cracked up to be, Xero in particular.
Even though Xero was hailed as a breath of fresh air when it first entered the market, it is still a little more complicated to use when compared with other cloud accounting apps, like QuickBooks and Reckon One. For instance, the purchase orders feature is still hidden behind bills, when it could easily be access via a dropdown menu. But it’s not a major quibble.
Although Xero allows you to assign customer numbers for your suppliers or customers in the contact profile, it doesn’t have the functionality to record customer numbers assigned by supplier or customer.
If you’re trying to get in touch with Telstra, for example, with whom you’ll have been assigned a customer or account number, you’ll have to dig around for the paper bill to find that customer or account number.
This feature is available in QuickBooks, and it’s also available in MYOB, but as is often the case with MYOB, it requires more steps to do what you can in Xero in just a few clicks. Rather than keep paper bills on hand, Xero allows you to attach them to you transactions, so you never have to go hunting around for a bill again (very useful given the contact profile issue mentioned above).
In MYOB, you must upload your bills to your in-tray, and then link them to your transactions. This is annoying, because it requires you to leave the transaction window and open the in-tray one.
Remember that when you select a cloud accounting package for your business, do not choose solely based on price. Make a list of the needs of your business and the functions you’ll require, and then select the accounting package that suits your needs the most. Ask your bookkeeper and other business friends for their recommendations as well.
MICROSOFT EXCEL IS THE most widely used spreadsheet application in modern computing. That said, it’s also one of the more difficult programs of the Microsoft Office Suite to learn, which is why we recently updated the content of our Excel training courses.
A lot of people do our Excel training courses to help them “skill up” to find a job, find a position better suited to them, or develop their career path. However, Excel is a fantastic tool for small business owners as well.
But whether you use Excel to create a pivot table or a database, there are a few things you should do each time you open an Excel document. Here we present you with three:
Always align the text in the cells of your Excel spreadsheet to the centre, or the top in certain circumstances. But never, ever align it to the bottom. It’s hard on the eyes and, when you’re looking at lots and lots of data in lots and lots of cells, it becomes difficult to know which row, column, etc, you’re looking in. Centre alignment, always.
There should never be an instance where one of your workbooks is showing a #DIV/0, #N/A, #REF, #NAME?, #NUM!, or #NULL! error. This is especially true if you’re sharing these workbooks with your business partners or accountant or whomever.
Seeing an error in a financial report may cause the reader to doubt the accuracy of the entire workbook, so ensure your workbooks remain error free by using the simple IFERROR() error-checking function in Excel.
Again, if you intend to share workbooks with other people, you should always ensure that your Excel workbooks can be printed nicely and easily, even if you don’t intend to ever print the document yourself. This is easy enough to do via File > Print Preview and adjusting the print margins before sharing (or printing) the document.
However, judging by the number of times I’ve printed an Excel document only to collect 87 sheets of paper off my printer to read the contents one 4×4 table, the function is seldom used by anyone else but me!
For more Excel formatting tips and tricks, download our FREE Beginners’ Guide to Excel, or enrol in our intermediate or advanced online Excel training courses to learn how to create databases, pivot tables, charts, graphs, and much more…
Read more about our beginners, intermediate and advanced Excel training courses on our website, or enrol to start learning by 5pm tomorrow!
At EzyLearn, we’re committed to helping students of our MYOB, Xero and Quickbooks courses gain employment as a bookkeeper or even start their own bookkeeping business; it’s why we provide you with lifetime access to our online cloud-accounting training courses as part of our commitment to continuing professional development.
WE’RE ALWAYS UPDATING OUR Excel training courses, and as we do so, we’re reminded of just how useful Excel continues to be for small business owners — particularly the latest versions of Excel which include a boatload of new features that make it easy to create and manage relational databases, which you can also use as the data source for a pivot table.
But supposing, for whatever reason, you don’t want to use an Excel database as your pivot table’s data source? Well, there are some other options to create a pivot table without manually entering the information into Excel first. Here are a few more data sources that you can use to create a pivot table in Excel.
The office data connection (ODC) file extension was created by Microsoft and contains properties to connect to and retrieve data from an external data source. It contains a connection string, data queries, authentication information and other settings. Microsoft recommends that you retrieve external data for your pivot tables and reports using ODC files.
If, for instance, you’re using another relational database program, like Microsoft Access or Filemaker Pro, you can also import data directly from these programs into your pivot table, rather than manually entering the data into an Excel worksheet. In the case of connecting data from an MS Access database, you can do this quite simply by selecting Access from the ‘data source’ dialog box. For all other external databases, you would select the ‘from other sources’ dialog box and follow the steps in the data connection wizard.
Each time that you create a new pivot table, Excel stores a copy of the data for the report in memory, and saves this storage area as part of the workbook file. To use one pivot table as the source for another, both must be in the same workbook. If the source pivot table is in a different workbook, copy the source to the workbook location where you want the new one to appear. Keep in mind that when you refresh the data in the new pivot table, Excel also updates the data in the source pivot table, and vice versa. When you group or un-group items, or create calculated fields or calculated items in one, both are affected.
The easiest and most efficient way to create a pivot table is to create a database in Excel first. Here, you can update and manage as much information about your business — including customer data and financial data — and then use that as a data source for a pivot table.
Creating databases and pivot tables are part of our advanced Microsoft Excel training course, but you can start your Excel journey with our FREE beginners’ Excel course. Read more about our beginners, intermediate and advanced Excel training courses on our website, or enrol to start learning by 5pm tomorrow!
Our Xero online training courses include EVERYTHING for ONE LOW PRICE. Furthermore, if you select our Lifetime Membership option, you’ll have LIFETIME access to our ongoing course updates. All EzyLearn courses are accredited by the Institute of Certified Bookkeepers (ICB) and can be counted towards Continuing Professional Development (CPD) points. Find out more about our Xero online training courses.
WE’VE RECENTLY BEEN UPDATING the content for our Excel training courses and were reminded of just how useful Excel is for small businesses. In Excel, you can easily create and manage client databases and then export part or all of that data into a Word document, your accounting software, an email marketing service, or use it in other Excel documents, such as a pivot table.
A pivot table is Excel’s signature, and most powerful, feature — Microsoft trademarked the words ‘pivot’ and ‘table’ in their compound form PivotTable back in the 1990s. So if you intend to use Excel in any meaningful way for your business, knowing how to create and work with pivot tables is an essential skill, one which we cover in our newly-updated, advanced Excel online training courses.
A pivot table is a way to quickly summarise and analyse large amounts of data, and the pivot tables you can create in Excel are especially designed for:
There are a few ways that you can create a pivot table, though the most common way is to use an existing Excel worksheet — a database, for example — as a data source. Here are a few ways to create a pivot table in Excel:
The most efficient way to create a pivot table is to create a database in Excel first. Here, you can update and manage as much information about your business — including customer data and financial data — and then use that as a data source for a pivot table.
Creating databases and pivot tables are part of our advanced Microsoft Excel training course, but you can start your Excel journey with our FREE Beginners’ Excel Course. Read more about our Beginners’, Intermediate and Advanced Excel training courses on our website, or enrol to start learning by 5pm tomorrow! We cover ALL levels for ONE LOW COST.
At EzyLearn we offer online training courses to help you up-skill and find employment. Choose from our range of cloud-based online accounting software courses, to business start up and management courses, to marketing and sales courses, or update and further your skills in a range of Microsoft Office programs (Excel, PowerPoint, Word) or social media and WordPress web design).
IF YOUR BUSINESS RELIES on staff to work different shifts, then you’ll need to provide them with a staff roster. We’ve written about the three ways you can create staff rosters for free before.
One of the exercises in our Microsoft Excel Training Course shows you how to create your own staff roster, so we’re not going to do that here. Instead, we’re going point out the things you need to include in a staff roster.
If your business employs a combination of full time, part-time and casual staff, you’ll need to prioritise the full time first, then the part time staff, as by law, they’re guaranteed a certain number of hours each week — 38 hours for full time staff, fewer than 38 hours for part time staff.
A rostered day off (RDO) is a day in a roster period that an employee doesn’t have to work and these can be paid or unpaid depending on individual agreements. Both full time and part time staff members will have annual and sick leave entitlements. Make sure you mark these up on your rosters. It’s not just easier to schedule the rest of your employees when you can see who’s working and who’s not working, but it’s also useful for the rest of your team to know this as well.
Depending on the modern award and the duration of the shift, certain staff members will be entitled to different kinds of breaks — two 15 minute breaks and one 30 minute lunch break, is common in retail, for example. Mark these break times up in your staff roster, so the staff member can see when they’re due for breaks.
Leave a column on your roster, so each employee can sign off at the end of each week to confirm they worked their rostered shifts. This is important, particularly if any of your employees ever claim a discrepancy in their pays due to shift changes, etc.
Our Microsoft Excel training courses will show you how to modify margins and set up templates, skills you can use to create your own free staff roster in Excel — or Google Docs, if you prefer. Visit our website for more information on our suite of Excel online training courses.
At EzyLearn we are constantly refreshing the content of our online training courses. Where possible, we draw on real-life case studies as examples, to help you learn, and apply your skills, in a relevant way that makes sense. Visit our Micro Courses page to learn more.
SHIFT WORK TYPICALLY EXISTS in businesses that operate outside of regular business hours — on weekends, the wee hours of the morning, late at night — and to be fair to all of the business’ employees, the shifts are rotated. Other times, as in the case of home care nurses, it’s because the employee has to visit a different patient each day of the week.
As such, it’s necessary for these businesses the provide staff members with a roster each week, fortnight or month. Although there are lots of roster programs available, we’re going to look at 3 great ways you can create staff rosters for free.
One of the exercises in our Microsoft Excel training courses is to create your own staff roster, because once you understand how to change the margins and set up a worksheet correctly, Excel is still one of the most common programs to create a roster in. Most businesses ensure a new roster is available at the premises on the same day each week, fortnight or month, with at least a week’s notice so each employee has time to check their shifts when they’re at work. Other times, they’re printed and emailed to staff, again with at least a week’s notice.
Once you’ve had Microsoft Excel training, you’ll find little difference between Excel and Google Sheets, as the former was so efficient that not even Google could find a way to improve its offering (ditto for Google Docs). Once your roster has been created in Google Sheets you can likewise print it out, email it or, if your staff have Google accounts, share it with them.
This only works if your staff are all using the same domain — i.e., they have a company email address — but if you open up Google calendar, you can start scheduling events as shifts. This may be suitable for call centres or businesses whose employees work in their office, both of which only have a handful of employees and a few shifts to cover. Scheduling lots of staff members across lots of different shifts this way can be tedious.
Our Microsoft Excel training courses will show you how to modify margins and set up templates, skills you can use to create your own free staff roster in Excel — or Google Docs, if you prefer. Visit our website for more information.
Choose from our range of cloud-based online accounting software courses, to business start up and management courses, to marketing and sales courses, or update and further your skills in a range of Microsoft Office programs (Excel, PowerPoint, Word) or social media and WordPress web design).
IN A PREVIOUS POST we talked about taking out a business loan to cover payroll if you anticipate that you won’t have enough funds to do so otherwise.
Naturally, it’s always better to use your business’ own funds to meet your obligations, whether it’s paying staff or suppliers. This said, getting a business loan to cover payroll can be a good idea for small and growing businesses in certain circumstances. We look at these now.
Depending on how many employees work for you, the repayments on a business loan are typically smaller than all of your payroll obligations — this includes superannuation and PAYG — combined. If you get a loan to fund 12 months of your business, payable over a 24 or 26 month period, the repayments will be far easier to manage each month.
Businesses are able to claim the interest from any business loan as a tax deduction, so even if the annual percentage rate (APR) adds a few additional thousands of dollars to your capital amount over the period it takes to pay the loan back, the interest will still go towards reducing your taxable income.
This is a more favourable option to delaying payment to your employees (illegal) and delaying payment of PAYG and superannuation withholdings, which could incur a Failure To Lodge (FTL) penalty, plus a general interest charge (GIC). Note: Fines and penalties cannot be claimed as a tax deduction and are therefore dead money.
Don’t forget that, while a business loan to cover payroll for 12 months will be easy to repay initially, your business’s profits will need to improve substantially over the next year so that you can continue to meet your loan repayments AND your payroll obligations for that year.
You can easily work this out using Microsoft Excel. Our Intermediate Microsoft Excel training courses show you how to determine if you can afford to take out a mortgage, but because all of our fields remain “unlocked”, you can easily modify them to suit a business loan scenario. Visit our website for more information on all of our Excel training courses.
WE’VE RECENTLY UPDATED THE course content in our Intermediate Microsoft Excel training courses to include a workbook and spreadsheet (that you can use in your own business) showing you how to manage ad hoc payroll using Microsoft Excel. This will enable you to calculate your PAYG and superannuation obligations in Excel.
Using Excel to work out your PAYG and super obligations is a great way for small businesses, with a small number of employees, to save money. It saves you having to purchase this extra module in MYOB or Xero, for instance, when you may rarely use it. Saving money for small business is crucial as often it’s these same small businesses that have trouble making payroll payments each week, fortnight or month — and then wind up incurring further fees from the ATO when they’re late with their reporting and payments. It’s a vicious cycle.
If you’re finding it a stretch to make payroll payments, don’t worry, you’re not alone. Lots of business owners have trouble making payroll. But there are things you can do about it. We find that it frequently comes down to poor credit management processes or perhaps a downward trend in a business’ cycle that’s been missed due to poor or inefficient accounting processes. All of these can be rectified.
If the reason your business can’t make payroll is due to one or more shortcomings in your business’ operations, remedy the problems now. Similarly, if credit management is the issue, and late-paying clients are partially to blame, then tighten up or implement a credit management process. If it’s the result of bookkeeping that’s not up-to-date, find a bookkeeper to manage this for you.
Get financing. There are lots of ways to do this, but a common method, particularly if you need access to funds quickly, is to get a short-term business loan. Many short-term business loans don’t require businesses to have a great credit score, and will offer funding of as little as $5,000 right up to $500,000.
You’d have between 3 and 36 months to pay back the loan, but you need to be aware — the annual percentage rates (APR) are usually high. Most lenders require the business to have been active for a minimum of 9 months, and have revenue of more than $75,000 per annum. However, if paid off quickly, these can be an alternative to incurring penalties — it will obviously depend on your business’ individual circumstances.
If you stay on top of your bookkeeping, you’ll either reduce the likelihood that you won’t make payroll, or as a worst case scenario, be able to foresee the periods when you won’t be able to, and be able to arrange finance in time to cover it.
Use the Ad Hoc Payroll Guide included in our Intermediate Microsoft Excel training courses to determine the rate of PAYG tax to withhold — and the required super contribution amounts in Excel. Visit our website for more information on our entire suite of Excel training courses.
At EzyLearn we offer online training courses to help you up-skill and find employment. Choose from our range of cloud-based online accounting software courses, to business start up and management courses, to marketing and sales courses, or update and further your skills in a range of Microsoft Office programs (Excel, PowerPoint, Word) or social media and WordPress web design).
All of our online training courses can also be counted towards Continuing Professional Development points.
DESPITE THE POPULARITY OF cloud-based accounting software applications like Xero and MYOB, Excel still remains one of the most indispensable software programs for businesses and individuals alike. That is why we always make it a priority to constantly update our Microsoft Excel Training Course.
Accounting software, even robust packages like MYOB, only allow you to perform a finite number of functions that relate to business accounting. However, Excel can be used for a multitude of different purposes — both business and personal, merely one of which is to develop a financial forecast for an investment.
Our Intermediate Excel Training Course uses the construction of a granny flat for investment purposes as a case study example. We chose a granny flat for the case study because most people construct them as an investment, whether they’re in business or not, so it’s a good real-world example.
It also deals with depreciation, which you can claim in your tax, regardless of whether you’re in business or not.
But even though, with the current property booms in our major cities, granny flat construction has become more common, it is not so common that every person taking our Excel courses is planning to build a granny flat for their next investment. That’s why we decided not to lock our course content.
What does this mean? It means that all the calculation fields in the exercise files of our Excel training courses are unlocked, so that your education remains unlocked too. You’re free to play around and replicate them as you need, so you can get a proper handle of how to use Excel in business or for work.
Visit our website for more information on our Microsoft Excel Training Course, with its new granny flats case study. We provide a range of online Excel training courses for beginners’, intermediate and advanced students.
EzyLearn Excel, MYOB and Xero online training courses count towards Continuing Professional Development (CPD) for bookkeepers and accountants. We’ve been an accredited training provider of the Institute of Certified Bookkeepers ever since the organisation started in Australia. Find out how CPD points can be of benefit to you.
A LOT OF SMALL BUSINESSES have trouble managing their payroll, especially when they only have a few employees and paying to access a payroll system in their accounting package is an unnecessary expense. You’ll learn how to use Excel to manage your PAYG and super contributions in our Intermediate Microsoft Excel Training Courses. However, sometimes you may have a backlog of PAYG and super payments. Let’s take a look at how to manage these.
A backlog of PAYG and super payments that date back more than three months is known as rescue bookkeeping, although it can often include other bookkeeping issues, like bank accounts that don’t reconcile with statements.
For businesses that only withhold up to $25,000 each year, you’re supposed to make PAYG payments and file a withholding report each quarter. You have 28 days from the end of the quarter to do so, after which time, you may incur a Failure To Lodge (FTL) penalty.
As with PAYG payments and reporting, you can also incur a FTL penalty for not lodging or paying your employees’ superannuation contributions in time. All businesses, regardless of size, have to make superannuation payments each quarter — the ATO sets out the due dates for each period on their website.
The ATO only applies penalties for failure to lodge reports or make payments for each period of 28 days (or part thereof) that a document or payment is overdue. Each period incurs one penalty unit for each document, up to a maximum of five penalty units.
From 2015 onwards, the value of a penalty unit is $180 (previously it was $170) for small businesses, which are defined as entities with an assessable income or GST turnover of no more than $1 million a year.
The maximum penalty a small business will pay is $900 for each document or payment that is overdue. Note too that FTL penalties will also incur a general interest charge (GIC), applied on top of the penalty.
Use the Ad Hoc Payroll Guide, a new case study that is included in our Intermediate Microsoft Excel Training Courses to determine the rate of PAYG tax to withhold and the required super contribution amounts in Excel. Once you’ve worked out the required amounts (visit the ATO website for tax tables prior to 2017), lodge the necessary PAYG payments and reports to the ATO; pay super contributions using the SuperStream super clearing house.
The ATO will write to you if you are required to pay a penalty — sometimes they are waived for first-time offences, or if the amounts are small.
Our Intermediate Microsoft Excel training courses will also teach you how to create a payroll spreadsheet from scratch to suit your own business, so you can easily work out your PAYG and super obligations. Visit our website for more information on all of our Excel training courses.
Gone are the days of excruciatingly dull PowerPoint slide presentations. Nowadays PowerPoint is the hidden gem used to generate animations, videos, movies, advertising and graphics. It’s a great ally to the marketer or social media person in your organisation.
This creative program can also be used to conjure up the most beautiful and modern pictorial slides to enhance any presentation or induction. Find out more about our 2016 version PowerPoint courses.
EzyLearn Excel, MYOB and Xero online training courses count towards Continuing Professional Development (CPD) for bookkeepers and accountants. We’ve been an accredited training provider of the Institute of Certified Bookkeepers ever since the organisation started in Australia. Find out how CPD points can be of benefit to you.
Enrolled into an EzyLearn course since 2013?
Get access to new & updated course content and support by joining the EzyLearn Career Courses Program.
Use our informative and logical
to learn how to use software relating to your industry in small, well designed learning experiences and get the CPD points you need to remain professionally compliant with your industry association.
