Excel University Volume 2 Course

It is with great excitement we announce the immediate availability of Excel University On-Demand, the online Excel training course that teaches the content of Excel University Volume 2 through videos, homework activities, quizzes, forums, and blogs, in a fun, self-paced and social way. Overview Excel University Volume 2 continues exploring the Excel features, functions and […]

Excel University Volume 2 Now Available!

I am pleased to announce the immediate availability of Excel University Volume 2. The next installment in the series covers a task common to accounting and finance professionals: reporting. Since there are many different types of reports in Excel, let’s dig into the details a bit. This book focuses on how to build hands-free formula-based […]

Custom Conditional Formatting Rules

Today, we will look at using conditional formatting with formulas, data validation, and comparison formulas.  Think you are up for it?  Let’s do this thing. Let’s say we have a worksheet that computes the payment of a loan.  We can use the PMT function to easily accomplish this task.  The PMT function requires three arguments […]