Excel is the most used Microsoft application, but most people don't know about the additional add-ins you can install to improve its functionality even further. Read on to learn more about Excel add-ins and how to install them.

Just like the applications we teach people how to use, our operations are perpetually innovating and improving – and 2021 was no exception.

A perusal of any article about data will lead to the conclusion that in the internet age, data is pretty much everything. See why SQL is so valuable.

What makes Microsoft a market leader is their use of user feedback to drive updates. Today we are going to look at the new features introduced to Power Apps this year and the planned updates.

Nexacu has recently made the switch from printed to digital materials. See why we made the switch and how you can access your Post Course eBook.

One of our recent discoveries is BERT aka the Basic Excel R Toolkit. This is a package for working with the R programming language functions from Excel. It's a wonderful resource for adding functionality to Excel and best of all, it is free!

Organisations are constantly refining how they analyse data to draw actionable insights, and Microsoft's Power BI will simplify this process.

Congratulations to Wade, our very first student to complete the Nexacu Python for Data Analysis Certification!  Wade had no prior experience with Python but has now produced a very impressive final capstone project.

Within a few years of its release, Microsoft’s project became the dominant PC-based project management software. Given the recent release of Microsoft Office 2021, it’s time to have a look at the new features added to MS Project in 2021.

Microsoft is constantly updating and innovating their products – including Teams, the collaboration application that skyrocketed in popularity during the Coronavirus pandemic.

Power Apps empowers employees to use their unique perspective to solve problems – cutting down on third-party costs in the process.

I’ve recently had to do some basic administrative tasks with Excel files. Using Python, I was able to quickly and easily complete tasks that could have otherwise been quite time-consuming and tedious. The examples below illustrate how Python can be used to improve these kinds of processes.

The R package, janitor, contains easy-to-use and convenient functions for basic data cleaning jobs and examining data. Let's take a look at some of these functions.

Structured Query Language (SQL ) is currently one of most desirable and transferable skills in organisations across industries. But what is SQL? and why should you start learning it?

Python users who work in Jupyter computational notebooks have access to an extra collection of commands – known as magic commands. Magic commands are an enhancement of the interactive IPython kernel (used by Jupyter) and make performing common tasks easier than using Python code alone.

The data frame (or DataFrame) is an essential tool for anyone using R or Python to analyse data. They are rectangular or tabular data structures, that hold rows and columns of data, similar to tables in a database or an Excel spreadsheet.