Group By is an excellent feature in Power Query to group related rows by a column. This is useful when you have multiple entries for related rows and you want to combine them into one row based on a common attribute value.

The process that you follow determines the outcome. Zanshin is a word commonly used throughout Japanese martial arts to refer to a state of relaxed alertness. Literally translated, Zanshin means “the mind with no remainder.”

Power BI and Power Query

Making sound decisions (especially if you’re under pressure) is a skill set that needs developing like any other. This is especially important for those who wish to reach leadership positions.

Why exactly should you attend a face-to-face training, if there is a comprehensive online training? Read this blog to find out why.

Speak with authority; your tone, pace and choice of language will increase your level of persuasion. Even if you’re not 100% confident you need to have 100% faith in yourself to make things happen.  Communication is power. Every time Harvey needs to make a strong point he stands. Move like Harvey Specter and you will be kicking goals in no time.

Outdated Tech Costs You More

In our professional lives and personal lives there will be times when we are forced to step outside of our comfort zones and look like we are doing great things to succeed.

Business Intelligence or BI is an umbrella term that includes the applications, tools, infrastructure and best practices. That enable access to an analysis of information to improve and optimise performance and decisions.

The ultimate outcomes of well-planned continuing professional development is that it safeguards the public, the employer, the professional and the professional’s career.

Share Point Online has a lot going for it in contrast to its predecessors and that should hopefully lead to more people using the cloud based collaboration platform.

Power BI Analytics Tool the Next Big Thing?

Taking a break to focus on your mental health has long term benefits such as higher productivity and positive health outcomes.

Excel crunches numbers very effectively, but it must always be remembered that it is also a communication tool just like Dashboards.

I’m not a Fortune 500 CEO, but I’ve had the fortune of directly reporting to CEOs & Business Leaders in different cultures and in organizations of varied disciplines.

Wondering what SharePoint is all about? We sum up SharePoint key advantages and why its worthwhile getting onboard in our latest blog.

My training diary of the experiences I had at Nexacu's public training.

I’ve been conducting Excel Courses for Excel Consulting for a couple of years now. Excel Intermediate is our most frequently offered course. In that course, Conditional Formatting seems to be the most favorite topic for most groups that I’ve come across.

Concatenate is one of the most effective ways of combining data in Microsoft Excel.

The most common function in Excel would most likely be the SUM function, but our vote is that the excel IF function is definitely the most useful.  This tutorial explains how to use the IF function and how this can become an integral part to simplifying your formula editing.