});

LinkedIn Is YOUR Digital Business Card

Read More

Credit Card Processing: Better to Work with Resellers or Processors?

http://www.practicalecommerce.com/articles/127893-Credit-Card-Processing-Better-to-Work-with-Resellers-or-Processors

My recent series on working with credit card salespeople prompted some good feedback and questions from readers. I addressed some of the questions in my …

Read More

Developing a new market for our art

http://www.practicalecommerce.com/columns/hand-painted-ecommerce/127770-Developing-a-new-market-for-our-art

At the heart of every ecommerce business is the need to sell goods or services at a profit. In the past year, we at overstockArt have …

Read More

Agency Does $6m 2015, 41 Employees with Publisher/Advertiser Network CEO Nathan Putnam of Monumetric

http://nathanlatka.com/thetop431/

In Episode #431, Nathan interviews Nathan Putnam, an entrepreneur who’s currently working on a company called Monumetric. Their focus?—help people unlock the earning potential behind online content through data analysis and optimization strategies. As Nathan says, “What we do is not magic. It’s science.”

Subscribe_Buttons_iPhone

Subscribe_Button_Android

iTunes, Google Play, Stitcher, Soundcloud, How to Subscribe

Famous Five:

  • Favorite Book? – Start with Why, Reality Check, Leaders Eat Last
  • What CEO do you follow? – Brian O’Kelley
  • Favorite online tool? — Slack
  • Do you get 8 hours of sleep?— “No. Not close”
  • If you could let your 20 year old self know one thing, what would it be? – “Look stop listening to music as entertainment. Remember, whatever you put in your brain, that’s what’s going to come out”

Time Stamped Show Notes:

  • 01:40 – Nathan introduces Nathan Putnam to the show
  • 02:27 – Monumetric functions
  • 03:44 – Current number of publisher partnerships
  • 04:05 – Why people use Monumetric and not Google Analytics or AdSense
    • 04:29 – Second price auction
    • 04:58 – “Google is our best partner but also our greatest competition”
  • 06:55 – Business was founded in 2014
    • 07:07 – Started entrepreneurship in 2012
  • 08:23 – Total revenue in 2014
    • 08:40 – Got a few good publishers
    • 09:18 – Sixsistersstuff.com
    • 09:44 – Driving customers acquisition
    • 10:20 – Monetize traffic
  • 11:10 – Biggest costs
  • 11:38 – Number of buyers and advertisers
    • 11:43 – Six top-tier providers
  • 12: 36 – The publisher on the six sisters’ site
    • 13:04 – Integrated with 5 largest agencies
    • 13:30 – Percentage that goes back to the seller
  • 14:20 – In 2015, total amount of ads spend that went through the platform
    • 14:35 – Cost structure of revenue
  • 14:50 – Social or website traffic
    • 15:19 – Disenchanted with agency’s space
    • 15:45 – Use it in a way that reinforces the platform’s model
    • 16:46 – “What you can monetize is what you own”
  • 17:05 – Self-funded or boot strap?
    • 17:08 – Bootstrap
    • 17:04 – Current team size
  • 17:35 – Connect with Nathan thru his LinkedIn
  • 19:20 – The Famous Five

3 Key Points:

  1. Utilize your platform to maximize its full potential.
  2. Build honest and genuine relationships.
  3. Always seek the opportunity.

Resources Mentioned:

  • Toptal – Nathan found his development team using Toptal  for his new business Send Later. He was able to keep 100% equity and didn’t have to hire a co-founder due to quality of Toptal  developers.
  • Host Gator – The site Nathan uses to buy his domain names and hosting for cheapest price possible.
  • Freshbooks – The site Nathan uses to manage his invoices and accounts.
  • Leadpages  – The drag and drop tool Nathan uses to quickly create his webinar landing pages which convert at 35%+
  • Audible – Nathan uses Audible when he’s driving from Austin to San Antonio (1.5 hour drive) to listen to audio books.
  • LinkedIn – Nathan’s linkedin
  • Show Notes provided by Mallard Creatives

The post Agency Does $6m 2015, 41 Employees with Publisher/Advertiser Network CEO Nathan Putnam of Monumetric appeared first on Nathan Latka.

Read More

13 time-saving Excel shortcuts & tips for marketers

https://searchenginewatch.com/2016/09/28/13-time-saving-excel-shortcuts-tips-for-marketers/

Back in 2013 John Gagnon wrote a very popular post detailing some of his favourite Excel tips and tricks.

We thought we’d update the list of classic shortcuts with a few that reflect some new functionality in Excel 2016.

New Excel tips for 2016:

1. Navigate ‘The Ribbon’ with ALT

In Excel 2016 the ribbon refers to the menu of tabs (File, Home, etc.) at the top of your workbook. Simply hitting ALT will quickly highlight the related keys then used to jump to certain ribbon tabs.

For instance, ALT followed by M will take you to the ‘Formulas’ tab.

navigate the ribbon

You can easily move between tabs by pressing ALT and using the left and right arrow keys, while CTRL + F1 toggles between hiding and showing the ribbon altogether.

2. Tell me what you want to do

Excel 2016 comes with a new helpful feature located in the ribbon, the ‘Tell me what you want to do’ search box.

Click the box, or if you are using Excel without a mouse hit ALT + Q to jump right to it. Whether it’s adding rows or using VLOOKUP, the box is very useful for new and old Excel users alike.

tell me what you want to do

3. New Excel Tip: smart lookup

If you want information from beyond the realms of Excel, another new function for 2016 is the ‘Smart Lookup’ tool which allows you to make a Bing-powered internet search without leaving the Excel pane.

Smart Lookup is located in the ‘Review’ tab and can also be accessed by ALT + R + S.

smart look-up

Classic Excel tips:

Courtesy of John Gagnon. The following tips are accurate and still work as of September 2016.

4. Automatically SUM() with ALT + =

Quickly add an entire column or row by clicking in the first empty cell in the column. Then enter ALT + ‘=’ (equals key) to add up the numbers in every cell above.

Automatically SUM with ALT

5. Logic for number formatting keyboard shortcuts

At times keyboard shortcuts in Excel seem random, but there is logic behind them. Let’s break an example down. To format a number as a currency the shortcut is CRTL + SHIFT + 4.

Both the SHIFT and 4 keys seem random, but they’re intentionally used because SHIFT + 4 is the dollar sign ($). Therefore if we want to format as a currency, it’s simply: CTRL + ‘$’ (where the dollar sign is SHIFT + 4). The same is true for formatting a number as a percent.

Number Formatting Keyboard Shortcuts

Number Formatting

6. Display formulas with CTRL + `

When you’re troubleshooting misbehaving numbers first look at the formulas. Display the formula used in a cell by hitting just two keys: Ctrl + ` (known as the acute accent key) – this key is furthest to the left on the row with the number keys. When shifted it is the tilde (~).

Display Formulas

7. Jump to the start or end of a column keyboard shortcut

You are thousands of rows deep into your data set and need to get to the first or last cell. Scrolling is OK but the quickest way is to use the keyboard shortcut CTRL + ↑ to jump to the top cell, or CTRL + ↓ to drop to the last cell before an empty cell.

Jump to the Start or End of a Column Keyboard Shortcut

When you combine this shortcut with the SHIFT key, you’ll select a continuous block of cells from your original starting point.

8. Repeat a formula to multiple cells

Never type out the same formula over and over in new cells again. This trick populates all of the cells in a column with the same formula, but adjusts to use the data specific to each row.

Repeat a Formula to Multiple Cells

Create the formula you need in the first cell. Then move your cursor to the lower right corner of that cell and, when it turns into a plus sign, double click to copy that formula into the rest of the cells in that column. Each cell in the column will show the results of the formula using the data in that row.

9. Add or delete columns keyboard shortcut

Managing columns and rows in your spreadsheet is an all-day task. Whether adding or deleting, you can save a little time when you use this keyboard shortcut. CTRL + ‘-‘ (minus key) will delete the column your cursor is in and CTRL + SHIFT + ‘=’ (equal key) will add a new column. From an earlier tip, think about CTRL + ‘+’ (plus sign).

Add or Delete Columns Keyboard Shortcut

10. Adjust width of one or multiple columns

It’s easy to adjust a column to the width of its content and get rid of those useless ##### entries. Click on the column’s header, move your cursor to the right side of the header and double click when it turns into a plus sign.

Adjust Width of One or Multiple Columns

11. Copy a pattern of numbers or even dates

Another amazing feature built into Excel is its ability to recognize a pattern in your data, and allow you to automatically copy it to other cells.

Simply enter information in two rows which establish the pattern, highlight those rows and drag down for as many cells as you want to populate. This works with numbers, days of the week or months!

Copy a Pattern of Numbers or Dates

12. Tab between worksheets

Jumping from worksheet to worksheet doesn’t mean you have to move your hand off the keyboard with this cool shortcut. To change to the next worksheet to the right enter CTRL + PGDN. And conversely change to the worksheet to the left by entering CTRL + PGUP.

Tab Between Worksheets

13. Double click format painter shortcut

Format Painter is a great tool which lets you duplicate a format in other cells with no more effort than a mouse click. Many Excel users (Outlook, Word and PowerPoint too) use this handy feature, but did you know you can double-click Format Painter to copy the format into multiple cells? It’s quite a time-saver.

Double Click Format Painter

Read More

Share This Page On:

Click ►HERE◄ to get this Social Footer for FREE... CLOSE
 
Delicious