Excel Intermediate with Lincoln Property Company

Add to Favorites

Excel 102 Private Session for Lincoln Property Company

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

• Forcing new lines within worksheet cell entries
• Formulas and Functions
  • Formulas (creating & editing)
  • Formulas with Dates
  • Functions

1. 1. 1.  SUM
      2.  AVERAGE
      3.  MIN
      4.  MAX
      5.  COUNTIF
      6.  SUMIF
      7. Functions

• Referencing / Linking other sheets or workbooks
• Absolute & Relative Cell References
• Conditional Formatting
•  Sorting & Filtering
• Creating a Charts
• Keyboard Shortcuts
• Common Errors & How to Avoid Them