K2's Excel Best Practices - VIRTUAL

Prerequisites

Fundamental knowledge of Microsoft Office Excel 2019 or newer

Objectives

• List critical spreadsheet design fundamentals
• Identify techniques used to minimize data input errors
• Utilize Excel’s Table feature as a foundational component of spreadsheets
• Identify and implement three different methods for consolidating data
• Utilize various Excel features, such as Go To Special, to solve specific spreadsheet issues
• List and apply four techniques for sharing an Excel workbook and collaborating with others
• Implement different practices for auditing and error-checking Excel workbooks, including Trace Precedents, Trace Dependents, and Formula Auditing
• Identify the advantages of working with Defined Names in Excel
• List and apply six techniques for securing Excel data

Highlights

• Best practices associated with creating Excel workbooks, including managing workbooks
• How to secure Excel workbooks
• Collaboration options and best practices in Excel
• Effective reporting techniques in Excel