Inventory and Cost of Goods Sold
A merchandising company buys and sells inventory. When sold, inventory costs become the cost of goods sold (COGS), which is usually a company’s largest cost.
Inventory and Cost of Goods Sold Read More »
Accounting for Merchandising Activities
A merchandising company sells merchandise inventory to customers. Accounting for companies that sell inventory is more complex than for service companies.
Accounting for Merchandising Activities Read More »
Excel XLOOKUP Tutorial
XLOOKUP is an Excel function that can lookup and reference data. Since it can search both vertically and horizontally, it can replace both VLOOKUP and HLOOKUP.
Excel XLOOKUP Tutorial Read More »
What-If Analysis in Excel
What-if analysis is the process of changing input values to see how the changes affect other output data. What-if analysis is a powerful tool in Excel.
What-If Analysis in Excel Read More »
Data Analysis in Excel
Using Excel is a great way to start data analysis. Excel can handle large data sets with tools like pivot tables, pivot charts, and regression analysis.
Data Analysis in Excel Read More »
Financial Functions in Excel
Excel has 55 financial functions to solve financial problems. Excellent financial analysis requires using many financial functions in Excel. These functions use time value of money (TVM) calculations to solve many financial problems.
Financial Functions in Excel Read More »