Author: Brad Edgar

How to Freeze Rows and Columns in Excel

Excel Tutorial Summary: Freeze Rows and Columns in Excel Learning how to freeze rows and columns in Excel is up there on the list of things you need to learn as an Excel newbie. This simple yet powerful feature allows you to scroll through large data sets, freeze dashboards, charts or pretty much any object in Excel by freezing rows or columns. Freezing rows and columns is especially helpful when you have information / data outside the cells that are displayed on your screen. You can either watch the video located below or you can work through the step...

Read More

101 of the Most Shared Excel Articles You Need to Read

Are you overwhelmed by the amount of Excel articles on the web? If you said yes, then we are definitely on the same page and I’m willing to bet there’s a few or many following behind us. Over the past couple of weeks I’ve set out to find the most shared Excel articles on the web and I’ve decided to put together a list showing you only articles that have been shared 100 or more times. I’ve created this list using an amazing tool called Buzz Sumo which allows you to find the most shared content on the web for...

Read More

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

8 Search Techniques You Can Use Right Now to Find the Best Excel Content On The Internet

You spend a lot of time navigating and searching the internet trying to find high quality Excel content. I know because I’ve been there and it always seems like it takes longer than it really should to find the exact feature, formula or solution to your Excel problems or questions. Trying to find specific Excel skills that you’re interested in learning can become quite a feat. I know and you know that there are a lot of great Excel websites out there with tons of information but sometimes it just comes down to getting your searches just right. In this...

Read More