Education Specialty Series Lunch

February 21, 2019
11:45 AM - 1:00 PM
 Add to Calendar

Jones, Skelton & Hochuli, P.L.C.
40 N. Central Avenue
Phoenix, AZ 85004
 Directions

Topic: Excel Tips & Tricks
Presented By:  Kerry Bourland, Training at Your Fingertips
Sponsored By: Keyser and Wells Fargo National Bank
Catered By: Conceptually Social

PLEASE COMPLETE this survey upon registering so our speaker can prepare accordingly.  https://www.surveymonkey.com/r/RLTPHBF

More about this session

  • Save time with Function formulas such as Sum, Average, Min, Max, CountIf and more.
  • Get all the columns to print on a page with the Scale to Fit options.
  • Learn how to check for duplicate rows of data and remove if necessary.
  • Use Conditional Formatting to make the important data jump off the page.
  • Join several text strings (Cells) together into one cell with the Concatenate function.
  • Separate data in a single cell such as (Last name, First Name or 100-12345) into separate columns.
  • Use Pivot Tables to summarize large amounts of data quickly (see total billed hours per atty for the year, month or quarter).
  • Learn some quick shortcut keys for formatting data, inserting text and more.

 

Please consider inviting co-workers and other managers in your office interested in learning about this valuable topic.

Most all education lunches can be viewed on our Facebook LIVE Page courtesy of Total Networks (Must be Member of our Facebook Live Group)

**Members who RSVP and fail to attend will be charged a $25 fee.

Tickets

$0.00 Member

$0.00 Sponsor or Member Guest (no charge)

$0.00 Potential Member (no charge)