Select Page

## Excel Functions for HR Professionals

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...

Google Wallet is free! It is one of the fastest ways to send money, You can send money through either the app, in Gmail, or use the web. The website is wallet.google.com. You can send money to someone using just their email address or phone number — they don’t...

## Scrape data from Wikipedia to a Google sheet

Do you ever have Wikipedia data you need in a spreadsheet? Using Google Sheets you don’t have to copy and paste. Instead, use the ImportHTML function in Google Sheets and get the data from Wikipedia. Scraping data can save you tons of time. Copy and paste...

## Google Calendar – 3 Lab features you need to use

The Google calendar is great. Not many people utilize the Labs feature in Google calendar. Here are three features you probably didn’t know about, but should use from Google labs. Hide Morning and Night Do you have meetings at 2 am? Likely not. There is no...

## Breakeven in Excel with multiple products

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...

## Remove the blank page after inserting an envelope in Word

After you insert an envelope in Word, you end up with page 2 of your document being a blank page to type the letter. Page 1 is the envelope. Most of the time you only want the envelope and not the blank page. Steps for removing the blank page: Press Ctrl+Home to go to...

## Array Function vs Countif and Countifs

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 Select D2 to D8. Type...

## Vlookup vs Index and Match in 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 joined...

## Calculate Weekly Revenue in Excel with Vlookup and PivotTables

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,...

## Use Subtotal Function to get totals of totals

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 Table of what the Subtotal numbers mean...