NRTA Classroom LIVE Spring 2024 Course Description

 

 

 

How to Get the Most Out of Your Computer!

 

Enhance your Excel expertise by sharpening current skills and mastering new ones. Learn super-amazing keyboard secrets, special formulas and features! Learn how to do three hours of work in LITERALLY just five seconds. For real.

These are sessions you do NOT want to miss!

 

Excel Bootcamp for Today’s Commercial Lease Management Professionals

 

Presenter: Norman Axelman, Founder, Advantage Computer Solutions

Course Schedule:

March 26, 2024
2 pm – 3:30 pm EDT – Mastering Excel Segment 1

  • Getting to really understand the spreadsheet concept
  • Navigation and selecting data
  • Freeze Panes
  • Get to really understand Excel formulas
  • Using the Fill feature
  • Formatting
  • Separating data to multiple cells (4 methods!)
  • Q&A

April 2, 2024
2 pm – 3:30 pm EDT – Mastering Excel Segment 2

  • Super amazing keyboarding secrets
  • Putting data together from multiple cells
  • Conditional formatting (very cool!)
  • Why NOT to use ‘Tables’ in Excel
  • The incredible Pivot Table
  • Working with sheet tabs
  • Q&A

April 9, 2024
2 pm – 3:30 pm EDT – Mastering Excel Segment 3

  • Sorting and filtering data
  • Using Find and Replace
  • Hiding / unhiding columns and rows
  • Adjusting row height and column width
  • Removing duplicate records
  • Protecting data
  • Controlling data input
  • Q&A

April 16, 2024
2 pm – 3:30 pm EDT – Mastering Excel Segment 4

  • Macros – Get ready to automate!
  • Quick Access toolbar
  • Special control buttons
  • Using IF statements
  • The amazing VLOOKUP formula
  • Q&A
Register Today!