BUSN218 — Advanced Excel for Business
BUSN 218 - Advanced Excel for Business BUSN 218 - Advanced Excel for Business 5 Credits Students will learn how to quickly build linked systems of spreadsheets for the analysis of accounting, financial and statistical data in order to provide useful information to business decision makers. Students also learn how to make basic to advanced business and financial calculations. Emphasis on math skills, critical thinking and spreadsheet construction theory. Must have access to a PC computer with Microsoft Office 365 2.0 Fees Academic Technology Fee Quarters Typically all Online Winter Day, Online Designed to Serve Students in AAS Business programs,or related programs. Business community needing advanced Excel skills. Active Date 20250401T11:42:10 Grading Basis Decimal Grade Class Limit 28 Lecture 55 Total Degree Distributions: ProfTech Course Yes Restricted Elective Yes Course Outline Types of data In Excel: Numbers, Text, Logical, Errors. Stylistic formatting: Style Formatting, Page Setup, Styles. Number Formatting, including Custom Number Formatting. Formulas and Functions. The eleven formula elements: Equal Sign, Cell References, Math Operators, Comparative Operators, Numbers, Text, Operators, Functions, Ampersand, Array Constants, Wild Cards. The five types of formulas: Calculating, Text, Lookup, Array, Logical. Eight types of cell references: Relative, Absolute, Mixed, Worksheet, Workbook, Defined Named Ranges, Formulas To Define Reference, Table Nomenclature. Advanced formu
Prerequisites: BUSN216