The Dynamic Duo: vLookUp and IF

The Lookup Function Say your company offers a bonus for meeting sales goals. The bonus will be calculated as a percent of the sales. The...

What Are the Trends in Technology?

Our “Top Ten” Word and Excel courses have a new content release program: DRIP. Has anyone used this technology successfully in online courses? With DRIP...

Absolute Cell References in Excel

This question is from Quora: How do you copy and paste a formula in Excel while changing one cell reference? This is a little lesson...

Excel: Conditional Formatting on Text

Conditional Formatting is an excellent method for highlighting the Text in a spreadsheet. Each word or phrase can have different formatting for the Font and...

The Right Tool for the Task

When something goes wrong, everyone wants to go through the data and find out what happened. The Data Tools are: Sort, Filter, Group and Subtotal. A PivotTable...

Statistical Functions in Microsoft Excel

Microsoft Excel has an extensive set of statistical functions. These functions work well if you select and Name a Range of data. Start Here: Select...

Conditional Formatting in Excel

Today’s question comes from www.quora.com. This is an interesting question! I like to use Conditional Formatting. People have a hard time reading numbers. You can use...

Top 10 Tools in Microsoft Excel

Today’s question is from an Academic Advisor at one of our college partners: “What Skills in Excel are important for Access?” Good Question. Microsoft Office...