Microsoft Excel
Human Resource Professionals have a hectic schedule. They deal with benefits, training, staffing, retention, reviews, hiring, firing, personnel manuals, and many other HR aspects of their jobs. I’ve put together a list of Excel functions every HR Professional should know. This list is not all inclusive but comes from
Microsoft Excel
Break-even overview Calculating the break-even on a company with only one product is relatively easy. Just take the total fixed expenses and divide by the contribution margin per unit. The contribution margin per unit is the unit sales price minus the unit variable cost. Here is an example. If a
Microsoft Excel
If you want to become a master of Excel, you need to learn how to use array formulas. Array formulas will perform calculations that other formulas in Excel can’t do. Here is example 1 – multi-cell calculation to return multi results 1. Select D2 to D8. 2. Type **=B2:B8\
Microsoft Excel
Vlookup is a great function. Most Excel users would have it in their top 10 function list. VLOOKUP is a lookup and reference function. If you are trying to find things in a table or a range by row Vlookup is a great function to use. Two other functions when
Microsoft Excel
To calculate weekly revenue or weekly orders in MS Excel, you can use either PivotTables or Vlookup. I prefer the PivotTable method but I will show both methods. One of your data fields needs to be a date field such as invoice date, purchase order date, order date, etc… Excel’
Microsoft Excel
Excel’s SUBTOTAL function can show the SUM, AVERAGE, COUNT, MAX, MIN, and others functions. You should use the SUBTOTAL function to exclude values in hidden rows and get totals of totals. YouTube Video of using Subtotals Use Subtotal Function to calculate grand totals by Chris Menard - YouTube Table
Microsoft Excel
**Vertical analysis**, also called common-size analysis, takes the Sales and looks at each line items so that you can easily compare the income statements and balance sheets. Vertical analysis on an income statement will show the sales number (sometimes listed as Revenue) as 100%, and every other account will show
Microsoft Excel
A client sent me an Excel file they pulled from a database. I had to correct the dates, numbers, and text so I could do calculations. In this blog post, I cover: 1. T function 2. Text to columns 3. CTRL + H for replace 4. Trim function 5. Convert text
Microsoft Excel
You can create a named range that refers to a single cell in Excel. You can also select a group of cells on the worksheet and make it a named range. After you define Excel names, you can use the names in a formula, instead of using a constant value
Microsoft Excel
To find the break-even, you need to take your variable expenses and subtract them from your revenue or sales. This is knows as the Contribution Margin. **Variable** expenses are: 1. Direct material 2. Commission per unit 3. Hourly production wages 4. Shipping cost 5. Packaging Variable expenses are those expenses
Microsoft Excel
When you import data into Excel, occasionally a column of data will only have a key field listed one time. An example would be States only showing once at the start of each data set. See the image below. _Notice_ **column A**. It only displays the state for the first
Microsoft Excel
When you enter zip codes in Excel, the leading zeros will get dropped. Here are some examples. Massachusetts starts with 01 and 02. Hew Hampshire is 03, Maine is 04, Vermont is 05, Connecticut 06, and New Jersey is 07 and 08. So when you type in the zip codes