Microsoft Excel
Excel - new feature added. You can now deselect with the CTRL key by Chris Menard - YouTube You can now deselect with the CTRL key in Excel. Version 1801 of Office 365 Excel allows you to deselect/unselect with the CTRL key. This was one of the most requested
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
Posted on: 10/10/2017 Google Wallet - Send and Request money for free by Chris Menard **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.
Google Sheets
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. Scrape data from wikipedia and put into Google Sheets by Chris Menard Scraping
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 reason to see
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 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: 01.
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