My Windows 10 computer wasn’t seeing my phone hotspot.

1. Switch off Windows 10 wifi
2. Change phone name to all letters, no spaces
3. Turn on WiFi.

BOOM! Fixed!

If the Mac version isn't playing, try the Youtube link.   These recordings do not have audio...yet.

The key to dropdown lists is that you need to use the absolute cell references (example: $A$1:$A$3), because you want to ensure that the list always points to the same data fields.

This dropdown list exercise was for a teaching demonstration.  The PC video was recorded with Windows's X-Box recorder (Windows +G), which does not show the pop-up window for the data validation tools.
​

I am not a fan of the lack of clipart in Word, Excel, and PowerPoint 2013 and 2016.  I like the easy access to online images, but I am concerned about violating copyrights and I don't want to feel like I am always connected online.  


Also, teachers know that students can not always have online access.  Clipart ensured that students would find appropriate images even when the wifi wasn't working at school.

My current project is moving the old clipart from 2010 to my new computer.
​

Let's start with some basics.

If you just want a quick view of a running total,  select the numbers and look in the bottom right corner of your screen.

For numbers that will stay in place, you can:
Use the Autosum key on the Home tab or the Formula tab (or add it to the Quick Access toolbar)
Press Alt+11
Use the Quick Analysis tools on the bottom right corner of a selected cell group (or press CTRL+Q)
Make a table (Ctrl+T) and click table rows on the Table Design tool.

When I am teaching Excel, the question of how to apply conditional formatting to other columns comes up a lot, and in the past I solved it with a macro or an =if rule mimicking conditional formatting, and this is still a good solution.

However the clever engineer I am married to showed a me a better, more efficient way,  and that is a golden rule: in Excel, efficiency is everything.

To start, I am setting up a simple spreadsheet.  I have the days of the week in Column A1:A7 and numbers 1-7 in Column B1:B7.

For this scenario, I want to say that anything in column B that is greater than 5 is highlighted.  

Step 1: Make your range a table by pressing CRTL+T at the same time.  This inserts a header row, making the table span A1:B8.
Step 2:  Select your cells that should be affected by the conditional formatting.
Step 3: Create a conditional formatting rule.  I will use anything above 4 will be highlighted as yellow.
a. New Rule
b. =$B2>=4 and the formatting is yellow.  Using the $B keeps Excel looking in row B to find a value in 4.  
Step 3: Modify the rules.  This will include column A.  Go  to Modify Rules to open the Conditional Formatting Rules Manager.
a. The rules should apply to =$A$2:$B$8. Use F4 to get the magical $ to indicate absolute value. 
​

Step One:

a. Cell A1: Type Number of Winners
b. Cell A2 is the number of winners, and this number can be changed depending on how many prizes are available.   In formulas, it is written as $A$2 because it is the only place to look at numbers.

Step Three

The random numbers will always be changing, so copy and paste it either as values with source formatting or (my preference) as a picture so it will be the same every time.

Paste it in another area of the sheet, but press the drop down arrow by the paste and choose paste as values and keep the source formatting or paste as picture.  This is on a sheet called step 3.

If I were doing it, I would paste it on a new sheet as a picture.  That way it is frozen in time and you can name the sheet for that week's contest.
Paste it in another area of the sheet, but press the drop down arrow by the paste and choose paste as values and keep the source formatting or paste as picture.  This is on a sheet called step 3.

If I were doing it, I would paste it on a new sheet as a picture.  That way it is frozen in time and you can name the sheet for that week's contest.