Are you the type of Microsoft Excel user that loves to add a background cell color? The benefit of color cells is that it makes important information stand out. Another useful feature is that it’s easy to act on the colors. In this tutorial, I’ll show you how to sum colored cells in Excel. Best of all, you won’t need to write any VBA code or use the get.cell function.
Excel
Learn the Benefits of an Excel Custom List
One familiar Excel feature users love is auto-filling a series. Some examples include common lists like months, weekdays, or sequential numbers. In this tutorial, I’ll show you how to create a custom list in Excel that provides similar functionality to the built-in lists. And you can use these in any workbook.
Convert Word Docs to Excel
One item I’ve learned from using computers is that there is usually more than one way to solve a problem. This week two people approached me with a similar problem. They were trying to get a simple, but long address list from Microsoft Word into Microsoft Excel. One tried to use macros and the other resorted to cut and paste. In each case, I thought a simpler solution involved Word’s Search and Replace feature. Here’s Part 1 of a two part tutorial.
How to Convert Word List to Excel
Have you ever received data in an inefficient format? Maybe it was a contact list that looked more like mailing labels. In this tutorial, I’ll show how to convert a Microsoft Word list so you can use it with Microsoft Excel.
Mail Merge Tutorial Using Word and Excel
This tutorial shows how to use an input file from Microsoft Excel as the data source to do a mail merge in Microsoft Word.
Simplifying the Excel Macro Recorder
If you’ve ever wanted to dabble with Excel macros, this tutorial and video on the macro recorder will get you started. Includes a sample workbook link so you can follow along.
Excel Macro Editor Basics
This Excel tutorial is the follow up to the previous article we did on using Excel’s built-in macro recorder. It will introduce you to the macro editor and layout so you can create or edit your own macros. It’s also a great way to learn how the macros work.
Customize Excel Ribbon for Your Needs
One issue I run into with this site is software updates. I’ll be updating an article and low and behold, something is missing or changed. Usually, this is a result of software changes. The area that is impacted the most is the Excel Ribbon. In two articles, I noticed I was missing the Forms button and in the other case, the Excel Developer tab. Both issues are easily fixed when you know how to customize the ribbon.
Excel Slicers Make Data Analysis Easier
Microsoft Excel presents another way to filter data besides autofilters. It’s called Slicers and they work with your Excel Tables or Excel Pivot Tables.
Video: How to Use Goal Seek in Microsoft Excel
Short video showing Goal Seek example in Microsoft Excel.