DataByte

December 2018

Merry Christmas and Happy Holidays!

Download the file below and enchant your desktop with a sparkling Christmas tree.
Big picture

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 Paula's Favorite Things:

Status Bar

https://www.screencast.com/t/davYHaFmxvh

Get a count, sum, average, minimum or maximum without using any formulas or pivots

One of Ashley's Favorite Things:

Keyboard Shortcuts

https://www.youtube.com/watch?v=_c8MLJi2Hcg


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 Kristina's Favorite Things:

Email Button/Quick Access Toolbar in Microsoft Office Applications


https://www.screencast.com/t/Y5hRzvMlQK

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.

Big picture

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

Big picture

VBA to Save Your Day 12-1:30 CST

Wednesday, Jan. 9th 2019 at 12-1:30pm

This is an online event.

Join NRDM Ashley Ego in an introduction to Visual Basic for Applications.

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.

Beauty & the Sheets

https://www.youtube.com/watch?v=OrwBc6PwAcY

Your Regional Data Managers

Ashley Ego

Northern Region

HHPA | HA-Ind | HVAM | INDLS | ISIN | ISMI | ISPA | ISWI | MEVA | MGLVA | MVCA | OHVA | WIDCA | WIVA

Eric Hasper

Western Region

CAVA (Fresno, Kings, Los Angeles, Maricopa, San Joaquin, San Diego, San Mateo, Sonoma, Sutter), ISCA, iQLA, NVVA, GBVA, NVDCA, NVPA, IDVA, ITCA, ORVA, ISORPH, CVA, ORDCA, WAVA, ISWA

Kristina St. Clair

Southern Region

ALVA| ARVA | CASC | FLCCA | FPCSO | GCA | LAVCA | NCVA | SCVCS | TNVA | VAVA |

Paula Mobley

Central Region

AZVA, ISAZ, CODCA, CPOA, PPOS, IAVA, ISKS, ISKA, KSVA, ISMN, IQMN, MNVA, NMVA, ISOK, OVCA, TOPS, TVAH, UTVA, UTVA-PT, WYVA