How to Use SUMIF Conditional SUM Function in Excel

Microsoft Excel SUM Functions: SUMSQ – Square and Add Cell Values SUMPRODUCT – Multiply and Add Two Arrays SUMIF – Add with a Condition SUMIFS – Add with Multiple Conditions SUMX2PY2 – Add Sums of Squares of Two Arrays SMX2MY2 – Add Differences of Squares of Two Arrays SUMIF(), Conditional Sum, is a wonderful function that allows you to find the sum…

Read More

How to Write an Issue Case Study

A “case study” is similar to a “white paper” although white papers can be more technically detailed in nature. Simply put, they are both written to convince the reader that something (a product, a service, a company) works. That “something” could be a product/service, the story of how a product/service or method was implemented successfully,…

Read More

How to Write Direct Mail or Marketing Copy for Dentists

Dentists spend a lot of money on advertisement. Especially in large metropolitan centers where competition among medical service providers is high, dental professionals send a lot of direct mail pieces to residential addresses and/or place advertisements and commercials in all kinds of media. Cosmetic and Restorative Dentistry practitioners are prime targets among all dentists for…

Read More

How to Configure Macro Settings in MS Word

MS Word macros can ruin your day if you’re not careful enough. A macro is not necessarily a bad thing. There are many occasions when you need to record a macro and distribute MS Word documents that have a macro embedded in them. However, a “black hat” programmer can insert a macro into a MS…

Read More