In my opinion, the biggest benefit of using Excel is the ability to use formulas to do incredible things with your data. You don’t need to use any fancy functions or keyboard shortcuts to be really great at Excel – as long as you have a well-formatted spreadsheet that utilizes some key formulas, you will look like an Excel wizard. Here are 20 of my favorite formulas.
When I was a student, I thought Excel was something that only accounting majors used to keep track of their interest and dividends, or something. While that is true, Excel has the ability to make almost any job easier and more efficient.In this post, I’m going to share with you something I use in my job literally every day – my Excel social media calendar.
Okay, so we’ve got some of the basics and now it’s time to dive into a real tutorial. There are many formulas that are incredibly useful, and I’d like to explore some of my favorite in the next series of posts. For this first post, I’d like to return to the magical realm of Harry Potter to demonstrate the power of SUM.
Here’s the end goal for this post: I hope that you will learn one trick that will impress your boss.
I mean, that’s the goal for this blog in general, but let’s focus on one thing at a time right now – keyboard shortcuts.
Let’s talk data for a second. Data can be overwhelming.
Luckily, Excel is primed and ready to make interacting with data as easy as possible – if you know the tools that you need to work with. Sort and Filter can help you got your data in order in no time – basically like magic.
Let me let you in on a little secret: you don’t need to do any math to use Excel. What magic is this, you ask? No magic my friends. Just formulas.
Does Excel feel like “a tale told by an idiot, full of sound and fury signifying nothing”?
Don’t panic. You are not alone. We are going to figure it out together. We’ll reduce that Excel-based sound and fury, so you’ll be going from feeling like Benjy to Dilsey in no time!
Get introduced to the basics of Excel with Excel for English Majors.
“So, what are you going to do with your English degree?”
I bet you’ve gotten this question. I bet that you hear it echoing in your mind as you stare at your resume, thinking to yourself “Do I have any skills that are valuable to employers?”
Let me answer that for you – yes. You do. English majors can do anything. Even learn Excel.
Excel for English Majors 