AOLCC Blog

Useful news, advice, tips and resources

Welcome to the AOLCC Blog

Join us as we discuss career development, resume and job search tips, upskilling and much more. This section is full of resources that we think you’ll find useful in every step of your academic and professional journey.

Any specific topics you’d like us cover? Shoot us a message!

Learn the Fundamentals of Power Query in Excel

31/01/2023

The digital world has generated huge amounts of data in every industry. Data handling is intricate as it contains and conveys information that helps build intelligent systems or frameworks. Planning,...

Read More

How to Find and Remove Duplicates in Excel – A Beginner’s Guide

27/01/2023

Almost every organization and business uses Excel spreadsheets to store their data about employees, clients, and projects. Excel offers versatile tools and features for data storage, manipulation, and analysis. You’ll...

Read More

How to Freeze Panes in Excel and Other Options to Improve Readability

24/01/2023

An Excel spreadsheet has data that extends to many rows and columns. When you scroll down or move sideways, the row header and the first column are hidden, sometimes making...

Read More

How to Calculate Percentage in Excel – An Easy Step-by-Step Guide

02/01/2023

Whatever your primary reason for using Excel, percentages are likely to be crucial to your work. Profit and loss, interest rates, statistics, discounts, comparing quantities, and tax calculation all require...

Read More

How to Compare Two Columns in Excel – Easy Guide

29/12/2022

In Excel, there are many instances when you need to compare two columns. It is simple to do when you deal with small tables, but it gets more complicated when...

Read More

Create an Absolute Reference in Excel – Beginner’s Guide

15/12/2022

An absolute cell reference in Excel is helpful for when you are copying a formula into multiple cells. In Excel spreadsheets sometimes you want a cell reference to stay the...

Read More

Beginner’s Step by Step Guide to Enabling Macros in Excel

29/11/2022

Macros are small, simple programs in Excel that can automate common tasks. A macro is a series of commands, such as VBA codes, designed to automate a complex or repetitive...

Read More

How to Create a Drop-Down List in Excel – Easy Guide

15/11/2022

The drop-down feature in Excel allows users to select an item from a list instead of typing their values. Users can select text, numbers, or values from a list of...

Read More

Excel Formulas – List and Guide for Beginners

01/11/2022

Learning Excel formulas is a must when you work with data. Excel is used in all industries for its versatility and popularity. Excel is a go-to tool to store, manage,...

Read More

3 Key Reasons You Need to Learn Microsoft Office, Professionally

18/10/2022

Microsoft Office is a collection of software programs developed by Microsoft. It offers Word, Excel, PowerPoint, Outlook, Access, Publisher, and OneNote. These programs are used for personal, financial, research, and...

Read More

Finding Excel Correlation Formula – Complete Tutorial

26/08/2022

The Excel correlation formula is used to find a mutual connection between two or more data sets. In statistics, a value between -1 and +1 describes how strongly two variables...

Read More

Slicers in Excel – What They Are and How to Use Them

18/08/2022

Slicers in Excel make tables appear interactive and can help you visualize the same data with different criteria. The pivot table summarizes the entire table in a report, and slicers...

Read More