Merry Christmas and Happy Holidays!
As the holidays approach, our time seems to become more and more valuable as our schedules fill with shopping, parties, travel, and family commitments. Our gift to you in this publication is the gift of time. Below you will find some of our favorite things: time saving tips and hacks to help you fly through those important tasks and get to the fun stuff!
One of Ashley's Favorite Things:
My MOST favorite thing is to save time, increase efficiency and maximize productivity. These little time-saving jewels definitely deliver! Happy Ctrl+Shift+Arrow-ing!
One of Eric's Favorite Things:
Defeating the locked cell
Suppose you are sent an Excel sheet that has locked cells and it has been password protected. Some of the functionality of those cells will not be available. In my case I was unable to use the find command or truncate the data so I had to find a way to get the data to a new unlocked cell. Coping the data from one column to another or one sheet to another didn’t work as it would copy the lock as well. The solution was to concatenate and then truncate. This fixed the problem. This is what worked. I inserted a column with the number 1 in it for every row of data. Then I concatenated it into another column. I then used =RIGHT(B3,LEN(B3)-1) to trim the 1 off the first digit, returning the string to its original form in an unlocked column.
Where can you find the following info for a student?
The number of BBC sessions they were invited to and attended, the average time spent in those sessions, and their BBC attendance rate (for the last week).
Email your RDM with a screen shot of your answer. Correct answer gets you a NERD badge for your signature line!
Previous NERD Badge Recipients
CR: Heather Miles, Data & Accountability Manager, OVCA/ISOK
NR: Heidi Ragar, At Risk Services, OHVA; Honorable Mention: Erica Seybert, NR RAD
SR: Laurie Hebert, 8th Grade Math Teacher, LAVCA
VBA to Save Your Day 12-1:30 CST
Wednesday, Jan. 9th 2019 at 12-1:30pm
This is an online event.
Ashley's virtual office link: Virtual Office
Snow-much fun to be had in the wonderland of VBA! This is a basics for beginners where you will learn key definitions, install the developer ribbon, and record your first macro. We'll also go through some Excel Tricks that are so cool you'll need to bring your mittens. Hope to see you there!
RSVPs are enabled for this event.