WHO SHOULD ATTEND? 

Professionals seeking to use Microsoft Excel more effectively.

WHAT YOU WILL LEARN 

• Saving time writing formulas by choosing named ranges with the Use In Formula command

• Employing the SUMIF function to sum values related to multiple instances of criteria you specify

• Improving the integrity of spreadsheets with Excel’s VLOOKUP function

• Utilizing Excel’s Name Manager feature to review and manage named ranges within a workbook

• Saving time by using the AutoSum formula to sum multiple columns at once with a mouse click or a keyboard shortcut

• Navigating directly to inputs by using Excel’s Name Box, and then returning to the previous location in the workbook via the Go To command

• Building operating budgets quickly based on detailed supporting schedules that provide an audit trail

• Preserving key formulas using hide and protect features

• Accessing free downloadable budget templates that can be customized as needed

• Understanding why it’s worthwhile to build out supporting schedules to break down calculations used in budgets

• Crafting formulas to compute gross margins, projected sales, commissions, and related amounts

• Learning how the Table feature empowers you to improve the integrity of Excel spreadsheets