Live Lectures: Excel Date and Time
DATE and TEXT are what Excel does best. We use Dates to run a business. Here are some useful formulas to get the DAY, MONTH,…
Category: Excel
Live Lectures: Logical Formulas
We use Dates to run a business. Here are some useful formulas Read more
Statistical Functions in Microsoft Excel
Statistical functions work well if you select and Name a Range of data. Read more
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
Useful TEXT Formulas
Another group of formulas you may find useful are ones that work with TEXT. Three come to mind. The UPPER function formats all of the... 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
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... Read more
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... Read more
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... Read more
