Advanced Excel

Training Hours: 8

Days & Dates: Wednesdays, October 20 & 27

Time: 12:30am – 4:30pm

Trainer: Bill Napoli

Location: Online with Zoom

To enroll in this training, email Jackie Rivera | call: (909) 654-8489 or fill out the online form below.

Summary:

This 8-hour Workshop takes experienced Excel users to an even higher level of proficiency, providing insights and skills that enable students to handle Excel projects beyond the average Excel user’s capabilities. The Workshop is intended primarily for graduates of Bill Napoli’s 24-hour Basic-Intermediate Excel Class, but it also benefits anyone already well-versed in using Microsoft Excel.

Topics:

• Sorting and filtering databases that contain pictures.
• Removing duplicate records when manual intervention is required to select items for deletion.
• Extracting data from a master database in one workbook to a worksheet in another workbook.
• Advanced techniques for working with ranges.
• Advanced filter techniques.
• Changing the order of the columns in a range.
• Quick Analysis shortcuts to everyday tasks.
• Using form controls to create attractive, easy-to-use data entry forms for end-users.
• Using the Text-to-Columns tool to cells containing split fixed width and delimited data into their components for easy sorting and filtering.
• Powerful methods for consolidating data from multiple worksheets into one worksheet.
• Using advanced data validation techniques to prevent invalid data entries.
• Using Formula Autocomplete to speed formula creation.
• Understanding complex formulas using Excel’s Formula Evaluate feature.
• Using the date function to offset days, months, and years.
• Understanding manual and automatic calculation settings.
• Using the Indirect function with intersection range names.

Outcomes

Students gain advanced insights into Excel, enabling them to tackle and complete projects well beyond most Excel users’ capabilities.

Every department needs a “go to” person to tackle and solve advanced spreadsheet design challenges. This Workshop gives students the skills to become those “go-to people.”

There are many ways to create a worksheet for a given purpose. Some are more elegant and efficient than others. Students acquire new skills and insights to design more powerful worksheets that best meet their needs.

Bill Napoli

Workshop Length

This Workshop is presented by Bill Napoli using the Zoom Distance-learning format. Students receive a file from which to print a comprehensive, 95-page workbook that provides detailed explanations of the workshop projects and topics, together with an Excel workbook containing worksheets for all of the projects. The Workshop is 8 hours in length, presented in two 4-hour Zoom sessions.