Statistical Functions in Microsoft Excel
Statistical functions work well if you select and Name a Range of data.
Tag: Excel
Dazzle Them with Data!
A sunburst chart is a dazzling display. However, the data has to be organized in a particular way Read more
Date and Time Formulas
Many professions- sales, retail, medicine, law, business-are date driven. Here is a Table that shows some of the Date Formulas. Four Useful Date and Time... Read more
The Dynamic Duo: vLookUp and IF
Here is a YouTube video that demonstrates all of these steps that you can watch if you wish: Intermediate Excel: Using Lookup Tables The Lookup... Read more
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
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
