10:12:52	 From CHAMBERSC : apologies, is there a microphone that Phil can use? I can barely hear him
10:22:51	 From CHAMBERSC : we also have an "Automate" tab
10:24:22	 From CHAMBERSC : Rei can you mute yourself? There is an echo
10:30:10	 From Bryden : I have another meeting for the next 30 mins and I'll rejoin shortly
10:30:20	 From LEONARDISK : Reacted to "I have another meeti..." with 👍
10:47:00	 From Jarrett : Reacted to "I have another meeti..." with 👍
11:11:22	 From CHAMBERSC : When inserting individual cells to a table just be careful, it can affect your table
11:14:23	 From Jarrett : Reacted to "When inserting indiv..." with 👍
11:40:47	 From BuckleS : I am here :)
11:40:50	 From CHAMBERSC : Can you review again the covert range option? I didn't understand what that was for and how it works. I tried it on my table and nothing happened
11:44:53	 From Jarrett : Reacted to "Can you review again..." with 👍
11:51:30	 From CHAMBERSC : right click, format cells, choose wrap text?
11:51:59	 From BuckleS : Reacted to "right click, format ..." with ❤️
11:57:56	 From Elizabeth : for those who may not have heard my question, I asked if there was a way to identify / highlight the duplicates before using that function to erase them. There is a way, but you'd have to write a code that more advanced than the scope of this workshop
11:58:34	 From SzylkinI : Reacted to "for those who may no..." with 👍
11:58:39	 From BuckleS : Reacted to "for those who may no..." with 👍
11:58:46	 From SzylkinI : Reacted to "right click, format ..." with ❤️
12:18:27	 From Jarrett : cool! never used conditional formatting before
12:43:22	 From Jarrett : Reacted to "for those who may no..." with 👍
13:36:47	 From Elizabeth : I will work from my office this afternoon, I want the double screen to practice some of the stuff in real time myself!
14:21:01	 From SzylkinI : Reacted to "I will work from my ..." with 👍
15:08:16	 From Jarrett : a conditional list!
15:10:30	 From Bryden : That's a better way to put it Jarrett lol
15:12:36	 From Jarrett : that's a cool idea bryden! never would've thought of that :)
15:26:08	 From Bryden : Reacted to "that's a cool idea..." with 🤝
15:37:32	 From LEONARDISK : We will be taking a 10 minute break now, if anyone has any questions, pop them in the chat and we can address them afterwards :)
15:38:09	 From Derek Donald - DFO : I have the following formula in a excel sheet.  Can you explain a bit the functions in the formula?=IF(ISNA(F5),0,INDEX(IF(RIGHT(F5,1)="L",UnitCostLow, IF(RIGHT(F5,1)="H",UnitCostHigh,UnitCostSpecified)),MATCH(LEFT(F5,LEN(F5)-1),CostCode,0)))
15:39:31	 From Derek Donald - DFO : That's the excel file.
15:52:19	 From Phil Irving : Hi Derek, Let's see... on shared screen
15:56:09	 From Bryden : I'm going to log off, thanks for the class Phil!
16:00:59	 From Derek Donald - DFO : yes thanks.
16:01:18	 From Derek Donald - DFO : that was a long equation I know.  Thanks.