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
Microsoft Word
In Microsoft Word, to print two-sided or duplex printing, your page numbers need to be aligned to the right on odd pages and to the left for even pages. To do this in Word, you turn on Different Odd and Even headers/footers. Steps to creating Odd and Even Headers
Microsoft Word
Microsoft Word performs a One to One mail merge by default. This means if you have five sales reps and each rep has 5 new potential leads, when you do a mail merge, each rep will receive five letters. That is 25 letters when ideally, you only want to send
Microsoft Word
Microsoft Word comes with plenty of predefined text watermarks. Among them are Draft, Confidential, Do Not Copy, Sample, Urgent, and ASAP. When you create a watermark it is in the center of the page by default. You can change the font, size, and color of any watermark. If you don’
Microsoft PowerPoint
PowerPoint has a new feature called QuickStarter. I think it is awesome! PowerPoint QuickStarter solves this problem by building an outline for you with suggested sections, talking points, and properly attributed Creative Commons images to help get you started. It doesn’t create a finished product for you, but it