Calendar of Events

Excel 101: Introduction to Spreadsheets

12/07/2018, 10:00 AM to Noon

No location provided

Amy Davis adavis@msbankers.com 601-948-6366

Description:
Excel 101: Introduction to Spreadsheets


Presented by David Ringstrom
Friday, December 7th, 2018

10:00 am - 12:00 pm CT

COVERED TOPICS
  • Gaining control of long lists of data by filtering instead of sorting.
  • Getting a jump start on spreadsheet projects by using free, prebuilt templates in Excel.
  • Mastering Excel’s order of operations for mathematical formulas.
  • Minimizing effort in Excel by only selecting cells when necessary.
  • Separating first/last names into two columns without using formulas or retyping.
  • Getting an overview of the different types of files you can create in Excel.
  • Using Text to Columns in any version of Excel to quickly separate city, state, and ZIP code into separate columns.
  • Managing cumbersome lists of data using the Table feature.
  • Learning how the Table feature allows you to transform filtering tasks.
  • Getting oriented with Excel’s grid of rows and columns.
  • Identifying duplicates in a list using Conditional Formatting.
  • Bringing Excel’s green error-checking prompts under control by managing the underlying rules.
Register here