Excel Advanced with Lincoln Property Company

Add to Favorites

Excel Advanced with Lincoln Property Company

Topics focused for On-Site Property Managers, Supervisors and Corporate Team Members:

• Watch Window
• Name Manager
• Protecting Worksheets
• Pivot Tables
• Pivot Charts
• Data Validation (Drop Down Lists within Cells)
• Trace Precedents & Trace Dependents
• Transpose / Rotate
• Text to Columns (Separating Text)
• Combining Text
• Charts
  1. Combination Chart
  2. Pie of Pie Chart

All concepts that are covered in the Excel Advanced with Lincoln Property Company can be used in Microsoft Excel, Google Sheets and Smart Sheets. Each participant will receive printed handouts and the Excel Workbook with relevant worksheets covered during the course. The seating is limited to 25 participants, so make sure to sign up early and reserve your seat.

Speaker/Trainer/Facilitator

Julie Irvin Hartman, MBA, CALP, Certified Proposal Manager

In addition to teaching, Excel Advanced, Julie speaks on various other topics.  Book Julie to speak at your next event, tradeshow or create a custom training session.

More Events & Education

Visit the B2G Victory Calendar to access more events & education.

Excel Videos

Microlearning sessions and 20+ Excel Videos for property management professionals can be found on B2G Victory’s YouTube Channel: Excel Playlist.

• Working Screen
• Quick Access Toolbar
• Worksheets vs Workbook
• Cell Editing
• Printing Options
• Freeze Panes
• Format Painter
• Fill Handle
• Formulas
• Functions
  • Sum Function
  • IF Function
  • Count IF Function
  • Average Function
  • Min Function
  • Max Function
• Charts
  • Pie Charts
  • Line Charts
  • Stacked Charts
• Conditional Formatting
• Sorting
• Common Errors
• Keyboard Shortcuts