Zoom Call 6.06.23 Craig Daniels  Tech Smorgasbord

Real Estate Agent with Mapleridge Realty, CT 203-206-0754 REB.0759001

Zoom Call 6.06.23 Craig Daniels  Tech Smorgasbord

Zoom Call 6.06.23 Craig Daniels  Tech Smorgasbord

The Zoom call this week was a learning lesson with Craig Daniels on using Excel spreadsheets. He initiated the tutorial by preparing a list of attendees with names only and offered a link to straw poll where one could get details on using spreadsheets.


This was essentially a poll to determine people's familiarity with using spread sheets.

Spread sheets are a useful tool for assembling data. People are familiar with the terminology of spread sheets and also Google sheets. Google sheets are kept online and spread sheets can be kept in document files to be added to at a later date or to be printed out and shared. The file extension can be seen as .xls unlike a word file that has a file extension of .doc

He then shared a link to a Google sheet on screen and each attendee completed the details of their names in the spaces provided. He allowed each editor access to do this. This was a new feature to me as no other Zoom call had been this detailed in the interaction.

The call continued with Craig showing how the spread sheet can be cleaned by extending spaces to fit text, deleting extra rows, and offering a professional looking spreadsheet. In the photo above, it is highlighted by a circle.

Blank rows can be deleted by highlighting several rows and just raising it to meet the next full row.

This is shown with the blur in the empty rows.  It can also be done by grabbing the edge of the box on a particular row and moving it up to the desired area.



He then talked about the way a full sheet would be tough to read as all rows and columns are the same.

He discussed conditional formatting.  It can be done by creating a rule for the sheet such that a particular word may be the key for the sheet to apply a selected color to make the data stand out from the rest.

He also offered that through the wonders of YouTube, all of his discussion could be detailed with video to get better acquainted with the process.

A case study using his stats page on ActiveRain was used to demonstrate some of the features of formatting a spread sheet.  He exported all of his data onto a blank spread sheet. It came up as a wall of words separated by lines. Using his scribe, he began to widen the columns to allow for easier reading of the data. This was accomplished by sliding the separation bar of each column right to widen the columns.  This is shown in the photo above.

If one were to look at the alphabetical column headers and the line that separates, E|F, by placing the scribe on that vertical separation bar, the entire column width will be changed to whatever is desired.

He then briefly discussed converting all of the data on the spread sheet into a table format as it would be easier to view. This he did by hitting Control T, which created a shaded box around all of the data with headers as well. The different commands would allow for color shading the rows as well.


Zoom Call 6.06.23 Craig Daniels  Tech Smorgasbord

As a way of demonstrating further some of the abilities and uses of a spread sheet, he set up a file to be used to purchase a new laptop. 

He started by selecting a model. Then adding a camera as well as an extra large screen which was a 24" monitor. This also required an additional cable.

To complete the wish list of items, he added a webcam. He set all up on the spread sheet and included the necessary taxes for each item. Now came the time to total it all up and as people have an issue with creating formulas, he offered his shortcut.

Setting up format, he highlighted a number and using the toolbar, hit the dollar sign symbol, $, and the numbers became prices. 

In the cell below, he added the location where he found the computer and after including the site, he added a hyperlink to the Amazon, Control K, and the location of the computer was included on his spreadsheet so he could easily find it when he wanted to buy it.

Now to make the calculations easy, he highlighted the numbers he wanted to add in a row or column, and from the tool bar, found Auto Sum. If one were to see the calculations, the total was shown in the text bar at the top of the spread sheet..


Craig is most generous with his knowledge and shared it on the call.

I had issues with an angry chihuahua and apologize for not offering this post sooner.

Zoom Call 6.06.23 Craig Daniels  Tech Smorgasbord

Posted by


Edward (Ed) Silva
Broker Associate

Serving Central Connecticut Sellers and Buyers

My Blog
Email Me

C:  203-206-0754
Call or Text

O:  203-758-6440


Do you know anyone who is behind on their mortgage and doesn't know what to do? I may be able to help them. I am an experienced Short Sale Broker

Short Sales in Connecticut


Search all active Connecticut listings



Comments (17)

Dorie Dillard Austin TX
Coldwell Banker Realty ~ 512.750.6899 - Austin, TX
NW Austin ~ Canyon Creek and Spicewood/Balcones

Good morning Ed Silva,

Thank you for the recap of a wonderful presentation by Craig Daniels! I was on it but had to enter late and was interrupted with several pressing calls.  Spread sheets are a useful tool for assembling data and I so appreciate Craig being so generous with his time and knowledge.

Jun 09, 2023 06:40 AM
Bill Salvatore - East Valley
Arizona Elite Properties - Chandler, AZ
Realtor - 602-999-0952 / em: golfArizona@cox.net

Great information. Thanks for sharing, enjoy your weekend. Bill

Salvatore Arizona Elite Properties.

Jun 09, 2023 07:16 AM
George Souto
George Souto NMLS #65149 FHA, CHFA, VA Mortgages - Middletown, CT
Your Connecticut Mortgage Expert

Ed I use Excel a lot, so Craig's Excel tips are going to be real useful for me.

Jun 09, 2023 07:29 AM
Roy Kelley
Retired - Gaithersburg, MD

Thank you very much, Ed, for your report on this successful Zoom session.

Jun 09, 2023 07:35 AM
Lawrence "Larry" & Sheila Agranoff. Cell: 631-805-4400
The Top Team @ Charles Rutenberg Realty 255 Executive Dr, Plainview NY 11803 - Plainview, NY
Long Island Condo and Home Specialists

A fantastic recap Ed of the presentation by Craig Daniels! Spreadsheets are invaluable for organizing data. Would have liked to have been on the call.

Jun 09, 2023 08:11 AM
Joan Cox
House to Home, Inc. - Denver Real Estate - 720-231-6373 - Denver, CO
Denver Real Estate - Selling One Home at a Time

Ed, I have SEVERAL excel spreadsheets for just about everything, but sad to miss this Zoom call.   Craig is very nice to share his knowledge.

Jun 09, 2023 08:43 AM
Carol Williams
Although I'm retired, I love sharing my knowledge and learning from other real estate industry professionals. - Wenatchee, WA
Retired Agent / Broker / Prop. Mgr, Wenatchee, WA

Hi Ed,
I always learn from Craig's presentations. He gave us a lot of great tips.

Jun 09, 2023 11:10 AM
Jeff Dowler, CRS
eXp Realty of California, Inc. - Carlsbad, CA
The Southern California Relocation Dude

Thanks for the recap, Ed. I use spreadsheets fairly regularly but there's a lot I didn't know and this was a big help. Craig really IS a terrific tech resource!


Jun 09, 2023 11:46 AM
Myrl Jeffcoat
Sacramento, CA
Greater Sacramento Realtor - Retired

I am certain all who were able to attend, benefitted from doing so.  Thanks for the recap.

Jun 09, 2023 02:22 PM
Myrl Jeffcoat
Sacramento, CA
Greater Sacramento Realtor - Retired

CONGRATULATIONS Ed, on having this blog FEATURED in the Old Farts Club group!  

Jun 09, 2023 02:28 PM
Laura Cerrano
Feng Shui Manhattan Long Island - Locust Valley, NY
Certified Feng Shui Expert, Speaker & Researcher

I guess we can think of it as a party but with business at hand. I suppose that works good luck everybody.

Jun 09, 2023 02:40 PM
Sheri Sperry - MCNE®
Coldwell Banker Realty - Sedona, AZ
(928) 274-7355 ~ YOUR Solutions REALTOR®

Hi Ed,

Craig has excellent knowledge to share.  I had to laugh about the "angry Chihuahua."  It seems that Chihuahua is really getting around ActiveRain! LOL

Jun 09, 2023 02:59 PM
faye schubert
Retired - Branson, MO
Living the Branson Lake Life

I love Google sheets as I can access it easily on my phone. Need to review the tips  you presented, to better manipulate the columns.

Jun 10, 2023 05:25 AM
Brian England
Ambrose Realty Management LLC - Gilbert, AZ
MBA, GRI, REALTOR® Real Estate in East Valley AZ

Wow, I could have learned a lot, I always enjoy learning something new from Craig Daniels he always provides us with great tips and tricks!

Jun 10, 2023 05:40 AM
Nina Hollander, Broker
Coldwell Banker Realty - Charlotte, NC
Your Greater Charlotte Realtor

Excellent recap, Ed... I don't use excel very often, but I did pick up a few tidbits from Craig that would be useful when I do so.

Jun 10, 2023 05:55 AM
Jerry Newman
Brown Realty, 210-789-4216, - San Antonio, TX
Texas REALTOR, San Antonio Military Relocation

Sorry, I missed Craig's class this week. Something came up at that time, but I will keep this information handy as I am not good with using spread sheets.

Jun 10, 2023 09:19 AM
John Juarez
The Medford Real Estate Team - Fremont, CA

I sat in on this call and it was definitely worth the time spent. I did learn more about Excel than I already knew. I also had it reinforced to me that there is so much in Excel and in general technology that is still beyond me.

Jun 20, 2023 07:27 AM