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!

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

Learn to Type Faster and Save Time

09/08/2022

Typing used to be something that only those interested in office or administration jobs needed to learn. Now, it’s a must-have skill for everyone, no matter what industry you are...

Read More

The Fastest Typists In The World–Past and Present

28/07/2022

Learning to type fast is one of a few digital skills that can make a difference when you’re applying for a new job or hoping to break into a new...

Read More

Fast Typing Speed – the Key to Improving Work Productivity

19/07/2022

The goal of becoming more productive and efficient at work is a worthwhile quest. Learning how to improve your work productivity can boost all aspects of your job. By doing...

Read More

Pivot Tables in Excel – Getting Started for Beginners

13/07/2022

Table of Contents Excel Pivot Tables - Getting Started for Beginners What Is a Pivot Table and What Is It Used For? How to Create a Pivot Table in Excel...

Read More

XLOOKUP Excel – The Only LOOKUP Formula You Need

08/07/2022

Microsoft added the XLOOKUP function to Excel in 2019. Initially, it was only available in Office 365 (now Microsoft 365) versions of Excel but was also added to the standalone...

Read More

How to Use VLOOKUP With Multiple Criteria

29/06/2022

VLOOKUP is a commonly used Excel lookup formula used to retrieve information from adjacent columns of data based on a particular value. For example, imagine if you had a giant...

Read More

23 Excel Shortcuts You Need to Know

22/06/2022

Learning keyboard shortcuts can boost your productivity and could save you hours each month. Using the keyboard instead of the mouse can be quicker, easier, and more efficient. When it...

Read More

VLOOKUP Example- How to Do a VLOOKUP in Excel

22/06/2022

Table of Contents Introduction VLOOKUP function Syntax Parameters Example Using the IF Condition Using a Wildcard Character Frequently Asked Questions Introduction In simple words, the VLOOKUP function works like an...

Read More

Tools and Materials Needed for Web Design

02/06/2022

Designing a beautiful, responsive website has become much more accessible. Especially in the last few years, with more web design programs and tools released regularly. Web designers must know the...

Read More

LOOKUPS in Excel Explained – A Beginner’s Guide

23/05/2022

LOOKUPS in Excel Explained Lookup functions are some of the most used Excel functions. What is a Lookup? I'm glad you asked. Lookups effectively search for a particular value in...

Read More