Description
Excel Intermediate
Continuation of the Microsoft Excel Beginning course. Focuses on the higher level concepts of Microsoft Excel spreadsheet software within the Microsoft Office Suite. Summarize and analyze data using subtotals, PivotTables, and PivotCharts. Automate business analysis with tools such as Goal Seek, data tables, and Solver and run scenarios using Scenario Manager. Use Date, Logical, Lookup, Database, and Financial functions such as VLOOKUP, HLOOKUP, OR, AND, nested IF, COUNTIF, SUMIF, AVERAGEIF, DSUM, and DCOUNT. Analyze statistics using statistical functions.
Details
Grading Basis
Official
Units
1
Offering
Course
COMPSOFT 10103139
Academic Group
Associate Degree
Academic Organization
Business Technology
Enrollment Requirements
Prerequisite: Excel Beginning, 10103133