top of page
Search


Need Excel Help? Schedule Your One-on-One Session Today!
Need Excel Help? Schedule Your FREE One-on-One Session Today!
Katarina McGuckin
Feb 3, 20241 min read
Â
Â
Â


Efficient Excel Hacks
Want to shave off some time in your day-to-day tasks? Check out this post for time saving Excel hacks!
Katarina McGuckin
Jan 30, 20241 min read
Â
Â
Â


Unlock Your Excel Skills with A1 Excel's New YouTube Channel
Special Announcement: A1 Excel has a YouTube Channel!
Katarina McGuckin
Dec 19, 20231 min read
Â
Â
Â


To Chart or Not To Chart?
Hello and welcome to A1 Excel! In today's post I'll go over situations when you'll want to include a Chart to accompany a data summary...
Katarina McGuckin
Oct 22, 20233 min read
Â
Â
Â


Who doesn't like a free product?
Click here to learn more about a FREE Product available now!
Katarina McGuckin
Sep 17, 20231 min read
Â
Â
Â


Excel Investigations: A Quick Checklist
Hello and welcome to A1 Excel! Have you ever had a coworker or your manager give you ownership of a new journal entry, task, or project?...
Katarina McGuckin
Sep 4, 20233 min read
Â
Â
Â


Pivot Table Summary Table
Hello and welcome to A1 Excel! This post will go over how to use a regular pivot table as a summary table. The advantage of having a...
Katarina McGuckin
Sep 4, 20232 min read
Â
Â
Â


A Guide to SUMIFS and COUNTIFS
Hello and welcome to A1 Excel! This post will cover SUMIFS and COUNTIFS which are fantastic for calculating quick and efficient summary...
Katarina McGuckin
Sep 4, 20231 min read
Â
Â
Â


Lookup Formulas: VLOOKUP, HLOOKUP, and XLOOKUP
Hello and welcome to A1 Excel! This post will be a quick reference guide on how to use various lookup formulas. This post will be...
Katarina McGuckin
Sep 4, 20232 min read
Â
Â
Â


Dataset Specifications: Concatenate and Date Formatting
Hello and welcome to A1 Excel! This post will go over basics in dataset specifications that can be accomplished through simple formulas. ...
Katarina McGuckin
Sep 4, 20232 min read
Â
Â
Â


Fundamentals: Error Codes
Hello and welcome to A1 Excel! If you've ever had the experience of working diligently on a formula only to have it result in the...
Katarina McGuckin
Aug 30, 20232 min read
Â
Â
Â


Fundamentals: Cell Splitting
Hello and welcome to A1 Excel! If you've ever had a data list where you needed one portion of the cell rather than the whole detail then...
Katarina McGuckin
Aug 30, 20232 min read
Â
Â
Â


Fundamentals: Conditional Formatting
Hello and welcome to A1 Excel! In this post I'll be going over Conditional Formatting. The main purpose of Conditional Formatting (from...
Katarina McGuckin
Aug 23, 20232 min read
Â
Â
Â


Fundamentals: Formula Formatting
Hello and welcome to A1 Excel! This post in particular is about formatting formulas in such a way that will ensure accuracy in your...
Katarina McGuckin
Aug 16, 20232 min read
Â
Â
Â


Square A1
Hello and welcome to A1 Excel! In this post I will be starting at "Square A1" by going over the basics of how to navigate Excel formulas....
Katarina McGuckin
Aug 15, 20232 min read
Â
Â
Â
bottom of page