EzyLearn Online Courses logo - Microsoft Excel 2016 training & supportMicrosoft Excel Training Courses

Excel Beginners’, Intermediate & Advanced Excel Training Courses

 

One Price for ALL 9 Courses

Click on each skill level to see what is included in the total Microsoft Excel Training Course Package!

 

 

5 FULL days of Microsoft Excel training divided into easy-to-learn, half-day courses

We separated our Microsoft Excel training courses into half-day courses to adapt to how HUMANS optimally learn — and not because we have to allocate a trainer and training rooms by the day! That’s why we’re an ONLINE-only Excel Course provider — you get more course content, delivered in a format which makes it easier to learn, at your own pace, and easier to fit into your busy HUMAN life.

Microsoft Excel Beginners’ Essentials Training Courses and Certificate

– Duration: 12 hours (click to view)

 

Microsoft Excel Intermediate Training Courses and Certificate

– Duration: 12 hours (click to view)

 

Microsoft Excel Advanced Training Courses and Certificate

– Duration: 12 hours (click to view)

 

 

Our Microsoft Excel Online Training Course Content

Originally, each of our Microsoft Excel training courses was designed to be taught in half-day training slots or sessions at the training centres we ran all over Sydney between 2000 and 2006. We include all of our 9 Excel online training courses for the one low price; and you can spend as much or as little time as you need on each course component. We demonstrate below how our online Excel courses are usually separated into Beginners’, Intermediate and Advanced Excel courses.

Exercise Files

Template, sample and pre-populated excel files are used all the way through the entire 9 courses so you can download and work on the actual files included in each and every course. The videos show you how to work with the files and the workbooks take you through step-by-step instructions.

Learn about the Excel Training Course exercise files

We Use Real World Case Studies and Scenarios

Our courses use real-world scenarios that mirror what actually happens to provide you with course content that is relevant and interesting.

Find out more about our micro courses and case studies

What Our Students Have to Say

Students across Australia, and indeed the world, are choosing to use EzyLearn online training courses to learn cloud accounting, Excel at all skills levels, digital marketing and business start up.

Read more about the companies we work with and our satisfied student testimonials

 

 

Most Microsoft Excel Course Questions Answered

EzyLearn Online Microsoft Excel Training Course Frequently Asked Questions LogoWe’ve answered pretty much every question that our students have asked at our
Excel Course Frequently Asked Questions page, so feel free to visit that page first.
If you still have questions, please call us, email or chat.

 

Cheaper Microsoft Excel Course Prices

EzyLearn Online Xero, Excel, MYOB Training Course Prices Logo* Remember, our online Microsoft Excel training course includes everything!
* It is ONE price (see enrolment page for course prices) for ALL 9 courses, and
* 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.

Cheaper separately or for 3 or more students

When you enrol into the COMPLETE set of courses you get tremendous value for money but if you only want selected “individual” courses see the prices at our Bookkeeping Academy website, ideal for CPD Training Courses.

If you have 3 or more staff or a couple friends who all need to learn Microsoft Excel (and other courses) at the same time, take a look at our Group Discount Pricing.

Get yourself a FREE sample

Everyone should know how to use Microsoft Excel and spreadsheets, particularly if you need it for your work or personal finances so we give away our Absolute Beginners to Microsoft Excel 301 Training Course Workbook!

It also gives you a good idea of the process that we follow when we create a new course to help students learn by taking them from basic to more advanced concepts as they are needed using the software. Get your free Microsoft Excel Beginners workbook now.

Free Microsoft Excel Beginners Training Course Workbook

EzyLearn online course website link to Excel Course exercise files

These are just some of the dozens of exercise files included in the Excel Training Course. Click the image to see them all

Microsoft Excel Beginners’ Course

CLICK HERE FOR YOUR FREE SAMPLE!

Microsoft Excel (course 301) — Open and Understand Spreadsheets

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

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

  • Selecting cells, columns, rows & ranges using mouse & keyboard
  • Copy / Paste: Drag and drop, from range to range and to other worksheet & different software programs
  • Editing cells: entering and modifying, submitting changes, using status bar, escaping formula errors
  • Changing column width, row height for single and multiple columns & make all columns uniform
  • Database: Creating a simple database, database structure, basics for mail merge with Microsoft Word), Inserting and deleting columns, using Undo and redo options
  • 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

  • Formulas: Entering formulas using keyboard, arrow keys and mouse
  • Understand 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)

 

Microsoft Excel Intermediate Courses

Microsoft Excel (course 304) — Viewing & Printing

  • 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 & move page breaks
  • Changing print order of pages, centering 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, and 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

  • Charting: Creating a simple chart see charts change (dynamic) based on information entered in cells
  • Inserting labels for heading, the x & y axis, values
  • Chart mutliple rows and columns, Organising sheet tabs for new chart sheets
  • Changing data range 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 2 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

  • 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

 

Microsoft Excel Advanced Courses

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

  • 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

  • Understand 3D formulas between worksheets
  • Cleaning up data using advanced filter
  • Create a pivot table and change the value field settings, create a pivot chart to visually show the stats
  • Advanced functions like CHOOSE, VLOOKUP, HLOOKUP, MATCH and INDEX
  • 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

  • Find out how much you can afford to pay for a house using goal seek and financial functions
  • Consolidate the information from several sheets
  • 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

 

IT’S ALL INCLUDED for 1 LOW PRICE
(see Excel Course Prices)

 

Read the FULL STORY

 

An Update from our CEO

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

 

Bank Reconciliation for End of Month and Year

Bank Reconciliation, end of month, transaction journal entries, data entry & adjustments training courses in Xero, QuickBooks & MYOB

Employer Recognised and Trusted Online Courses

EzyLearn Online Courses & Free Guides

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

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

Free online Microsoft Office Courses in Excel and Word & more

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

Marketing Academy Training Courses in Facebook, WordPress, Google and Social Media & CPD for real estate agents

Subscribe

Enter your email address:

Delivered by FeedBurner

FREE MYOB Training Videos

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

Student Testimonials

“It is easy to access, straight to the point and time efficient — it is extremely user friendly!”

— Lize Johnson, Sydney
[“I’m getting skills to find work.”]

 

“Comprehensive and easy to understand. Thanks!”

— Christine Park, Perth
[“I want to be more productive in my current job.”]

 

“The videos are concise: short enough in length to absorb the information and yet all aspects are clearly explained.”

— Samantha Galbin, Brisbane
[“I want to start my own business.”]

 

“It is an ideal course for beginners and for brushing up skills.”

— Patricia Smith, Sydney
[“I want to start my own business.”]

 

“I really like the ability to go back and reference the videos; …. I really like having it right there on my desktop in case I forget how to do something. I did the online course and I really like to work at my own pace.”

— Tammy Steeves, Melbourne
[“I want to be more productive in my current job.”]

 

“The assessments were the best part. Liked the fact that I could know if I got the question right or wrong immediately.”

— Philip Sayce
[I want skills to find work.]

 

“The best parts are the tests, probably because i love challenges… throu the tests is possible to prove what you`ve learned watching the very easy to understand videos. 

But i would also like to say that the all course per se was absolutely great.”

— Massimo Piras
[I want skills to find work.]

 

“It is all really good I couldn’t pick if I tried. I have tried to use MYOB in the past but it never made sense to me. But after doing your course it makes more sense.

Thanks”

— Linda Matanovic
[I need skills to find work.]

 

“you can decide your own learning rate”

— Don Cheung Tsang Hee
[I want skills to find work.]

 

“Easy to follow and videso are clear and concise.”

— Loretta Heraghty
[I want a certificate.]

 

“Being able to learn at my own pace, the videos and workbook were clear and easy to understand.”

— Evonne Ng
[I need skills to find work.]

 

“I like how I can now go back over the videos and review them again, especially on areas that I didnt fully understand the first time around.”

— Kerry Copeland
[I want to be more productive in my current job.]

 

“I had a look at in class courses run through Perth and they were all priced around the $1000 mark. I was willing to pay that untill i looked a their outline and it was all padded with OH&S and unrelated topics which i wasnt interested in learning. This online MYOB course was not only 1/4 of the cost but it got straight to the point, taught me everything i need to know to start my new job on monday and i was able to do it at rmy own pace. LOVED IT!!!!”

— Angela DeBoni
[I want to be more productive in my current job.]

 

“learning in my time and not rushing to get to class and can stop when i need to do other task of my employment”

— Erica Haselwood
[I want to be more productive in my current job.]