The Georgia Society of CPAs (GSCPA):
Excel Tips to Set You Apart from the Pack
with Chris Menard

Dates: Tuesday, November 19, 2019
Time:  12:45 pm – 1:35 pm

Chris Menard

Hi, I'm Chris Menard and I'll be your instructor for Excel Tips

I'm a member of the Microsoft Creator team and my public speaking client list includes The Georgia Society of CPAs for over 10 years, the Continuing Education Center for the University of Georgia since 2009, the Executive MBA students at the University of Georgia since 2010, and many others. In my spare time, when I’m not keeping up to date with the latest MS Office 365 features, I provide free support and create video tutorials on software topics and issues. My YouTube channel is approaching 500 training videos and many of my training videos are on Microsoft's YouTube Channel.

Excel iconTopics I will be covering: 
Stock and Geography Data Types, Ideas, keyboard shortcuts, and Tables.
See below some videos with sample topics.
Location: Cobb Energy Performing Arts Centre,
2800 Cobb Galleria Pkwy, Atlanta, GA 30339
Phone: 770-916-2800, Map: Click here to see a map.

 

RESOURCESExcel Icon

Resources and links:

 

Here are some of the topics I will be discussing:

Excel Data Type
Stocks Data Type in Excel

The Stocks data type is one of two new data types in Excel for Office 365. Geography is the other new data type. Both are linked data types since they have a connection to an online data source. Both allow the data to be refreshed automatically. What is awesome is Excel does the conversion. Just type in your data and it will figure it out.

Watch this video

Excel Data Type
Geography Data Type in Excel

The Geography data type is an excellent feature in Excel. When you type in cities, states, or countries, Excel will allow you to convert it to a Geography data type. 
Geography data types have cards that allow you to put in other information such as population, birth rates, leaders, wages, etc. The Geography data type works in Office 365.
The five tips are:
  1. Start typing cities or states, and Excel will want to convert the text to the geography data type.
  2. Overwrite the geography data type. This is handy when you need Rome, Georgia, and Excel wants to use Rome, Italy.
  3. Pull geography data from a website.
  4. Use Tables to populate your header row fields automatically.
  5. Use formulas with geography data types.

Watch this video

Excel Keyboard Shortcuts
Paste Values

Paste Values in Excel is an excellent feature. It copies only the value of a cell, not the formula. When you copy a cell with a formula and paste, the formula gets pasted. Frequently, you want just the value.
 
Paste Values does not copy formatting or formulas. If you copy and paste, and the destination cells contain formatting, paste values will take the formatting.
 
Here are several keyboard shortcuts for paste value:
  1. Alt, H, V, V
  2. Alt, E, S, V, Enter on the Mac this is Ctrl + Cmd + V
  3. Menu key + V
  4. Ctrl + V, Ctrl, V
  5. Create a shortcut on the Quick Access Toolbar (QAT).

Watch this video