Online Excel Training Archives - Page 2 of 9

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 — 2 Comments

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 — 2 Comments

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?

Posted on October 6, 2020September 21, 2021 by Steve Slisar

Office Academy gives Microsoft skills to all staff, online, remotely – NOW $200 OFF

paid on time reports for credit management accounting software

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 – NOW $200 OFF

Posted on June 23, 2020October 26, 2021 by Steve Slisar

Xero Accounting to Excel Spreadsheets to MailChimp & Email Marketing

Cash_flow_feature tool using advanced Xero training course including free career academy & available for $20 per week - Ezylearn

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.

Posted on April 21, 2020July 20, 2020 by Steve Slisar — 1 Comment

Data Entry and Microsoft Office Skills: Important for NSW Police Call Centre Work and Virtual Assistants

NSW Police Force Call Centre Jobs need training in data entry and beginner level Microsoft Office Word & Excel Courses - Customer Service Training

I was speaking with someone who recently applied for call centre work for NSW Police and they were surprised at how much of the testing performed at the group interviews required data entry and Microsoft Excel skills.

Microsoft Office skills are important to get office support or admin jobs but even more so now that employees are working remotely from home using their computer. If you need help on that front we offer FREE data entry and absolute beginner level skills in Word and Excel.

Posted on February 24, 2020February 24, 2020 by Steve Slisar

EzyLearn students can upgrade to ongoing or LIFETIME course access

Become an online marketing affiliate for Xero Learn, MYOB Education and Quickbooks Professional online training courses - EzyLearn

I had a fantastic conversation with an EzyLearn student during the week. She enrolled into our Xero COMPLETE Training Course Package and love it so much she enrolled into MYOB, QuickBooks, Excel and more.

The course increased her confidence to apply for and get work after years of being out of the workforce and as a bookkeeper she now uses the courses as a resource for aspects of the software she needs to upskill on. The EzyLearn Affiliate Membership is designed for students like her.

Continue reading EzyLearn students can upgrade to ongoing or LIFETIME course access

Posted on December 8, 2019October 26, 2021 by Steve Slisar — 6 Comments

Xero going up a pesky $2 rather than $27.50

Best value for money Xero online accounting training courses or $20 per week - $2 per month increase in Xero monthly support

It almost seemed like Xero was giving you $27.50 of extra value when they announced their $2 per month increase last week. These effects take effect on 18 March 2020 but not everyone wants Hubdoc and competitors like QuickBooks already offered similar functionality!

Xero has had a love/hate relationship with bookkeepers ever since the days when they promoted their accounting software as so easy that small business owners could use it themselves – without the cost of a bookkeeper – and it looks like they are well on their way with this mission. Continue reading Xero going up a pesky $2 rather than $27.50

Category: Online Excel Training