Get Started for FREE
Sign up with Facebook Sign up with X
I don't have a Facebook or a X account
 Your new post is loading...
Scoop.it!
The current version is Excel 2016, released in late 2015 when the entire Office suite was upgraded. But although you may have upgraded to the latest version, you might be missing out on some worthwhile features introduced in Excel 2016 -- that's what we'll look at in this story. 
No comment yet.
Sign up to comment
Scoop.it!
For years, I’ve used the publication as a resource to not just describe how to do things, but to also keep a record for myself to look up later! Today, we had a client that handed us a customer data file that was a disaster. Virtually every field was misformatted and; as a result, we were unable to import the data. While there are some great add-ons for Excel to do the cleanup using Visual Basic, we run Office for Mac which won’t support macros. Instead, we look for straight formulas to assist. I thought I’d share some of those here just so others can use them.
Marteq's insight:
CT and bookmark!!
MarTech requires constant optimization to continually squeeze ever improving performance. No time for continual CRO? Contact us. #MarTech #DigitalMarketing
Scoop.it!
From
siteber
MarTech is the New Black. Get fashionable. Contact us to see how.
Marteq's insight:
This list is a helluva lot better than Googling for an answer!
Scoop.it!
Learn how to use Excel to analyze your social media marketing to deliver content that builds engagement and community. Intermediate/ Introduction... Are you looking for a way to analyze the impact of your content? Do you need a simple system that works? If you don’t have the budget for expensive software, spreadsheets and a little of your time can produce some useful data. In this article I’ll show you how to analyze the engagement and impact of your social media posts using Excel.
___________________________________ ► FREE: AgileContent™ delivers more quality content to your market! Get your FREE 14 Day Trial NOW!: http://goo.gl/rzeg79. No credit card required!
► Receive a FREE daily summary of The Marketing Technology Alert directly to your inbox: http://ineomarketing.com/About_The_MAR_Sub.html (your privacy is protected).
Marteq's insight:
The article is a step by step, hands-on explanation on how to use Excel for social media analysis. Obviously, it doesn't offer the in-depth details that a HootSuite offers, but with a bit of elbow grease you'll have some idea as to what is going on.
Scoop.it!
Marteq's insight:
Click on the image to take you to a video tutorial (about 12 minutes).
Scoop.it!
The experience of using a spreadsheet for managing a marketing budget can range from simplistic to nightmarish. Read on to find out the 5 problems with managing budgets on a spreadsheet. Condensed... There are five primary problems with using spreadsheets. 1) Spreadsheet data can be erroneous when entered or changed. 2) Spreadsheet consolidations and aggregations are not for the weak of heart. 3) Spreadsheets are not scalable. I have seen marketing budgets that encompass hundreds of marketing programs, multiple lines of business or geographies across multiple product lines. If you are tracking and rolling up all marketing spend transactions, you can easily get into tens of thousands of lines of spreadsheet rows making reporting and consolidations slow and difficult. 4) Spreadsheets are in reality not that flexible. Using the same scenario cited in the consolidations and scalability examples described above, imagine the impact of a decision to add a column, track a new element, add a new category of spending or a new line of business. 5) Spreadsheets are problematic to inspect and audit. We’ve all seen it. Your spreadsheet doesn’t cross foot or total up to what’s in the submitted budget or spending report. Consider a budget that was fine on Monday but is now not footing on Tuesday. Who changed it and where was the change made. What’s your audit trail?
Marteq's insight:
ESPECIALLY THE AUDIT TRAIL! Once you start going down the .xls trail, we won't see you for another two weeks. Marketo and others offer financial management tools as a part of MA: doesn't it make sense that results from campaigns are auto-rolled into your budget from one location?
Scoop.it!
Summary... To turn your raw data into an asset, many powerful add-ins have been built to plug in to Excel.
Marteq's insight:
THIS IS GREAT STUFF!!!! We're all Excel jockeys, and this is a tremendous collection of Excel add-ons to make our lives easier. Look: it's certainly NOT a Big Data solution...more like a Little Data solution, but that's OK as these add-ons will be very helpful. We're looking forward to jumping into Excellent Analytics.
|
|
Outstanding!!
Visualize your Marketing Stack. marketingIO will analyze your marketing technology and deliver a visual of your MarTech Stack. Free. Go here: http://go.marketingio.com/stack_analysis
#MarTech #DigitalMarketing