This class teaches you how to gather and analyze data for any industry, such as Manufacturing, Banking, Hospitality or a Non-profit, and various job roles like Sales Account Reps, Finance Analysts, HR Specialists, and Department Supervisors. You will learn how to:
- Create and save workbooks.
- Enter and organize data in worksheets (spreadsheets)
- Calculate data with worksheet formulas and functions (SUM, AVERAGE, COUNT, MIN, MAX).
- Reuse and modify formulas.
- Format text and numbers.
- Apply conditional formatting.
- Optimize worksheet layouts for viewing and printing.
- Manage workbook views and properties.
- Be efficient with many keyboard shortcuts.