Continuing Education > Computer Applications & Technology

Excel Level 4

This is an advanced course in Microsoft Excel 2019. Prerequisites are Excel 1, 2, and 3 or equivalent knowledge.Students will learn to: Use Object Linking and Embedding (OLE); Find solutions using Goal Seek; Create one and two variable Data Tables; Create Macro buttons; and Create a Macro that accounts for variable rows. Other skills demonstrated and worked on together in class include how to: Create and Edit Slicers; Create a Query; Create a Dashboard; Use the IFERROR function; Use Index and Match functions; Use Solver; Use Forecasting Methods; and Use Form Controls.

Some Title