Excel, Is It Worth It?
Is it worth it to get certified in Microsoft Excel? Two images say it all. Jobs that require Excel: Hot jobs in O’Net that require...
Category: Excel
Microsoft SWAY: Almost Useful
Microsoft, did anyone test the User Interface of the new SWAY product? I appreciate some of the programming but Yikes! what a difficult program to...
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...
Add Excel Chart to PowerPoint?
Charts and Tables are both used to display data in a PowerPoint presentation. A Table is a fundamental method for organizing information into Rows and...
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...
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...
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...
