This course will start with a brief review of basic concepts learned in Level 1 and build on those skills learned. Unless otherwise requested, the primary focus of this course will be focused on Excel. Other elements of the Office 365 suite can be integrated upon request. Please contact Dr. Passerini to discuss the addition of other course elements of the Office 365 Suite.
Upon completion of the course, participants should:
- develop a solid understanding of Excel Formulas & Functions, along with more advanced tools and concepts
- enhance skills in using tables, managing data, charts and SparkLines
- develop more advanced skills with Tables - working with records and advanced filters
- be able to use more advanced Data Tools in Excel - Text to Columns - Flash Fill - Remove Duplicates - Data Validation - Consolidate
- use more advanced skills with Charts in Excel - Trendlines - Error Bars - Working with Axis Options - Advanced Chart Formatting
- understand how to record and play Macros