The new MOS exam format (for Office 2013) doesn't seek to test any individual Excel skills but, instead, poses a real-world business problem that the student must solve. This is a very welcome change from earlier exams for which it was impossible to "guess" which skills Microsoft actually were going to test (due to very loosely defined objectives).
This is from the Microsoft site:
"The new exam format for MOS 2013 presents a short project that the candidate must complete, using the specifications provided. This creates a real-world testing experience for candidates".
Microsoft advise that Excel Skills are tested in the way that they are taught in our courses - in the context of solving a real business problem. Our teaching method - with every skill taught using an example workbook from the real world of business and commerce - should prove ideal for preparation for your exam. You'll also learn many more extremely useful skills that go well beyond those included in the MOS "Expert" certification.
If you complete our Expert course I know that you will be able to address any real-world business problem for which Excel is an appropriate tool. If you look at some of the real-world business problems posed on this forum by professional Excel users, you'll see that many are extremely complex but that all have been solved using only the skills taught in our course. (The solutions are always cross-referenced back to video and e-book lessons that teach the skills used in the solution) .
I'd suggest that you proceed as follows:
1/ Work through the 2013 Essential Skills and Expert Skills courses until you can complete all of the exercises at the end of each session without referring back to the book or video lesson.
2/ Study the problems posed on this forum until you thoroughly understand the solutions we have provided.
If you do take (and hopefully pass) the test it would be very interesting if you could post details of the project you were asked to complete and we'll provide a worked example of the solution by referring to the relevant lessons in the Essentials and Expert course.
I should also mention that you will receive our own certification of course completion at the end of our course that you can print out and e-mail directly from your control panel (available when you log-in).