Microsoft Excel Advanced Courses
These Excel Intermediate Courses are included with all our Microsoft Excel training courses for one low price and either 12 months or lifetime course access.
Check out our specials page to see if you are eligible for a discounted price on Excel Courses!
Unlike some of the larger training companies, our online course includes everything. It’s one price for all courses (and new courses we create):
- Excel 307 Advanced Course: Databases, filter/sort, named ranges
- Excel 308 Advanced Course: Pivot tables, 3D formulas, Advanced Formulas and protection
- Excel 309 Advanced Course: Goal Seek, data consolidation and Solver
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.
Interested in other offers or Corporate Training?
If 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. All with the same great EzyLearn features:
- Enrol Now, Learn Fast
- All skill levels included (beginners to advanced)
- Training video, workbooks, exercises and tests
- Go over the course material as often as you need
See our latest Group, Discount, Combo and Corporate Training Offers..
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, 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.
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.
Our other online courses
Enrol into this course and you’ll automatically get free access to the first course for several of our other online courses.Click the image to see the other courses we offer.