Excel Expert Advanced Excel Training

Are you ready to take your Excel skills to the next level with our Excel Expert training course?


Do you want to pursue a career in Excel related work?

Are you finding that employers these days want ‘Advanced Excel Skills’?

Or maybe you’ve started a new job that requires more advanced Excel skills.

Our Excel Expert course is designed to take you from zero to hero so you can confidently list ‘Advanced Excel Skills’ on your resume/CV, or quickly get to grips with the requirements of a new job.

Separator Image

Watch a Sample Tutorial on Troubleshooting Formulas

For best viewing quality: press play then 1. click the cog and select 720p HD, and 2. click the icon on the bottom right of the video to view in full screen.


Separator Image

What You Get in the Course

  • Over 14 hours of video tutorials covering everything from beginner topics right through to advanced. Pick and choose what you need to learn to get your skills up to date, and skip the lessons you don’t need.

  • Categorized tutorials – What might be advanced to one person is an intermediate topic to another. I’ve taken the guess work out and tagged each tutorial with a level (Beginner, Intermediate and Advanced). Now you can go to that job interview confident that you’ve mastered the advanced topics.

  • Applies to Excel 2007 and 2010 – Plus videos on new Excel 2013 features are coming soon.

  • Formula Mastery – a huge range of formulas are covered including in depth understanding of array formulas and how they work. I’ve also included practice questions so you can truly master them.
    View the Syllabus
  • The pace is pretty fast because I hate courses that waffle on. I like to get straight to the point so you’re up to speed fast, and I’ve designed it so that if you need to re-watch anything you can rewind and replay the videos as many times as you like.

  • You can download the actual Excel files used in the filming.
    • Use them to practice what you learn and build your confidence.
    • Session 14 on Lookups and Statistics, and Session 15 on Conditional Logic include additional practice questions and answers, as these are some of the most important formulas to master.

  • The training is delivered online and tutorials are available to watch 24/7 at your own pace. Pause, rewind, replay as many times as you like.

  • 12 months access to the online video tutorials and file downloads. There’s even an option to download all videos in the course and keep them on your own PC forever.

  • When you’ve finished I’ll send you a ‘Certificate of Completion’ which you can add to your resume/CV arsenal.

Separator Image

Who is behind the Excel Expert course?

Mynda

That would be me, I’m Mynda Treacy, Co-founder of My Online Training Hub.

I mostly teach the advanced topics and Jeff (our Certified Microsoft Office Trainer), mostly teaches the beginner and intermediate topics.

I have been working with Excel since 1995 and teaching since 2010 (not including teaching many colleagues over the years), and I’m excited to be able to share what I have learned with you.

Back when I started using Excel I was lucky, in that you weren’t expected to know how to use it!

Those days have long passed and now you need to at least list ‘Advanced Excel Skills’ on your resume/CV to even get an interview.

Then in the interview expect to be tested on a myriad of tasks including advanced formulas like VLOOKUP, IF, SUMPRODUCT, INDEX and MATCH to name a few, plus other features like PivotTables, Conditional Formatting, and maybe even Macros.

And that means you need to be confident that you genuinely have ‘Advanced Excel Skills’.

What you learn in this course will apply to all you do in Excel. From best workbook design, right through to advanced formulas and charting.

Once you’ve completed the course and practiced what you learn you’ll be able to confidently state on your resume/CV that you have ‘Advanced Excel Skills’ so you can pursue that new job opportunity, get that promotion, or comfortably tackle the tasks in your new job.


Separator Image

Choose your membership level:

Excel Expert Course Excel Expert Course + Premium

Choose your currency:

USD

Online Only

$
97
USD

Online + Download

$
197
USD

Online Only

$
177
USD

Online + Download

$
477
AUD

Online Only

$
97
AUD

Online + Download

$
197
AUD

Online Only

$
177
AUD

Online + Download

$
477
GBP

Online Only

£
66
GBP

Online + Download

£
133
GBP

Online Only

£
120
GBP

Online + Download

£
322
Excel Expert Course for 2007, 2010 & 2013 versionsClick for Excel Expert Course Syllabus
white tick white tick
One Payment for 12 Months Online Access
Download & Keep Videos*
red tick white tick
red tick white tick
Available 24/7Excel Expert Course Avaiability
Play, pause, rewind, replayExcel Expert Course Features
Download WorkbooksExcel Expert Course Practice
Word Premium Course 5hrs Click for Excel Word Syllabus
Outlook Premium Course 6+hrs Click for Outlook Word Syllabus
102 Excel Tips & Tricks VideosExcel Expert Tips and Tricks
95 Word Tips & Tricks Videos
98 Outlook Tips & Tricks Videos
Access to new Microsoft Office Training Click to find out what updated training is included
Excel Only
30 Day Money Back GuaranteeExcel Expert Course Guarantee

*Videos will be available for download 30 days after signing up. Note: prices are +GST for Australian customers.

PayPal Credit Card Logos
You can pay with a Credit Card on PayPal – You Don’t Need a PayPal Account.
Click here to see how

Separator Image

Love It or Get It Free Guarantee

30 Day Guarantee

This course is being taught online … so it’s not like you have to send anything back if you’re not happy.

So here’s the deal:

Enrol now and take the course. I mean REALLY take the course. Download the workbooks, watch all the videos, ask me questions. Get as much out of it as you can.

Once you’re done, ask yourself, “was this worth it?”

If your answer isn’t a resounding YES, then let me know within 30 days and I’ll refund you, no questions. So you literally have nothing to lose.

What our members are saying…

quote marks Hi, Mynda

I NEVER respond to these types of emails – and rarely, if ever write-in to a company; however, I have been VERY impressed with myOnlineTraininghub … the vast amount of information, as well as (and especially) the user-friendly format … I truly have been telling everyone about it!

I visit several times a week as I continue through the lessons (the ability to start/stop whenever I want is fabulous!).

I started at the beginning, even though I felt very comfortable with what I knew, but found that you offered so many hints and suggestions of which I had been completely unaware – or confused about.

Thank you for this extremely valuable product!

Beth Taber. Ipswich, MA.

When joining I was unsure as to quality of training. I looked at the information you had on your website and this convinced me it was better to use your training as I can do it self-paced with tutorials, which is a better learning environment for me.

When I did Advanced Excel for 2003 we were rushed through everything in 4 hours and most of it was not retained by me. So, the value for money and training your course offers is better suited to me.

Since starting the training I am utilising excel 2010 much better, reports are looking better than before, and I am able to get more information out of a pivot table.

I have suggested to management that they look into your course for all Admin staff and have also recommended to company that they see if they can buy the course to suit their own training system.

Ronnee Meachen

I am always at least a little sceptical about ordering anything from an unfamiliar source, but I decided that it was worth taking the chance on this.

I took the free tutorial on VLOOKUP and I was really pleased with the way it was presented – in such a clear and straightforward manner – that I felt confident that the material offered would be of great quality.

I have covered a number of topics that were previously a mystery to me and have received prompt responses to the questions I have asked.

I have already recommended it to two family members. I would certainly recommend it to friends, colleagues, etc.

Marguerite
… I would highly recommend My Online Training Hub for all your Microsoft Office needs …. Geniuses

Michael Portelli – Dept. of Business & Innovation, Victoria, Australia

For me, the folks at myonlinetraininghub.com set themselves apart through the use of “English translations” of Excel’s very cryptic syntax, and excellent use of color coding each segment of the syntax. I was able to focus on learning to speak “Excel-ish” and create, instead of being distracted “counting commas” as I tried to follow the cryptic syntax. (Be honest. You’ve done it.)

By comparison, around the time I discovered myonlinetraininghub.com, I purchased a rather expensive Excel book. It was 3″ thick, and over 900 pages. Standing in the bookstore it appeared to be everything I would ever want to know about Excel 2010. But I later realized this manual was really just a complete set of Excel commands and functions. The format was simply: “You want to find out ? – here is the syntax – and here is the formula.” There was very little explanation of how the syntax actually works….how Excel “thinks”. Therefore the examples were of little use beyond those specific examples. It is a testament to the knowledge of the author, but it isn’t a teaching tool.

Mynda’s lessons are teaching tools! Mynda will teach you how Excel “thinks”, and how you can create formulas for your unique needs. Besides, you know what they say – “Give a man a fish and you feed him for a day. Teach a man to fish and…. he will spend all his time in the basement making lures, while neglecting his wife and personal hygiene.”

But seriously, more important than learning a bunch of commands, Mynda’s teaching style has opened the door to the true power of Excel – connecting commands! Take INDEX & MATCH for example. Individually, these commands are rather limited in their use. But together, the possible uses are limited only by my little brain. And it all starts with Mynda’s “English translation” and color coding teaching methods.

Lastly, a book is just that…a book. There is no feedback, much less ongoing interaction, with a book. Mynda is there to provide feedback, tips, and encouragement when your latest creation goes awry.

I would recommend myonlinetraininghub.com to anyone. Actually, I have already recommended them to a CPA friend after she asked me what I knew about Pivot Tables.

Bob Baxter

I was so pleased with your product and service that I went ahead and purchased the same product for my son and he lives with us!

I want him to learn so that he can help me.

Thanks and keep up the good work.

Vincent Langan.

I am always unsure and sceptical about joining anything on the internet. I have been had a lot of times but not this time.

I can say that I found your online tutorials very useful. I am making use of Microsoft software every day and I can say that now I am finding it easier to work it.

I would recommend your training to a couple of my friends who like me, are making a living out of the computer.

Thanks once again for an excellent site and tutorials.

Albert Zammit

I am really enjoying the online training. It is my first attempt and I was sceptical at first as to whether or not this learning style was right for me.

Support from you and the video instructors has been awesome!

Laura Kaye