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!

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

How does health affect our quality of life?

17/05/2022

Health has a significant impact on our quality of life, and Canada puts health care as one of its top priorities. Statistics show that it is one of the largest...

Read More

Is a career in Accounting and Payroll for you? Here’s what you need to know!

10/05/2022

If you’re looking for a highly noble career that typically comes with low stress, you might want to turn your attention to the Accounting and Payroll industry. Accounting and payroll...

Read More

Surprisingly Effective Tips for Better Learning

10/02/2022

Learning a new skill is never easy, and internalizing it to heart is even harder. However, it is by no means impossible. In fact, there are many well-known learning techniques...

Read More

The steps to becoming a marketing professional

24/01/2022

A business could have the finest products or offer the best services, but what is the point if no one knows about them? This is where marketing comes in. Marketing...

Read More

How to Identify a Healthy Working Environment?

30/12/2021

How to Identify a Healthy Working Environment? There are many lessons to learn in life. An important one that most people go through is learning to differentiate and identify a...

Read More

Paralegal vs. Law Clerk: What are the Differences?

29/12/2021

  The legal profession relies on the support and assistance of law clerks and paralegals in law firms and courtrooms. These roles are vital to uphold the principles of fairness...

Read More

5 Things You Should Know About Working as a Healthcare Aide or Personal Support Worker in Canada

21/12/2021

Healthcare Aide workers, or Personal Support Workers are one of the most essential members to any healthcare institution or private healthcare provider. They provide personal assistance and support to people...

Read More