Category: LEARN EXCEL FORMULAS

27+ Ways to Teach Yourself How to Become the Excel Guru Everybody Relies On

  Why is it so important to become an Excel guru? Because everybody in the world uses Excel. You can either be the person asking for help or you can be the person helping. The best part about being an Excel guru is that you can bring your skills with you wherever you go. Even if where you’re going isn’t hiring you for your advanced Excel skills, it’s a great icebreaker and you’ll quickly become everybody’s new best friend. Here’s a mini library of ways you can teach yourself how to become the Excel guru that everybody relies on....

Read More

3 Creative Ways to Use Special Fonts to Enhance Your Excel Spreadsheets

How could you use a font to enhance your Excel spreadsheets? I know that it’s tough to believe but special fonts actually offer a ridiculous amount of possibilities when it comes to building visual displays of any nature in Excel. The more you begin to understand Excel and how objects interact, the more use you will find of these silly fonts. When it comes to the office, you’ll be able to take some of these tactics and apply them to your spreadsheets and I’ll guarantee you end up turning some heads (hopefully the people that truly matter). # 1...

Read More

The Vlookup Formula: Why Your Employer Wants you to Know How to Use It (And What You Can Do About It)

SOLVE YOUR BUSINESS PROBLEMS USING EXCEL. Learn how to use Excel and your data to solve your business problems and become the office hero. SIGN ME UP Have you ever looked at a data set and thought, if only I had one more piece of information I could really understand the full picture and make good decisions with this information.  Realizing that you can make this happen is a pretty rewarding experience.  Mature employers realize that this is something that has the potential to truly transform their day to day operations simply by making information that isn't technically available,...

Read More

Excel Tutorial: 3 Tips on How to Create an Automated Budget & Expense Tracker

THIS WEEK’S EXCEL TIPS TIP # 1: Keep Your Dashboard Header Visible Using Freeze Panes TIP #2: Create Buttons in Your Header to Navigate Between Worksheets TIP #3: Use a Nested SUM & IF Formula to Summarize Your Detailed Expenses   THE FEATURED PRODUCT           It always seems that no matter how hard you try, there is always an easier way to do something.  My wife emailed me one day this week asking if I’d be able to build her something in Excel that could handle the tracking of all of her departments expenses and then...

Read More

4 Easy Steps to Using the Excel Option button for Dynamic Dashboards

In business, I often see disputes between the finance and operations departments on which metric is a more important indicator of performance.  Operational leaders (more often than not) like to see their numbers in terms of units/quantities and the finance executives/leaders want to see everything in dollars or currency.  This is where the Excel option button form control comes in handy (note that if you are part of a finance team, you can also use this logic to switch between local currency versus your company’s global standard currency).  I’m going to show you how you can use the option button...

Read More