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…
Tag: Excel
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. Here are the…
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…