Microsoft Excel Training Courses

Learn Excel training course online with EzyLearn

Learn how to make sense of your data for sound financial decisions with our suite of Excel training courses.

Study at your own pace and don’t pay more than you have to.

one cheap low price for all MYOB accounting online training courses logo

Our Excel online training course price includes all skills levels!

You receive all 9 x Excel training courses (covering Beginners’ to Advanced) for one low price and 12 month’s course access (or LIFETIME access if you choose) — equivalent to 5 full days of face-to-face training!

 

What will you learn?

A brief outline of our Microsoft Excel training courses:

 

Microsoft Excel Online Training - Excel Beginners, Excel Intermediate & Excel Advanced Courses from $29

These courses are available in 9 separate 4 hour courses

Microsoft Excel Beginners’ Essentials training courses

 

Microsoft Excel Intermediate training courses

 

Microsoft Excel Advanced training courses

Receive Your FREE Sample!

Learn Free Microsoft Excel Beginners Training Course Workbook

Try before you buy with our Absolute Beginners’ Microsoft Excel 301 Training Course Workbook — get it now! 

EzyLearn Online Accounting Training Job Outcomes

Our courses are designed for employment outcomes. To help you land that job or improve your position, learn using real-world scenarios that mirror reality and are interesting and relevant.

It doesn’t matter how you learn; we have videos; training workbooks; Knowledge Reviews to test your absorption as you go, and much more.  

You’ll get Excel spreadsheet templates, Excel samples and pre-populated Excel files which you can download and actually use in your own business. 

 

 

"HAVING BEEN OUT of the corporate workforce for a few years and only knowing an outdated accounting software system, I was pretty nervous about where to start as I’m now running my own business.

The fact that I could work the training around my busy schedule was wonderful and the online support was a huge bonus.

It’s been a huge part of my success and I cannot recommend EzyLearn highly enough!”

DEANA MALLARD

Self-Employed

The reviews at the end of each module was the best part of the course.” 

— Marie Powney, Camellia NSW 2142

“The videos are the best part of the course. I could follow through the Training Manuals and if I didn’t understand I could go back to the Training Videos.” 

— Helen Livingstone, Waurn Ponds VIC 3216

“The exercises were great to do for practice.” 

— Barry Bryant, Armstrong Creek QLD 4520

See more EzyLearn course reviews and ratings from students, including close to where you live

 

 

Our Pricing

EzyLearn Online Course Course Catalogue & Prices for Excel, MYOB, Xero, WordPress, Facebook and Social Media Marketing Courses Logo

We have the cheapest prices in the business — yet don't compromise on quality: here's how.

Remember, it's ONE price for all 9 Excel courses: see our course prices.

You can access EVERY new Excel course we create (including new Excel 2016 courses) during your 12-month course access period or FOR LIFE if you choose our popular Lifetime Access option.

 

EzyLearn GROUP Discounts - Corporate Training for Excel, Social Media, MYOB, Xero

Do you have a group of 3 or more people who need to learn Excel (and other courses) at the same time? Take a look at our Group Discount Pricing.

 

EzyLearn Online Accounting Training Bookkeeping Courses in Xero, MYOB, QuickBooks Online

Individual Microsoft Excel Training Courses from $29 each

If you only want to purchase selected, "individual" courses, please see the prices at our New Course Catalogue website. 

Purchasing course-by-course this way can be ideal for CPD training courses and study.

EzyLearn Online Microsoft Excel Training Course Frequently Asked Questions LogoWe answer pretty much every question ever asked about our Excel training courses at our
Excel Course Frequently Asked Questions page.

If you still have questions, don’t hesitate to call us, email or chat.

 

Microsoft Office Beginners’ Essentials “Combination Offer”

EzyLearn Microsoft Office Beginners Essentials logoAre you a beginner to the Microsoft Office suite of programs? Would you like to learn all of these in ONE, easy-to-learn training course?

We created the Microsoft Office Beginners’ Essentials Course for this reason. This course is a “combination training course” which teaches you how to use the different programs included in the Microsoft Office Suite.

In the Microsoft Office Beginners’ Essential Course you will learn how to:

  • navigate, use and create documents
  • create spreadsheets and presentations
  • manage emails, calendars, contacts and tasks.

 

The Microsoft Office Beginners’ Essentials Course is available for ONE LOW PRICE with 12 months’ access and the option of a Certificate if you want one. Enrol in this training course and you’ll also receive the Free Student Inclusions that come with being an EzyLearn student.

To Recap: WHAT DO YOU GET?

(CLICK HERE FOR YOUR FREE SAMPLE)

The Excel training course contents in detail:

Microsoft Excel (Course 301) — Open and Understand Spreadsheets

EzyLearn online course website link to Excel Course exercise files

Our Microsoft Excel Course 301 will teach you the following about Excel spreadsheets:

  • The Excel screen toolbars, formula bar, name box, column and row headings, sheet tabs
  • Uses for Excel (Worksheet, Database & Charting)
  • Navigating an Excel spreadsheet using keyboard & mouse
  • Moving between Excel workbooks
  • Selecting (or highlighting) cells, columns and rows & entire spreadsheets within Excel
  • Entering information into workbooks and resizing columns using Excel.

DURATION: 4 hours (see FAQ’s for more details)

Read more about the Microsoft Excel Beginners’ Courses (and receive your free sample)

 

Microsoft Excel (Course 302) — Create & Edit Spreadsheets

Our Microsoft Excel Course 302 expands on your knowledge of Excel spreadsheets by teaching you how to:

  • Select cells, columns, rows & ranges using mouse & keyboard within Excel
  • Copy / Paste: Drag and drop, from range to range and to other worksheet & different software programs
  • Edit cells: entering and modifying, submitting changes, using status bar, escaping formula errors
  • Change column width, row height for single and multiple columns & make all columns uniform
  • Use the Excel Database: Creating a simple database, database structure, basics for mail merge with Microsoft Word), Inserting and deleting columns, using Undo and redo options
  • Manage Excel Autofill: fill numbers, dates, number patterns, days, months and years and much more
  • Understand date formatting.

DURATION: 4 hours (see FAQ’s for more details)

Read more about the Microsoft Excel Beginners’ Courses (and receive your free sample)

 

Microsoft Excel (Course 303) — Formulas, Functions, Formatting

In the Microsoft Excel Course 303 you will learn about:

  • Formulas: Entering formulas using keyboard, arrow keys and mouse
  • Relative cells references, common formula errors, using multiplication, division and combine two formulas
  • AutoCalculate: Create additions and basic functions quickly
  • Functions: Intro to functions & function syntax, Autosum, Autosum multiple ranges, intro to basic functions (Maximum, Minimum, Average)
  • Functions in more detail: Sum, formula bar, editing functions, F2 key, Autofill to quickly copy functions
  • Formatting: How your spreadsheets look, lines, colours, shading, text and number size, font, colour
  • Currency formatting, date & text formatting
  • Merging cells, centring, alignment formatting fill colour, font colour and borders
    Advanced formatting,  Autoformats, repeat regular actions quickly, format painter.

DURATION: 4 hours (see FAQ’s for more details)

Read more about the Microsoft Excel Beginners’ Courses (and receive your free sample)

 

What’s in the Microsoft Excel Intermediate Courses:

Microsoft Excel (Course 304) — Viewing & Printing

In Microsoft Excel Course 304, learn all about:

  • Views:  Zoom (set and custom), Print preview and Page Break preview versus Normal view
  • Page Setup: Page orientation, scaling & margins
  • Print areas: Setting & clearing defined print areas, differences with default & set page breaks; inserting & moving page breaks
  • Changing the print order of pages; centring the spreadsheet when printing; showing/hiding gridlines & headers
  • Introduction to headers and footers, using preset & custom headers & footers; using file information & common fields
  • Freezing panes when viewing to keep headers visible while scrolling; repeating rows to keep headings printed on every page, and other printing options.

DURATION: 4 hours (see FAQ’s for more details)

Read more about the Microsoft Excel Intermediate Courses

 

Microsoft Excel (Course 305) — Charts & Graphs

Our Microsoft Excel Course 305 takes you through using Charts and Graphs, including:

  • Charting: Creating a simple chart see charts change (dynamic) based on information entered in cells
  • Inserting labels for heading, the x & y axis, values
  • Charting multiple rows and columns; organising sheet tabs for new chart sheets
  • Changing data ranges in the chart wizard; charting several separate data ranges; charting options & charts types (eg. pie charts)
  • Chart formatting: understand chart objects for formatting; chart toolbar buttons and using right-click to format
  • Formatting a data series and parts of a pie chart; having two different data formats within the one chart and how to get charts into Microsoft Word documents.

DURATION: 4 hours (see FAQ’s for more details)

Read more about the Microsoft Excel Intermediate Courses

 

Microsoft Excel (Course 306) — Intermediate Functions & Cell Referencing

After the Microsoft Excel Course 306, you’ll be proficient in:

  • Number & percentage formatting: Use percentage formatting to better use them in formulas and functions
  • Understand cells formatting (even without data in them)
  • Relative & Absolute Cell references: How relative cell referencing works when copying formulas & functions quickly (and when they don’t work and why)
  • Use Absolute cell referencing to reduce the amount of calculations in a spreadsheet
  • Learn and understand fundamental mathematical functions (skills that make more complicated functions easier to understand)
  • Combine two formulas into one and write better formulas and get to know the order of mathematical calculations
  • Using Functions like Maximum, Minimum and average
  • Understand the “Insert Functions dialog box”,  search for functions and understand “arguments” (or syntax) in functions and function categories such as financial, Date and time, maths and trig
  • Understanding and constructing an IF Statement
  • Comments: Uses for comments. Insert comments to explain the purpose of a cell, choose size and location of the comments and control the way they appear on the spreadsheet; edit comments & change comment formatting
  • Show/Hide Columns/Rows: hide columns or rows with confidential information. Print the spreadsheet without the confidential information.

DURATION: 4 hours (see FAQ’s for more details)

Read more about the Microsoft Excel Intermediate Courses

 

What’s in the Microsoft Excel Advanced Courses:

Microsoft Excel (Course 307) — Databases, Filter/Sort, Named Ranges

Microsoft Excel Course 307 takes you further into:

  • Excel program options, automatic calculation, error checking rules, customising the ribbon and quick access toolbar
  • Format & structure of databases: delimiters, headers, records, fields, flat file vs relational data
  • Filtering and sorting data and different data formats like Comma Separated Values (CSV), TXT, Tab separated values and how to open data in different programs
  • Naming Ranges and using Named Ranges in formulas. Data validation and drop down lists and mastering find and replace.

DURATION: 4 hours (see FAQ’s for more details)

Read more about the Microsoft Excel Advanced Courses

 

Microsoft Excel (Course 308) — Pivot tables, 3D Formulas, Advanced Formulas and Protection

The Microsoft Excel Course 308 will teach you how to:

  • Understand 3D formulas between worksheets
  • Clean up data using advanced filter
  • Create a pivot table and change the value field settings, create a pivot chart to visually show the stats
  • Use advanced functions like CHOOSE, VLOOKUP, HLOOKUP, MATCH and INDEX
  • Navigate advanced functions within functions (Nested Functions) and how to protect the worksheet and workbooks.

DURATION: 4 hours (see FAQ’s for more details)

Read more about the Microsoft Excel Advanced Courses

 

Microsoft Excel (Course 309) — Goal Seek, Data Consolidation and Solver

Microsoft Excel Course 309 advances you in how to:

  • Find out how much you can afford to pay for a house using goal seek and financial functions
  • Consolidate the information from several sheets
  • Use data grouping
  • Use solver to explore possible outcomes depending on input variables.

DURATION: 4 hours (see FAQ’s for more details)

Read more about the Microsoft Excel Advanced Courses

Want to know even more?

Read the FULL STORY about our Excel training courses

 

 

 

30 Day Money Back Guarantee

MYOB, Xero, Excel, QuickBooks 30-Day-money-back-guarantee for Online Training Courses

FREE TRAINING: Xero, Excel, MYOB & more

EzyLearn Online Training Course Free Samples for Microsoft Excel, Word, Xero, MYOB and more

Job Outcomes You Can Expect

EzyLearn Accounting job, Bookkeeping jobs, part-time, casual contract, fulltime, Xero, MYOB, QuickBooks Training Courses cropped

An Update from the CEO

Steve Slisar EzyLearn lifetime course access, xero training courses and lifelong training updates and additions

 

Some of Our Business Clients

Employer Recognised and Trusted Online Courses

More Detailed information & lifelong learning Excel spreadsheet software with EzyLearn

 

EzyLearn Online Courses & Free Guides

EzyLearn Online Course Course Catalogue & Prices Logo

EzyLearn Xero, MYOB, Excel & Social Media Marketing Course testimonials, reviews and recommendations Official

testimonials and faces of happy students

Online Training Course special offers for MYOB, Xero, Excel, Word and more

Free online Microsoft Office Courses in Excel and Word & more

Click Image to See All Training Courses

EzyLearn Online Courses in Xero, Excel, MYOB from $69

EzyLearn Digital & Social Media

Live News & Updates

Free Microsoft Excel beginners course training manual. lnkd.in/fR6JSkb

About 3 hours ago from Steve Slisar's Twitter via LinkedIn

Subscribe to Our Blog

Enter your email address:

Delivered by FeedBurner

MOST POPULAR COURSES

Xero online training course - quotes, sales, orders, purchases, bank reconciliation, payroll, gst, reporting and BAS logo - small Microsoft Excel 2013 Spreadsheet training courses beginners intermediate advanced myob online training courses and student support - learn how to use MYOB bank recs, payroll, reports, data entry Digital & Social Media Marketing Training Course Google, Facebook, WordPress logo

 

WordPress website and blogging marketing training course logo, tags and categories for SEO Training Courses

Facebook social media marketing and advertising course logo

RSS EzyLearn Blog

  • MYOB Payroll Administration Essentials Training Courses 2019-05-19
    One thing is essential when you operate a small business with staff — that is your payroll obligations. I wrote about a hairdressing salon owner a few months ago who told me how easy payroll was to manage using a printed timesheet book. However, most tech-savvy people prefer to use software.  MYOB Essentials is targeting […]
  • Is Business Quiet? Need More Money/Sales? Use a Database! 2019-05-17
    When I started my first business in Sydney’s Dee Why in the early 1990’s, I was amazed that most restaurants and cafes, as well as other retail shops like dress shops, didn’t even know who their customers were! Many business owners knew their customers by face, but they missed out on lots of opportunities to […]
  • Clear Out Albert, Cherie’s Getting Square! (PayPal Alternative) 2019-05-07
    There are so many wonderful ways business owners are using technology every day for their digital marketing, as well as point-of-sale (POS) and bookkeeping. Last week I met Cherie. Cherie owns a relaxed cafe in the holiday haven of Forrester’s Beach, NSW, and she let me record a short video of a customer paying for […]
  • Is now a good time to invest into a new property – in Newcastle? 2019-04-30
    I completed a Cert IV in Property Services a couple years ago and have a strong interest in real estate as an asset for investment. There is a lot of talk currently about negative gearing and whatever happens, we will all be affected. It’s the “wind that blows” according to Jim Rohn, a great inspirational […]
  • How We Create a Xero Training Course 2019-04-08
    MYOB AccountRight, QuickBooks Online and Xero come with job costing and job tracking functions allowing users to develop more accurate budgets and avoid cost blow outs. I’m excited to be delving deeper into a micro course specifically targeting how you can manage on-the-job costs and track your project. This will be included in all of […]
  • Why is job tracking and project costing so hard using MYOB & Xero? 2019-03-26
    In many industries, no two jobs are the same, making estimating job costs and resources tough. Job tracking is one of the best ways to develop an accurate budget and avoid blow outs. But this can be hard work. Are the latest job costing and tracking functions in MYOB AccountRight, QuickBooks Online and Xero making […]
  • Should You Send Reports to Late-Paying Clients? 2019-03-26
    Want to learn how you can really manage late payers? Simply by reconciling more regularly, you can use a “real time” snapshot of your cash flow in your accounting software, rather than relying on your bank balance. PART OF THE credit management process involves sending statements to clients when their account becomes overdue, calling them […]
  • Are EzyLearn students just like YOU? 2019-03-19
    ‘Social proof’ is testimonials, reviews and feedback of others, that vouches for the product or service we’re thinking of buying. Social proof backs up the fact that what we’re considering buying is what it says it is. Come see some social proof about EzyLearn by meeting some students from the past few weeks — you just […]