Hope everyone had a fun and relaxing Spring Break. Have you ever had a PDF that consisted of a table with a list that you wanted to be able to edit? If it was a Word document, you could open it in Word, and it would convert it. Unfortunately, it doesn’t work that way in Excel. However, you can insert a pdf once you’re inside Excel, which will then convert the contents into a table.
This would be useful if you had a list of contacts or a schedule that was in a pdf format, but you wanted to be able to edit it.
Follow the directions below to do this:
1. Open Excel
2. Go to “Data” top tab -> “Get Data” from the ribbon -> From File -> From PDF
3. Locate the PDF from your computer -> Import.
4. Select “Table” -> “Load” (NOT transform data).
If there are two tables in the pdf (as in the image above), this process will need to be repeated. The second table will be added as a separate spreadsheet and can be accessed by clicking on the tab at the bottom of the excel document.
If you would like all the data in one spreadsheet (one table) just copy and paste the data from one spreadsheet to the other.
The data will be imported AND automatically converted to a table. This will allow you to use the drop-down arrows at the top of each column to manipulate your data easily.
Spring Break is just about here, and we just can’t resist sharing a couple of techie online Easter Eggs with you. Tech Easter eggs are undocumented hidden messages or features that the developers have hidden in software. But first, a little reminder about using “Reply all” in your emails. Before hitting “Reply All” on an email, please ask yourself: “Does everyone on this list need to see my response?” I know it is an embarrassing mistake that I have made before. If you hit “Reply all” as your email reply, you may accidentally have it set as your default. Read below for a couple of fun Easter Eggs and some instructions to make sure that “Reply All” is not your default for email replies.
Easter Eggs:
1. In The Edge Browser (yes, we might be promoting this one a bit) type in edge://surf at the top where you type in URLs. You will get a fun surfing game! Before the game starts, type in Microsoft and you will get unlimited lives.
2. I suppose I shouldn’t leave out Google Chrome. If you type in chrome://dino you will get that fun dino game the kids always play when the internet is down. You do have to be in Google Chrome for it to work.
3. The hidden emoji game in Instagram – my daughter told me about this one. Use Direct Message (dm) to send someone an emoji. They can then press on it to open a pong game.
If you like these, click here to see the Easter Eggs I shared last spring.
How to Make Sure Reply All is not your Default
For your online email, open your Outlook email
1. Click on the Settings Wheel in the top right
2. Click on Mail
3. Click on Compose and reply
4. Click on the circle that has “Reply” under Reply or Reply all
Today I can’t resist sharing the history game I found. History buffs and history teachers will love timeguessr.com where you are given a picture, and you try to guess the location and year it was taken.
Jane Rondow, our wonderful SD 71 District Inclusion Teacher (Assistive Technology), has written this week’s text tip on how to change your cursor and the size of your mouse pointer.
Are you using your computer to present, show people how to do things, point out things on websites, do an online meeting or make a how-to video? Draw attention to the things you are showing by enlarging your mouse cursor. This can also be helpful for people with visual Impairments, processing needs or anyone really.
Windows Computer :
1. Tap the Windows key
2. Type “Ease of Access Settings” select this menu option.
3. Select Mouse Pointer from the menu on the left.
4. Slide the change pointer size slider to the right to make it bigger, to the left to make it smaller.
5. Select the pointer colour and contrast
6. If you select the far-right colourful option, you can choose any colour, + Pick a custom pointer colour
*Selecting a High Contrast option like yellow (with a black outline) or black makes the cursor easier for people with low vision needs to see the cursor. Doing small circles with the cursor around or near the area you would like people to focus on helps to gain attention to that area.
LINK Windows Make your Mouse, Keyboard or Other Input Devices Easier to Use
LINK Mac Computer Make the Pointer Easier to see on a Mac