Description
Excel Intermediate
Continuation of the Microsoft Excel Beginning course. Using the Microsoft Office Suite, focus on the higher-level concepts of Microsoft Excel spreadsheet software. Use Excel tables to analyze and manipulate data; create data validations. Work with multiple worksheets; protect worksheets and workbooks; create and save custom views. Work with images and integrating Excel with other program data. Summarize and analyze data using subtotals, PivotTables, PivotCharts and PivotReports. Work with functions such as VLOOKUP, DSUM, GETPIVOTDATA. This course will use Microsoft Office 365/Excel 2019. Pre-requisite: Excel Beginning or consent of instructor, and competency in Windows including file management skills.
Details
Grading Basis
Official
Units
1
Offering
Course
COMPSOFT 10103139
Academic Group
Associate Degree
Academic Organization
Business Technology
Enrollment Requirements
Pre-requisite: Excel Beginning or consent of instructor, and competency in Windows including file management skills.
Typically Offered
Fall, Spring, Summer