| Course | | |
CECM410
–
Advanced Excel
The ability to collaborate with colleagues, automate complex or repetitive tasks, and use conditional logic to construct and apply elaborate formulas and functions will put the full power of Excel right at your fingertips. The more you learn about how to get Excel to do the hard work for you, the more you'll be able to focus on getting the answers you need from the vast amounts of data your organization generates.
You will learn to:
• Import external data, convert text to columns, remove duplicate rows of data, link and embed objects, export data, and publish worksheets or workbooks to the web
• Create, run, edit, and save Macros
• Use data analysis tools to trace and fix errors
• Create, rearrange, and format a PivotTable, filter PivotTables with Slicers, and create a PivotChart
• Summarize data with list subtotals, nesting, advanced filters and data validation
• Analyze data with Goal Seek, Solver, create and display scenarios, data tables and forecast future values
• Continue workgroup collaboration with features such as locking and unlocking cells, protecting a worksheet, tracking changes, encryption, and checking document compatibility and accessibility
Prerequisites: Please note: Students are advised to complete Introduction to Excel and Intermediate Excel prior to enrolling in the Advanced course. Many students (even those well-versed in Excel) feel behind jumping right to the Advanced level.
|