Microsoft Excel Advanced Training Courses

Microsoft Excel Advanced Courses

These Excel Advanced Courses are included with all our Microsoft Excel training courses for one low price and either 12 month’s or Lifetime Course Access.

Be sure to check out our Specials page to see if you are eligible for a discounted price on Excel courses!

Our Microsoft Excel Advanced Online Course includes everything. It’s one price for all Excel courses (and all new courses we create). Plus we regularly create micro courses containing case studies and add them to our online courses:

Microsoft Excel Advanced Course 307 Workbook Screen Shot

Microsoft Excel (Course 307)

Databases, filter/sort, named ranges

Looking at Excel program options, automatic calculation, error checking rules, customising the ribbon and quick access toolbar. The format 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.

Return to Excel Advanced Training Course – Top

 

Interested in Other Offers or Corporate Training?

current special offers for MYOB, Excel, Xero and Word coursesIf you are interested in doing more than one course OR you manage a team of people and are interested in our other courses we have ALL YOU CAN LEARN training programs that might suit your business needs. These all come with the same great EzyLearn features:

  • Enrol Now, Learn Fast
  • All skills levels included covered (Beginners’ to Advanced)
  • Training videos, workbooks, exercises and tests
  • Go over the course material as often as you need

See our latest Group, Discount, Combo and Corporate Training Offers.

 

Microsoft Excel Advanced Course 308 Workbook Screen Shot - pivot tablesMicrosoft Excel (Course 308)

Pivot tables, 3D formulas, advanced formulas and protection

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, using advanced functions like CHOOSE, VLOOKUP, HLOOKUP, MATCH and INDEX, look at advanced functions within functions (Nested Functions) and how to protect the worksheet and workbooks.

Return to Excel Advanced Training Course – Top

Case Studies included in this workbook:

As part of our Advanced Microsoft Excel Online Training Course, we feature an additional micro course which comes to you by way of an Ad Hoc Payroll case study. This case study is part of our advanced Excel course and comes at no extra course.

Microsoft Excel Advanced Course 309 Workbook Screen Shot - Goal seek for loan repaymentMicrosoft 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, understanding the grouping of data, use solver to explore possible outcomes depending on input variables.

Return to Excel Advanced Training Course – Top

Case Studies included in this workbook:

 

 

online-training-courses-price-buttononline-training-courses-frequently-asked-questions-buttononline-training-courses-discount-buttonfree-course-guide-for-online-training-courses

 

Case Studies

The regular creation of new and expanded content for our courses is a foundation goal for EzyLearn and every student benefits. Learn about some of the real-world scenarios and case studies we use in our training courses and micro courses. Learn more.

 

Our other online courses

Horizontal Banner with software training courses in MYOB, Excel, WordPress, Word, Xero, Facebook and digital social media marketing

Enrol into our Advanced Microsoft Excel Online Training Course and you’ll automatically receive free access to the first course for several of our other online courses.Click the image to see the other courses we offer.

 

Microsoft Excel Training Courses Microsoft Excel Course Units

Enrol Now
See some FREE Excel Beginners Training Videos

Excel Advanced Course: Named Ranges, Databases - 307
Starts: 04/03/2017 09:30 am
Ends: 04/03/2018
Duration: 23 hours:
246 Pacific Hwy
Crows Nest, NSW
2065
AU
Excel Advanced Course: Pivot Tables, 3D Formulas - 308
Starts: 04/03/2017 09:30 am
Ends: 04/03/2018
Duration: 23 hours:
246 Pacific Hwy
Crows Nest, NSW
2065
AU
Excel Advanced Course: Goal Seek, Consolidate - 309
Starts: 04/03/2017 09:30 am
Ends: 04/03/2018
Duration: 23 hours:
246 Pacific Hwy
Crows Nest, NSW
2065
AU
 
%d bloggers like this: