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 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...
Read MoreHow 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...
Read MoreHow 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,...
Read MoreCreate 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...
Read MoreBeginner’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...
Read MoreHow 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...
Read MoreExcel 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,...
Read More3 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...
Read MoreFinding Excel Correlation Formula – Complete Tutorial
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 MoreSlicers in Excel – What They Are and How to Use Them
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 MoreLearn to Type Faster and Save Time
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 MoreThe Fastest Typists In The World–Past and Present
Having the ability to type quickly can have a significant impact on your job prospects and career advancement, especially if you're aiming to break the world record typing speed. Mastering...
Read More