top of page
Search


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
3 views
0 comments


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
7 views
0 comments


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
16 views
0 comments


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
17 views
0 comments


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
17 views
0 comments


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
21 views
0 comments


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
16 views
0 comments


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
21 views
1 comment
bottom of page