Study Guides (247,929)
United States (123,247)
BUS 1000 (6)
Final

# BUS 1000 Final: Excel Must Knows Premium

2 Pages
43 Views

School
Department
Course
BUS 1000
Professor
Berna Basar
Semester
Spring

Description
RECITATION CHEAT SHEET EXCEL BASICS: o PROFIT Profit = revenue cost o SUM =SUM(First number: last number) o AVG =AVERAGE(First number: last number) PIVOT TABLES INCOME STATEMENT o Gross Profit Margin = Revenue COGS (Cost of Goods Sold) o Net Income before tax = GPM (Gross Profit Margin) Operating Expenses o Net Income = Net Income before tax taxes LOOKUP o =LOOKUP(el,nter source cell, {range of numbers}, {group, names}) o (1,2) = group COUNTIF o How many times in a certain group o =COUNTIF(highlight all the cells, group name) BREAKEVEN POINT o Units Sold o Price per Unit o Revenue (Units sold * price per unit) o Fixed Cost o Variable Cost o Total Costs = fixed cost + (Variable * units sold) o Profit = total cost revenue o Breakeven point = = fixed cost (price per unit variable cost per unit) CHARTS AND GRAPHS
More Less

Related notes for BUS 1000
Me

OR

Join OneClass

Access over 10 million pages of study
documents for 1.3 million courses.

Join to view

OR

By registering, I agree to the Terms and Privacy Policies
Just a few more details

So we can recommend you notes for your school.