2016 Data showing places one can go for a Flu Vaccine in NYC.
Friday, February 28 – Saturday, March 7, 2020
Most of the events are free, or low cost.
The list of events can be found here. It’s nice that the information can be filtered, and it makes it easy to register for events. There is a “Select View button” (in the upper left hand corner) that makes it easier to view the data. However, I found it difficult to compare the descriptions across events.
A favorite event during open data week is BETA NYC’s School of Data. School of Data is a one day event (on Sat. March 7th). It’s a fun way to meet others interested in data and/or NYC and learn too. I’d describe it as low cost. It’s not cheap, or free, but compared to conferences that can cost $1000+ it’s a $55 ticket .
Flip your data with transpose
- Highlight the data range
- Copy the data
- Right Click on the cell where you want to paste the data
- Choose Paste special (use the mouse to paste special)
- Click on Transpose
Let’s See it in action:
(Note: there is also an Excel Function =TRANSPOSE(), That does the same thing but via formula)
What does the Format Painter do?
It allows you to copy the style (color, font etc.) and apply the styling of the cell to another cell. It just copies the style – not the text.
Where do I find it?
The format painter tool is available in the upper left corner of the ‘Home’ Tab in Microsoft Excel. You might already be familiar with single clicking on it.
What does the Tool do?
It allows you to copy the formatting from one cell (or a range of cells) to another cell (or range of cells). It’s especially useful if you have multiple formats applied to cells that you want to repeat else where. It’s copy and paste, but it only copies the format not the actual content of the cell. For example, if you had a cell formatted BOLD, with a blue cell color you wouldn’t have to repeat all the steps multiple times.
What’s the difference between single and double clicking?
When you single click on the format painter (image that looks like a paint brush) it allows you to copy the cell format to one or more contiguous cells ( cells that are next to one another).
When you double click on the painter you can copy the format to non-contiguous cells. So if there are gaps in the areas you want to format use the double click. NOTE: Excel will continuously apply the format until you click on the format painter icon again.