Tip #7 - Calculating Difference in Time To calculate the difference between hours, use: =(End Time - Begin Time)*24 To calculate the difference between days, use: =End Date - Begin Date To calculate the difference between work days, use: =NETWORKDAYS(Begin Date, End Date) To calculate the difference between months within the [...]
Article #3 Find information using the Any Field in SmartList. SmartList allows you to search an “Any Field” option. Open your SmartList, go to Search, and use the lookup button on the field filter. Make sure the Columns window is set to “All Columns” and search for the “Any Field” field name. Once selected [...]
Week #5 Welcome back to our new series of blog posts, Simplifying The Geek Speak! Thanks for continuing to tune in. For those of you just joining us…this blog is setting out to simplify the overly complicated. Recently I was helping a client with their computer. The reason I was there was because the computer [...]
Tip #3 Welcome Back to our Excel Tips Series. This week's tip has us pretty excited over here at Complete Software! Do you need to know the number of unique item combinations in a given set of data? You’ll be happy to know that Microsoft has added distinct count of values to Pivot Tables [...]
Article #1 Negative Debits and Credits When entering account transaction data in Dynamics GP, the system tries to be helpful and defaults the cursor to the debit or credit column based on the settings in the account’s setup. This is great until you want to debit an account with a default credit balance and the [...]
Week #2 Welcome back to our new series of blog posts, Simplifying The Geek Speak! How many times have you asked a simple question, let’s say…”How do I make my computer run faster?”…and receive an answer along the lines of… “We need a check disk, a defrag, possibly a modification to the startup services and [...]
Microsoft Excel 2013 Tip #1 Are you looking for a change? Bored of the same old Excel look? Here’s a quick fix! Change the color. We only have two extra options to change to, but that is better than none. Choose File | Options to display the Excel Options dialog box. Click the General tab [...]
Experiencing SQL slowdowns? Is it taking forever for your data to process? It may be the memory settings on your SQL server. Read below to find out how to change your memory settings to adjust your Server Memory Options: SQL Server is designed to request as much RAM as possible which will not be released [...]
Are you a non-profit or non-governmental organization? Office 365 may now be available to you through Microsoft’s software donation program. If you are a qualifying non-profit you may be eligible for free or reduced-rate versions of Office 365. If you are new to Office 365, your organization can download the Free Trial Version of [...]
"Ensure the VMware View agent is operating properly." Error To resolve this issue, perform these steps in order: Reinstall theVMware View agent. If this does not solve your issue, proceed to step 2. Reinstall the VMware View Client on the client PC. If this does not solve your issue, proceed to step 3. Stop [...]