Select Page

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

 

 

EzyLearn Online Courses - SPECIAL OFFERS - Cheap Xero, MYOB, Excel, WordPress Courses 2018 January5 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 learn, 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 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)

 

 

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

 

EzyLearn Online Xero, Excel, MYOB Training Course Prices Logo* Our online Microsoft Excel training course includes everything.
* It is ONE price (see enrolment page for course prices) for ALL 9 courses
* and every new Excel course we create including (new Excel 2016 Courses)

 

Free Microsoft Excel Beginners Training Course Workbook

Microsoft Excel Online Training Courses CONTENT

Each of our Microsoft Excel Training Courses are designed as a half day training session for the training centres we use to operate in Sydney between 2000 and 2006. Although we include all of these 9 courses for the one low price we’ve demonstrated below how they 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

 

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

(free sample available – click here)

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, centering, 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 whe 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

 

More Detailed information & lifelong learning Excel spreadsheet software with EzyLearn

 

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

EzyLearn Digital & Social Media

Live News & Updates

These cheap, discounted course prices will end soon so be quick to get the current special prices and have 12 months course access to complete it at your own pace. Xero, Excel, WordPress, MYOB, QuickBooks online and social media marketing lnkd.in/gEWEpXG

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

Subscribe for tips, news and updates

Enter your email address:

Delivered by FeedBurner

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

Online Course 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.]

%d bloggers like this: