top of page
Search
Katarina McGuckin
Jan 301 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!
3 views0 comments
Katarina McGuckin
Sep 4, 20233 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?...
7 views0 comments
Katarina McGuckin
Sep 4, 20232 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...
16 views0 comments
Katarina McGuckin
Sep 4, 20231 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...
17 views0 comments
Katarina McGuckin
Sep 4, 20232 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...
16 views0 comments
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. ...
21 views0 comments
Katarina McGuckin
Aug 23, 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...
16 views0 comments
Katarina McGuckin
Aug 15, 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....
20 views1 comment
bottom of page