Check Out Our Blog | Academy of Learning

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!

Step-by-Step Guide to Creating a Gantt Chart in Excel

Are you looking for a tool to schedule your tasks, track their progress, and visualise your project’s progress? If so, a Gantt chart is the perfect tool for project management...

How to Subtract in Excel – Cells, Date/Time, Columns, and Percentages

The most basic and often used function is the subtract function. Numbers are everywhere, from calculating salary, budget allocation, inventory management, and sales forecast. The standard arithmetic operations applied to...

How to Make a Graph in Excel: A Beginner’s Guide

Pictures speak louder than words. Visual elements convey a lot of information quickly and effectively. In 2025, the total amount of data is predicted to grow to 180 zettabytes. It...

Learn the Fundamentals of Power Query in Excel

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,...

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

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...

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

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...

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

Whether you're a business owner or student, Excel calculate percentage is an essential skill. Learn how to calculate percentage increase or decrease in values. Profit and loss, interest rates, statistics,...

Create an Absolute Reference in Excel – Beginner’s Guide

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...

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

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...

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

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...

Excel Formulas – List and Guide for Beginners

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,...

3 Key Reasons You Need to Learn Microsoft Office, Professionally

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...