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.

CALENDAR TABLE WITH DAX Part.2

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”

Data Visualization with Excel 2016 (Part 3)

Sparklines

Sparkline is not a new feature in Excel. In fact, Sparkline was introduced to Excel since version 2010, AKA tiny chart. It is helps to visualize and highlight the trend of data over a certain period without having all the clutter in it. I love how tiny it is and it simply does one job, showing trends. This tiny chart is so tiny it does not take up a lot of space. It simply fit comfortably within a cell, just a cell is enough for it. Below shows an example of sparklines.


“Sparklines enable us to create visual representations of data with one click. It makes it easier to grasp data, and it’s helping our CFO analyze trends on the spot.” Matt Stuckey, IT Director of Levick Strategic Communications.


Sparklines are located at the last column of the table.

Continue reading “Data Visualization with Excel 2016 (Part 3)”