Excel
Excel Tips and Tricks Flash Fill
Excel Tips and Tricks Importing Data from the Web
Excel Video Series Episode 1: Intro
Over the past year I’ve had a few requests for Excel training. I LOVE Excel! It’s just such a MASSIVE program to teach that I’ve been trying to figure out where to start. Fortunately, I remembered you should always start at the beginning, so that is ...
Excel Video Series Episode 2: Formatting
In this video, we’ll look at formatting!
Excel Video Series Episode 3: File Tab
In this video we look at the file tab. Here we will see how access your files, how to pin files for quick access, how to get templates, and how to access interactive trainings.
Excel Video Series Episode 4: Printing
In this video we will learn about Excel printing tips and tricks! Learn to change the layout and how to fit the whole page on a single sheet of paper.
Excel Video Series Episode 5: Formulas
In this video we look at how formulas work in Excel.
How to Write a Macro in Excel
SHORT CUT ALERT! Did you know you can automate things that you do in Excel!? Watch this quick video to learn how you can save precious time doing repetitive tasks! Life is short. Efficiency is KEY!
Excel Video Series Episode 6: Text to Columns
I have a column of names (first and last) – but I really need to separate them into two columns, luckily, it’s a breeze with the text to column feature in Excel. Watch this quick video to learn the neat trick.
Excel Video Series Episode 7: Flash Fill
If I have two columns that I want to combine I can use this flash fill feature! This one was news to me, so I’m pretty excited about it. Excel can detect what you’re trying to do and hook you up!
Excel Video Series Episode 8: CountIf
What if you wanted to count the number of cells that meet a specific criterion? For example, say I want to know how many people in Family Services answered the challenge question correctly. The easiest way would be to use the CountIf formula. Meaning ...
Excel Shortcut: How to Print Headings on ALL Pages
I love Excel – just when I think I know most of the tricks, I learn something new! Here is my latest: How to print all the headings on ALL pages when you have a doc that is more than a single page long.
How to Submit Local Travel Reimbursement for Mileage
Does submitting your milage for reimbursement seem kind of complicated? Would you believe me if I told you, it’s actually pretty easy!? In this video I sum up the process in about 3 minutes! Vroom Vroom!
How to Add a Signature in Microsoft Excel
Need to sign a document in Excel – perhaps your milage report? You don’t need DocuSign to do that! Its super easy and I’ll show you how to do it in under a minute.