| Course | | |
CECM408
–
Introduction to Excel
Organizations rely on data for decision-making, but the increasing volume of information makes it challenging to manage. Excel can help you organize, calculate, analyze, revise, update, and present your data in ways that will help the decision makers in your organization steer you in the right direction.
You will learn to:
• Create, save, and navigate worksheets and workbooks
• Enter and modify data, use simple formulas, and features like sum, undo/redo, and smart lookup
• Edit worksheets using various methods, including drag and drop and adjusting column/row sizes
• Format worksheets with alignment, borders, colors, and managing visibility of rows/columns
• Prepare worksheets for printing by defining print areas and adjusting page settings
• Insert and copy formulas with different reference types and use functions
• Modify workbooks by managing worksheets effectively
|
CECM409
–
Intermediate Excel
Build upon the foundational knowledge presented in the Introduction to Excel course and start down the road to creating advanced workbooks and worksheets that can help deepen your understanding of organizational intelligence. Analyze massive amounts of data, extract actionable information from it, and present that information to decision makers.
You will learn to:
• Create and modify tables and charts
• Add pictures, shapes, WordArt, SmartArt, and format drawing objects
• Work collaboratively with others through emailing a workbook, converting worksheets to web pages, inserting hyperlinks, and viewing and editing comments
• Use functions such as IF, Nested, PMT, FV and auto calculate
• Understand date and time function, add date and date interval, subtract dates, and calculate time intervals
• Create a workbook through a template, create and edit a template, and use and customize sparklines
Prerequisites: Please note: Students are advised to complete Introduction to Excel prior to enrolling in the Intermediate course. Many students (even those well-versed in Excel) feel behind jumping right to the Intermediate level.
|
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.
|