In each Office product there exists a quick access toolbar in the upper left hand corner that is customizable. In this video I will show you how the toolbar works and how to customize it, making common commands easily accessible.
Having email accounts for all students in a school is a very handy feature in Office 365. However sending stuff in mass to them can be tricky if you try to do it in your normal methods. In this video we take the data we built in Excel yesterday and used it to fill a word document with student specific information and then mail it to them. Using the mail merge function in Word we wrote an email and then populated it with our Excel data and mailed it easily. This is a great method when trying to send emails to hundreds or even thousands of people.
In this video I will show you how we can create simple usernames by concatenating users first initial, last name, and 2 digit birth date. To do this we combine concatenate with a second formula that will pull just the first character in a cell and combine it with other data. In the next blog I will take the information and build it into a mail merge using Word and Excel.
The Watch Window is a handy tool that allows you to monitor a cell or a range of cells as you are working in Excel. The watch window will stay on top and constantly update as you work. It is located in under the Formulas Tab and can be adjusted in it's height and width. when you are working with large amounts of data and want to be able to see something specific it is a good tool to work with.
A Pareto Analysis is an analytical technique used to find what few causes lead to the greatest number of problems. The analysis is based on the "80/20 Rule" which states that 80% of the problems are caused by 20% of the possible causes. In our example I will show you how to use it to determine which areas of the TEA M Rubric a faculty see as their greatest weakness. The 20% of the indicators they see as their greatest weakness would then be the areas to focus your teacher training on. For further study you can go to mindtools.com
Sparklines are charts contained within a single cell for a row of data. They create a unique visual analysis for each row of data rather than for the data as a whole. They can be formatted and re-sized to give that quick visual analysis I have mentioned over and over as part of your data analysis model. So in this video I will show you how to create, format, and use them to improve your data analysis .