Online Excel Training Archives

Posted on February 21, 2024February 21, 2024 by Steve Slisar

Business Office Administration Training to find Remote Work

I recently wrote about the Internship opportunities for selected business and office administration training courses – this work can all be done online, remotely working from home.

One of the best things about running an online training business is that we can deliver our courses to the thousands of students who live in remote parts of New South Wales, Victoria and Queensland and the rest of Australia!

Read on to discover how you can up-skill and learn how to become a remote working virtual assistant performing business and office administration work from your own home

Posted on October 10, 2023October 10, 2023 by Steve Slisar

Feeling the squeeze? Are your expenses like mine!?

Learn how to use Microsoft Excel in online training courses to master MyBudget, debt and expenses

After the ludicrous events of the Covid Pandemic this era of high interest rates is squeezing everyone! Interest rates, petrol prices, energy prices and food. Have I missed anything? No, that is everything we need to live these days and prices have gone up a ridiculous amount but do you know how much your costs have gone up by?

I’ve recently taken to Microsoft Excel to perform budget calculations that I haven’t thought much about for a long time.

Posted on September 17, 2023September 17, 2023 by Steve Slisar

Have we spoken yet?

Accounting Tutors - online Xero, MYOB, QuickBooks, Microsoft Office Excel, Word training courses - compare airtasker, gumtree, applied education, SpotED

The most rewarding conversations I have is with EzyLearn graduates who’ve completed our courses and then gone on to manage their finances better or get an accounts job. I’ve been speaking to a lot of EzyLearn students lately and there is a consistent theme in most conversations – “what on earth is going on with the price increases for everything“.

I thought that the Covid-19 era was going to be the most challenging period because of all the disruption to our normal lives. I’m not sure if you have discovered the same but one of the best results was that more people started working from home or negotiated partial work from home arrangements with their employer.

The real disruption of The Pandemic is that we are NOW all paying the price of it with inflation and interest rates!

Posted on July 19, 2023July 19, 2023 by Steve Slisar

New! Microsoft Forms Course – Pre Launch Discount

Microsoft Forms Training course - Online Form Builder Templates for selling your property in Morisset & Bonnells Bay NSW - EzyLearn Pty Ltd

When I operated training centres in Sydney most of the sales were made by phone. We’d advertise our course in the local paper, highlighting our phone number and encouraging students to call and enrol into a course. It was labour intensive and not that secure when you think that we were taking down students credit card details over the phone.

Then we introduced learning on demand where students could learn any topic they wanted during our opening hours and we introduced our first online form to take enrolments – the results were miraculous. We’ve subsequently made many changes to that form since then.

We didn’t have to be in the office to take enrolments, students could enrol whenever they were ready and we had a central database of all our students and the courses they enrolled into. Best still, this information was all emailed automatically into our Customer Service software system. You can now learn these skills in the Microsoft Forms Course.

Posted on March 18, 2023July 23, 2023 by Steve Slisar — 1 Comment

FREE Courses for Job Seekers who enrol into MYOB, Xero and Excel Complete

If you have enrolled into a course with EzyLearn be sure to check out these FREE student inclusions.

We’re creating and updating our online courses every month and we’re listening to feedback from students to understand what they need. We’re even paying EzyLearn graduates for their expertise in the work they do. If you want to see how you can earn money using your expertise check out the LIFELONG Learning Hub in the Learning Site or reach out to our support team.

Posted on February 20, 2023February 20, 2023 by Steve Slisar

Reduce Debt, Cut Expenses, Up-Skill, Increase Income

EzyLearn Online Accounting, Office Admin & Digital Marketing Tutor

Are these the words going through your head right now? Probably the topic of lots of conversations too with all these interest rate rises we’ve been having.

One of our students got help from a debt negotiator and they do an effective job but they have to make money for the work they do. One of the biggest is called MyBudget. You can achieve a similar outcome yourself with some good spreadsheet skills and the courage to sit down and work out all your financial affairs you can do it yourself. There’s even an official government website that has a lot of free tools.

Posted on October 5, 2022October 5, 2022 by Steve Slisar — 1 Comment

Achieve Your Financial Goals: Microsoft Excel Graphs & Charts Course Show Costs of Food and Petrol – Your Personal Budget

mybudget excel training course files to achieve your financial goals - online Excel Training Courses

If you are feeling the pinch financially right now it would be good to find out why. It’s easy to make a statement like “petrol and food prices are through the roof” but the truth might be a bit different when you get all your expenses into a spreadsheet.

Interest rates have gone up a LOT in the last few months so your mortgage payments might be chewing up most of your disposable income. If you have a car loan, personal loan or other debts where the interest rates are much higher you might find that you need to “consolidate” your debts to make ends meet.

A household budget exercise file is included in the Excel Intermediate Training Course 306 and a similar exercise file is available in the Excel Intermediate Training Course 305. The goal is to help you visualise the changes in your costs and expenses.

Posted on October 1, 2022October 1, 2022 by Steve Slisar

Xero Bookkeeping using Value-Based Pricing – Learn from your kid & their chores

Weekly and Daily Chores for Kids using Value-based rewards - Online Microsoft Excel Training Courses

I participated in an interesting project this week that clearly defined Performance Based Pricing. It came about because paying a flat wage just didn’t produce the desired outcome. Let’s just say that the kids didn’t complete all their chores and their mum got tired of paying pocket money while having to chase them up every day – sound familiar?

Xero have always promoted Performance Based Pricing (also known as Value-based pricing) as the best way to run a bookkeeping business but have the flexibility to operate your own hours. It’s based on paying for outcomes rather than time. It encourages workers to use technology to be more productive.

Posted on September 28, 2022September 28, 2022 by Steve Slisar — 2 Comments

Household Budget using Microsoft Excel Course: Track Interest Rates, Expenses & Income

Learn how to use Microsoft Excel in our Beginners, Intermediate and Advanced Excel Training Courses

A household budget can keep you sane in times when major expenses are fluctuating. It is a requirement if you are applying for a housing loan and if you want to borrow to invest in an online business but it can also show you very clearly if you need to find new sources of income or get rid of some expenses.

If you have found yourself subscribed to too many online streaming services or software programs that you just don’t need or use your budget can help you identify those expenses.

Same goes with debt repayments for phones, household items or motor vehicles.

There are two budget templates in the Microsoft Excel Intermediate Training Course – one for your personal income and expenses and one for starting a small business.

Posted on September 26, 2022September 26, 2022 by Steve Slisar

Microsoft Excel Intermediate Training Course Case Study: Working out Commission Payable to Sales Reps

Learn how to use Intermediate Microsoft Excel Skills to produce reports with complex formulas. Online Training Courses

Sales is an interesting career path which includes everything from real estate agents, account managers to direct sales people who walk from door-to-door or make calls on the phone.

Being a Sales Representative is something that every bookkeeper does if they have their own bookkeeping business. You speak with prospects, find out what they want, see if you can do the work for them and then sign them up and start working. You’re helping to match a business with a customer.

I’m often fascinated at how many Bookkeepers HATE hearing the word “sales” associated with any part of their work and as a result they act like a ROBOT when they speak to potential clients, but I’m digressing and that’s a topic for another blog post!

The benefit of being in sales is that you can earn a commission which is often much larger than your base salary – but keeping track of commissions payable each month can be complicated and we teach you how to use Excel to make it EZY.

Posted on September 21, 2022September 21, 2022 by Steve Slisar

Microsoft Excel & Xero Bookkeeping COMPLETE Training Course Package is Now Here

Training Course ad in Manly Daily for Microsoft Excel, Website Design, MYOB - Ezylearn

You may be asking WHY it has taken us so long to create this training course COMBINATION package considering that Xero and Excel go hand in hand for all things financial and accounting?!

Xero is fantastic for keeping track of all of your financial transactions for a business and Microsoft Excel is still the preferred choice by most bookkeepers and accountants for producing reports and working with the data that comes out of Xero.

The versatility of Excel as a spreadsheet means that you can do so much more with it than just make sense of the financial information from your Accounting software. One case study in our Microsoft Excel Courses comes from our own experience about scheduling courses, trainers and training rooms for enrolments when we had a training centre in Dee Why NSW.

Posted on August 22, 2022August 22, 2022 by Steve Slisar

Pick and Choose from Ideal Bookkeeping & Office Admin Jobs Everyday via Email

early-bird-bookkeeping-job-hunt-job-site-alerts-Indeed-Seek-Office-Admin-Bookkeeping-Accounts-Jobs-Online Training Courses in Xero, MYOB & Microsoft Excel

There are dozens of new office admin & bookkeeping job ads EVERY day, even for remote workers! Find out how to get them via email

When you’re serious about finding a good office administration or bookkeeping job it pays to have alerts set up on the most popular job search sites. Job alerts save you a lot of time by not having to manually search the same criteria each day, and ensure that you automatically receive email notifications as soon as new jobs become available.

Job alerts also allow you to find out what employers are looking for right now and which tasks they need their job seekers to perform.

With this information you can refine your searches even further to find the jobs most suited to your skills and experience, and then use the criteria to match skills in your resumé and job applications.

Posted on March 8, 2022March 7, 2022 by Xero Training

How Microsoft Word and Excel Training Can Improve Your Work Life

As part of our new initiative, EzyLearn Worklife, we’ve been speaking to EzyLearn graduates about their experiences with their course, and how they use the skills they’ve learnt in their work life.

One such student is Ian, who enrolled into both the Microsoft Word and Microsoft Excel Complete Training Course Packages in 2021. He is also part of our Career Courses Membership, which gives him lifetime access to his course content and student support.

Ian works for Services Australia and we had a chat with him about his work, his course, and all things in between. And he gave some great insight into just how valuable online training can be…

Posted on February 25, 2022February 25, 2022 by Xero Training — 1 Comment

Office Administration or Business Administration: What Jobseekers Need To Know

Office admin courses and business administration training course and qualifications

Jobs in office administration and businesses administration are pretty popular currently – Seek has them projected at 7.3% and 9.9% growth, respectively.

So if you’re scrolling through one of the many job seeking sites, searching for an administrator role, it’s important to know the difference between these categories.

And it can be a bit confusing. Some job listings seem to use these terms interchangeably, or you might just see the blanket term ‘administrator’ as the title. Whilst there is some overlap, there is a difference between the jobs descriptions and tasks of office administrators and business administrators.

Here’s how to know which one is right for you:

Posted on September 20, 2021September 21, 2021 by Steve Slisar

Attn: New Advanced Excel Certificate Course topics

Microsoft Excel Advanced Certificate Training Course - New Get and Transform Dataset and Power Query Training - EzyLearn Online

We’ve added some new training materials in the Advanced Excel course relating to getting and transforming data and using the Power Query. It’s very relevant in our current data driven environment where we have many sources of data that we need to make sense of. Employers are looking for good staff with Microsoft Excel Advanced Certificate skills.

Power Query enables you to query large datasets from multiple sources and derive meaningful information and insights. Turn Excel into a Business Intelligence system or data analysis tool for research data! This NEW Excel Advanced Training Course material is available for FREE if you are a current student and for a very low cost if you’ve enrolled into Excel with us in the past.

Posted on April 21, 2021April 21, 2021 by Steve Slisar

Can you lose your job because of Microsoft’s productivity police?

Microsoft Office 365 Productivity Score for office support and administration tasks job description - online training courses Office Certificate Course (EzyLearn - recognised by employers)

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?

Category: Online Excel Training