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…
Category: Microsoft Office Specialist
Is Microsoft Excel Obsolete?
Today’s question comes from Quora: Based on the linked article (Confessions of an Excel addict), do you agree that MS Excel may fade? Why do…
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…
Hello, Animation!
Animation is the heart and soul of PowerPoint. Animation keeps your audience interested and focused on your key points. Animation Effects can be applied to…
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…
MOS Certification
What Do I Need to Know? The Microsoft Office Specialist certification uses computer exams to measure whether you mastered the specific skill sets in the…
Top 10 Tools in Microsoft Word
Where Does Word Fit In? Each of the applications in Microsoft Office has a purpose. Microsoft Excel does Formulas. PowerPoint presents slides, and Outlook manage…
Good to the Last Drop?
Our “Top Ten” Word and Excel courses have a new content release program: DRIP. With DRIP programming, the lessons are released one day at a…
