How do you calculate age using a formula or function in Excel To calculate age in Excel is relatively easy if you know the proper function to use. In this quick example I am going to use the today() function to perform some simple date math. In the below example we have a column of […]
You are browsing archives for
Tag: Office 365
Missing Row and Column Headings in Excel
Microsoft Windows Shortcut Keys
Microsoft Windows Shortcut Keys Reference Card For my students in the Introduction to Personal Computers classes (or any Microsoft software class realy), below is a good quick reference guide for using Microsoft Windows Shortcut Keys. This is very good for all Windows users to have handy as there are many shortcut keys to remember for […]
Excel vLookup Example
Excel vLookup Example While teaching Excel classes over the past few semesters I get many questions on how to perform certain fuctions in Excel. Below is another request for and Excel vLookup example. This is for a student that needed this for real world work. My student had two lists of customers. The first was […]
Office 365: One License, Five Devices
#Office365: One License, Five Devices View: Office 365: One License, Five Devices Also visit our Amazon Local Associates Page
Three Ways the New Office 365 Takes the ...
Excel Date Calculations
How to use simple Excel Date Calculations Several students have asked about Excel Date Calculations. Here is a good quick example to calculate the difference between todays date ( “today()”) and a date entered in a cell. For a real world example, I use this to track the time I follow up on small projects. For […]
Free Online Excel Training
For my students in the Excel classes, here is some Free Online Excel Training. These training videos are from Microsoft and LinkedIn and walk you through many features of Microsoft Excel. The training videos are split up into topics such as Formulas, Functions, Tables, Charts and many others. If you are new to Excel 2016 […]
winmail.dat Attachments
Users receiving Winmail.dat instead of real attachments It seems that some non – Exchange or Office 365 users are getting winmail.dat attachments in emails rather than the actual attachments. I cannot take the credit for this solution as I found it on a technet forum, but I wanted to add my two cents to the […]
Where to get Office 365 for Personal Use
This post is primarily for my students who have subscribed but it also good for anyone that needs Office 365 Personal. I have posted below two options for buying Office 365 Personal The first is for a 5 user pack. This one would be good for a family with children. The second is a single […]