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