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... Read more
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... Read more
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... Read more
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... Read more
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... Read more
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... Read more
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... Read more