In this video, I will teach you how to determine whether an individual made their sales goal, and if that is true, then calculate the commission rate using the Vlookup function in Excel to determine their total sales commission.
So there I was smoking a Dominican Republic cigar in my backyard on May 19th, 2017. It was a Friday night and I had my backyard to myself under a moonlit sky and I was happy to declare it "me time." This was my time to celebrate taking "the leap" after resigning from working in my old 9 to 5, 401K world. I left on good terms with my employer and was now truly free to start my own business. For the first time, I had my eyes wide open to the realities of getting as close as possible to my customers in helping them solve their problems. I was determined that night that if [...]
Download my pdf for QuickBooks Online Shortcuts for Mac and PC users QuickBooks Online Shortcuts PC (CONTROL + ALT + KEY below) MAC (CONTROL + OPTION + KEY below) To perform action while on regular pages SHORTCUT KEY ACTION i Invoice w Check e Estimate x Expense r Receive Payment c Customers v Vendors a Chart of Accounts l Lists h Help f Search Transactions TO PERFORM ACTION WHLE WORKING ON TRANSACTION FORMS x Exit transaction view c Cancel out s Save and New d Save and Close m Save and Send p Print Shortcuts for dates while curser is in a date field (only need to type the letter) TODAY T for Today [...]
Imagine you need to add your signature to a Word document. Did you know you can have your signature block on on file so that it can be reused with Word’s QuickPart’s gallery. How much more productive could you be if you could avoid the print, sign, scan back to computer a Word document. Instead with just a click of a button your John Hancock will be ready to go. You can use a program like Paint to pen your signature. Paint is free and comes with the Windows operating system. Select a brush and etch it out with your mouse. Select the image and copy it to Word. Click Image–>Select and drag a [...]
Are you new to budgeting? First start off by writing down your short and long term goals that you want to accomplish in your life. Second, write down your non-compromising values. Your budget should flow from your values and goals. Download my free monthly income and expense spreadsheet. Download my Income and Expense Monthly Tracker.
This post will teach you how to add gold stars to cells that meet a certain condition. In my example below, I want to highlight any cell that is greater than 90 for the customer service grade. First I select the cells. Then I click the Home tab–>Conditional Formatting–>New Rule. I select Icon Sets from the Format Style drop down and 3 Stars from the Icon Style drop down. Next I change the percentage to number so that it reads Gold Star is when value is >=90 Number. I select no cell icon from the other icons to block any other number from showing a half star. The final output is displayed as.