Excel Insights

What is XLOOKUP and How to Use It

Microsoft Excel is a powerful tool that offers a wide range of functions to help you manipulate and analyse data effectively. One of the most versatile and game-changing functions in Excel is XLOOKUP. Whether you're a seasoned Excel user or just getting started, understanding how to use the XLOOKUP function can significantly enhance your data processing capabilities.

Reading glasses in front of computer screens
4 Tips for VBA Excellence

Our comprehensive guide offers four essential tips and tricks to boost your VBA proficiency and confidence. Discover what VBA is, how it empowers you to automate tasks and customise applications, and explore key aspects of VBA programming. Learn how to harness the power of the recorder, embrace a modular approach, enforce variable declaration, and streamline your automation with alert management.

 

How to become a Financial Analyst

A Financial Analyst uses financial data to predict business outcomes which help their organisations make better business decisions.

Excel spreadsheet
How to create Pivot Tables in Excel

Pivot Tables are one of the most powerful tools in Excel. A Pivot Table is a table of statistics that summarises data from a more extensive table. Here’s a quick overview of how to create your own Pivot Table.

Excel sheet drop down list on laptop - Nexacu
How to Create a Drop-Down List in Excel

Take your data entry skills in Excel to the next level with the invaluable tool of custom drop-down lists. Explore this all-inclusive guide that not only introduces a straightforward five-step method but also provides invaluable expert insights and strategies for crafting personalised drop-down lists that will turbocharge your spreadsheet efficiency.

person typing on laptop power bi
How to Copy Data from Power BI to Excel

Excel and Power BI are both incredibly useful data science tools and if you are starting out your career in data science, they will give you a solid foundation. You can get amazing interactive dynamic reports with Power BI but at times you do need static reports that require copying data from Power BI to Microsoft Excel. This can be a confusing process, especially for a beginner...

FAQs about Learning Excel Online

Knowing how to effectively use Excel is a game-changer in workplace productivity, so it's time to ask the question: What is the best way to learn Excel online? Find this and other FAQs here

Mapping data with 3D Power Maps

Discover the art of Excel Power Maps to take your data visualisation to the next level, whilst gaining new and valuable insights in doing so. 

Excel Cheat Sheet
A Microsoft Excel Cheat Sheet
We have compiled a cheat sheet with some quick shortcuts you should make sure you have in your Excel skill set.
Person holding phone and paper with charts
Office 365 – the productivity powerhouse

The team at Microsoft is always implementing new tools to make sure your important data is properly integrated into your digital systems. Read on for three simple, yet smart features that help make this happen.

Microsoft Project Gantt Chart
Easy Gantt Charts in Excel

Tracking a series of related tasks against time is a process we perform often in both the workplace and in other aspects of our lives.

Visual Basic terminology
Excel VBA Terminology

Visual Basic for Applications is a derivative of the programming language Visual Basic. Each Office application has its own particular kind of VBA depending on the objects and operation of the application.

Coins and pens
8 SMART Tips for Financial Modelling

Financial modelling is a skill that requires planning, consistency and a deep understanding of the business problem being modelled. Here are 8 smart tips to get you started.

Learn to code
Why Every Professional Should Code

In an exponentially digitising world it's more important than ever for professionals to learn to code. Nexacu offers leading Excel Macros training.

Excel for Mac
5 Tips for Excel 2016 for Mac

If you are a Mac user and also delve into Excel then read on for some tips and tricks that could save you a ton of time!

Excel table
Applying Conditional Formatting

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.

 

The Most Useful Function in Excel
The Most Useful Function in 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.

13 tips for using excel efficiently from nexacu
13 Excel Shortcuts You Need to Know

If you are looking at increasing your workplace productivity then learning how to use Microsoft Excel efficiently is a great step. We present 13 Microsoft Excel shortcuts that you need to know and will supercharge your skills.


Topics

SQL
css

Contact Us

Why Nexacu?

Valued by Individuals

4.72 / 5
Over 70583 Reviews

Trusted by Business

Procured by Government

Awards and Accreditations

Follow us