The OTS Training Team is excited to announce a new training program – Lunch & Learn.

Each month at noon* on Mondays, Wednesdays and Fridays, the team will meet you online to demonstrate a 15-minute technology topic.  The team will stay online for another 15 minutes to answer any questions you have on that day’s topic.

Join as many of the sessions as you like.  There is no need to register in advance.  You can access the session online.

 

March is Excel Month.

Topics will include:

  • Setting up a Spreadsheet
  • Creating a Table
  • Filtering
  • Conditional Formatting
  • Creating a Chart
  • Basic Calculations
  • Viewing Spreadsheets & Workbooks
  • Math Functions (RAND, RANDBETWEEN, SUBTOTAL, SUMIF)
  • Text Functions (CONCATENATE, EXACT, LEN, PROPER, LEFT, RIGHT)
  • Tricks to Working with Functions
  • Lookup Functions (VLOOKUP) and Pivot Tables
  • Protecting Spreadsheets
  • Macros

We look forward to meeting you in the sessions.

 

*You can join the session 15 minutes prior, to conduct a link and audio check. The sessions require speakers. Please call 718.982.2345 if you have any questions.