Posted on

What’s New in MS Office 2013? Here’s a Quick List

Frequent updates and infrequent use of software like Excel can really leave you stumped - that's where Lifetime Membership comes in real handy!
Frequent updates and infrequent use of software like Excel can really leave you stumped – that’s where Lifetime Membership comes in real handy!

At EzyLearn we offer online training courses for MYOB — the #1 Cloud-accounting software — but did you know we also offer training in Microsoft Excel and Word?

Just as we do with our MYOB training courses, we also offer Lifetime access to our MS Excel and Word training courses, which means each time Microsoft releases a new version of MS Office, we update our course content so you’re always totally up to date with the latest versions of Word and Excel.

Keeping Excel in Your Memory

Let’s be straight up here; once you get the hang of Word you probably won’t need to refer back to our course content all that much. Excel, on the other hand, is a different ball game.

In many ways Excel is a lot like algebra or a foreign language: if you don’t use it often, you’ll forget it. Sure, you’ll remember bits — J’adore Dior! E = mc2! — but you’re likely to struggle through your day-to-day if it’s something you rely on heavily at work.

Because many people use accounting software like MYOB, their use of Excel is fairly infrequent. For instance, suddenly trying to create a PivotTable will probably leave most of us stumped! And let’s not forget that by the time most users have mastered how to create macros in their worksheets, Microsoft will have released a new version of MS Office and we’ll be back to square one again. This, in large part, is a key reason why we offer Lifetime access to our training courses— because we, just like you, also forget stuff.

New Features in New MS Word and Excel (in a Nutshell)

Now that Microsoft has released their highly anticipated MS Office 2013, it’s likely you won’t be able to find the ‘Paste Special’ button again, so we’re updating our course content to reflect the new changes.

Here’s a low-down on some of the new features in the new MS Word and Excel:

Word:

  • Open and edit PDF files in Word – finally! Gone are the days of having an additional piece of software installed on your PC to enable this.
  • Threaded review comments
  • Read mode with page turning
  • Alignment guides – hallelujah! Why have they never had this before!
  • Placeholder

Excel:

  • Quick analysis
  • Flash fill – we’ve always had this to an extent, but flash fill just got a whole lot more intelligent!
  • PowerView – for the real Excel pro, but still a welcome addition.
  • New PivotTable tools
  • Improved functionality when opening new Excel windows
  • Recommended PivotTables and charts
  • New chart controls
  • Get a link
  • Publish Excel data to social media – we don’t recommend using this often, because snore. But it’s still great if you want to quickly share your yoy sales results with your Twitter followers or Facebook friends.

So whether you’re using MS Office 2013, 2010 or prior, if you’ve forgotten how to do a VLOOKUP, it’s time you educated yourself in the mystery that is Excel — enrol in one of our Microsoft training courses today!

Posted on 4 Comments

Tabs and Tables make a great resume

Microsoft Word Training Courses - Insert TablesOne of the most popular office productivity programs in the world is almost taken for granted these days as a program that everyone knows how to use, but there is a lot to learn to really master it. We’re talking about Microsoft Word of course, and we’re currently having new training content recorded for Microsoft Word 2010.

You might recall from previous posts that we offer lifetime access to our training courses. You might also recall that our Microsoft Office courses include most versions of the software so you can enrol knowing that all versions are covered. We also include access to beginners to advanced courses all for one low price! That’s our learning guarantee.

You will have the chance over the following weeks to see some of these new videos right here so stay tuned and make sure you subscribe to receive these posts via your email.

You’ll get some insights into tabs and tables. They are extremely powerful Microsoft Word tools that help you make your Word documents look professional. If you get the wording right in your resume and use your Microsoft Word skills to make your resume look good you’ll increase your chances of getting that job.

Tables are like spreadsheets

Even though you often see the borders of a table in Microsoft Word you can change the formatting so that they are invisible and this is a great way to get some structure in the content in your work document while not showing that your using tables. Tabs are also very handy but you need to remember that tabs are paragraph formatting so if you forget to apply them to each paragraph you are working in you might find the whole process very messy. There are also the option of using the default tab stops to make text line up, or setting your own (which we recommend because you can make the text line up as centres or right aligned and even to the decimal points if you are putting a pricelist together).

Formatting your resume

If you are using Microsoft Word to create your resume you’ll definitely make it look better with the use of some structure, after all, it’s the structure and layout that often separates a professional looking resume from an average looking one.  If you are not sure how to create your own resume, let one of our professional partners create a professional resume for you and provide training so you know how to make any modifications yourself.

Discount Coupon for MYOB Training Courses

We also mentioned the discount coupon available to you for our online MYOB training course, but we forgot to mention that the discount coupon actually applies to all courses!