Is a certification in Microsoft Office actually worth it?

Microsoft Certification Journey

Microsoft Office comprises the five main Office apps: Word, Excel, PowerPoint, Access, and Outlook. With this productivity suite being used as a baseline in majority industry, it is indisputable why most people tend to opt out of taking professional Microsoft Office certifications. The common misconception is that these applications are not very complex thus do not need to be pursued professionally. This is far from the truth. Although the basic functions require little to no extra learning, the functionality of these applications are more diverse than we know.

What are the Microsoft Certifications offered?

There are three levels of certification that are offered for the Microsoft Office suite being the Microsoft Office Specialist (MOS), MOS Expert, and MOS Master. Each level does not necessarily touch on different aspects of the application but is much rather an indication of proficiency in the usage of these applications. The certifications emphasize on a mastery of usage and not administration nor installation.

It is understandable that not everyone needs to get this professional certification as some are being complacent and sufficient with the basic functions of Microsoft Office. But, there’s a quote that says

“In training, there is no winning or losing, only learning” – Tucker Max,

you can never think upskilling yourself as any kind of waste. Furthermore, with the acquired knowledge, it will be much more than only experience and learning, it will be a plus point in your resume as a professional skill that you successfully obtained.

Is it worth it?

If you are looking to further your career especially in business, you may want to consider taking the Microsoft Office certification. This is because most employers list proficiency in Microsoft Office applications as one of the main hiring criteria when recruiting. If you have a basic knowledge of how to use these applications, you would probably be good to go. Having a certification would definitely boost your chances of being hired. It is always good to have a professional certification to vouch for your skills.

If you are actively using the Microsoft Office applications, you should look into these certifications to help you be more efficient and productive. Cut the time to work out on a simple task, increase your proficiency in the Microsoft Office applications. It will not only speed up your work process but also improve the quality of your work. Most companies are keen to send their employees for certifications, especially those that brings most benefits to their everyday work.

Look into the right certification that suits your job responsibilities, skill level and go for it! It will be one of the best decision you make for yourself.

Power User vs Top feature in Pivot Table – Part 4

Sort by your report other than A to Z

In the previous section I’ve talked about how to sort or filter your report. But in this time, it is slightly different. You might have a certain arrangement of how you would like your report to be. Not everytime you would want to sort the report in the most ordinary way. You may have a few items that you would like to be listed at the top and some to be at the bottom. There are just a few ways for you to achieve how the way that you wanted to. Let’s check it out:

a) You can use the drag and drop way to arrange the item. This is how you can do it:

Continue reading “Power User vs Top feature in Pivot Table – Part 4”

5 Tips For Improving Collaboration

So how do you deliver the best of modern collaboration, while reducing the complexity challenges? An all-encompassing suite of collaboration tools that enables productivity more effectively than an assortment of tools. When your team has tools that work together seamlessly, everybody wins. Not only will employees be more productive, but you will feel confident knowing every tool is supported and secure. An integrated collaboration suite will provide the strong technology support that your teams need.

Here are five tips on improving workplace collaboration:

  • Save time and increase productivity
  • Lower costs and reduce complexity
  • Ensure end-to-end security and compliance
  • Scale at your own place
  • Control the back end

Get this free e-book to learn how to improve your workplace collaboration and do check out our Microsoft 365 certification courses.

Microsoft 365 Training & Certification

5 Faces of Today’s Employees

In recent years, we can see workforce changes with more Millennial employees, remote working has become common and collaboration tools have expanded far beyond email and conference calls. However, adopting too many business applications may cause productivity loss, cost and security risks.

How do you give employees the variety of tools they want while meeting the security and productivity needs of your organisation? Look at the 5 examples of employees with different work styles to understand how they want to collaborate:

  1. Victor, Head of Finance – Works at company headquarters
  2. Wendy, CIO – Works at company headquarters
  3. Miklos, Social Media Specialist – Works at company and from home
  4. Renee, Business Development – Works from the road and in the office sparingly
  5. Pia, Independent contractor – Works remotely from a home office

At the end of the day, your entire team still needs to work together. With Microsoft 365, we bring your diverse team closer together with an integrated suite.

Download this e-book to understand more on different working styles of employees and how you can enable your employees to use the tools that work for them, without compromising security, productivity or budget.


Power Pivot Calendar Table with DAX function

Alright, you can see how naggy I can be if you have read my last article. In the last article I talked about how important it is to create a calendar table in Power Pivot. It is almost compulsory for this table to exist while you are data modelling with Power Pivot. Well, you can see how I am still a bit reserve (I love saying almost) when I make certain statement. Reason is because somehow there will be some trolls who will jump out and argue with the statement I made. Anyhow it is very subjective still because you know with how the way Microsoft launch new updates and make changes every now and then, I better be a bit reserve.

Nearly all analysis and reports involve the comparison of what’s going on from certain time to time, what happened last year, let’s compare the data from year to date and I can go on and on and on. No matter what sort of data that you’re collecting, almost all the facts data are collecting data base of date and time. With this calendar table, you will be able compare base on fiscal year, quarter, MonthNum, Fiscal Month and others. Continue reading “CALENDAR TABLE WITH DAX Part.2”