This gallery contains 12 photos.
A loan amortization schedule can be very helpful when calculating the cost of a home loan. You can follow these steps to create an Excel 2010 amortization schedule. Start Excel 2010. Choose File, New Enter “Amortization” in the search box … Continue reading
This gallery contains 8 photos.
Our October 2nd blog post was about How to quickly find duplicates in Excel. This week’s post shows how to quickly remove duplicates in Excel. Suppose, like last time, that you have a long list of 5406 movies as shown … Continue reading
This gallery contains 1 photo.
Have you ever had a long list of items and you need to quickly identify which ones are duplicates? Thankfully, Excel’s Conditional Formatting feature makes it easy to quickly find duplicates in Excel. Open your Excel file and highlight the … Continue reading
This gallery contains 9 photos.
How to produce a family calendar in Excel Microsoft Excel has many templates that you can download for free from Office.com. In this blog post we demonstrate how to produce a family calendar in Excel 2010 using one of these … Continue reading
This gallery contains 1 photo.
Have you ever had someone tell you they know Excel? Of course, one might ask, “What does it really mean to say you know Excel?” It is true that the program has so many features that it is almost impossible … Continue reading
This gallery contains 5 photos.
Last week a friend of mine was doing some data entry into a large spreadsheet that had a lot of columns to it. She found it a bit cumbersome to enter the data going across in the spreadsheet. Her question … Continue reading
This gallery contains 5 photos.
This is the third blog in a series about creating macros in Excel, Word and other applications within the Microsoft Office. This article is about Understanding Macro Code. Understanding Macro Code VBA is a Language Many people, after learning how … Continue reading
This gallery contains 2 photos.
Recently, I was asked by one of my Excel students if there was a way to insert a date on their spreadsheet that doesn’t automatically update. The answer is “yes”. They were already familiar with the date function =TODAY(). Here … Continue reading
This gallery contains 5 photos.
This is the second blog post in a series about creating Excel macros, Word macros, and other macros for applications in the Microsoft Office. The big lie: Many people have been told that creating a macro is easy. They are … Continue reading
This gallery contains 2 photos.
This blog post begins a series of articles about Microsoft Office macros. Today’s article discusses what a macro is and how to run a macro. What is a macro? The following definition and description of macros comes from our “Excel … Continue reading
