CMPE24 — Excel Advanced
<strong>THIS IS A NONCREDIT COURSE</strong> Customize your workbook by applying conditional formatting, adding data validation criteria customizing menus and toolbars, creating and editing a macro, and grouping and outlining structured data. Work with multiple workbooks to create a workspace, consolidate data, link cells, edit links, export/import XML data with XML, and create a Web query. Collaborate with other Excel users by protecting, sharing, merging, and tracking changes. Chart non-adjacent data, modify chart items, create a trendline, and use multiple graphic objects to enhance your worksheet. Prerequisite: Excel Levels 1 & 2.