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 Word
An index lists the terms and topics that are discussed in a document, along with the pages that they appear on. To create an index, you mark the index entries by providing the name of the main entry and the cross-reference in your document, and then you build the index.
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 Outlook
You can delay the delivery of all outgoing Outlook messages by creating a simple rule. If you want to delay just one email, you do that within the message itself. That is located on the Options Tab and Delayed Delivery. Here is my blog post of delaying just one email
Tools
Always lock your computer. It is time for lunch, and the lunch crowd has gathered and is waiting on you. You missed breakfast, and you are hungry. You get up from your desk and head out the door. Did you remember to lock your computer? It is amazing to me
Microsoft Outlook
To import an Excel file that has contact information into Outlook, there are three main steps: 1. Save your Excel workbook as a .csv file. 2. Import your contacts. 00:56 in the video 3. Map the Excel spreadsheet columns with the appropriate Outlook fields. 01:35 in the video
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