3 Crazy Excel Formulas That Do Amazing Things Excel formulas can do almost anything. In this article, you’ll learn how powerful Microsoft Excel formulas and conditional formatting can be, with three useful examples. Much of the power lies behind the Excel formulas and rules that you can write to manipulate data and information automatically, regardless of what data you insert into the spreadsheet. Let’s dig into how you can use formulas and other tools to make better use of Microsoft Excel. Conditional Formatting With Excel Formulas One of the tools that people don’t use often enough is Conditional Formatting. With the use of Excel formulas, rules, or just a few really simple settings, you can transform a spreadsheet into an automated dashboard. To get to Conditional Formatting, you just click on the Home tab, and click on the Conditional Formatting toolbar icon. Under Conditional Formatting, there are a lot of options. When you click on Manage Rules, it’ll take you to the Conditional Formatting Rules Manager. 1. 2. 3.
Content Curation Primer Photo by Stuck in Customs What is Content Curation? Content curation is the process of sorting through the vast amounts of content on the web and presenting it in a meaningful and organized way around a specific theme. Content curation is not about collecting links or being an information pack rat, it is more about putting them into a context with organization, annotation, and presentation. People and organizations are now making and sharing media and content all over the social web. Content Curation Provides Value from the Inside Out What does that mean for nonprofits and the people who work for them? For some staff members, content curation can be professional of learning. The biggest challenge to becoming a content curator is getting past the feeling of “content fried” or so much good content and so little time to digest it. The Three S’s of Content Curation: Seek, Sense, Share Content curation is a three-part process: Seek, Sense, and Share. Getting Started
4 Cool Competitive Analysis Tools Every Digital Marketer Should Use Want to win online? Then there is a lot you can learn from your competitors’ digital marketing strategies, especially those that are currently outperforming you online. Gaining an in-depth understanding into the key strategies being used by your top performing competitors can provide you with the insight and knowledge you need to gain a competitive edge. “If you want to achieve success, all you need to do is find a way to model those who have already succeeded” – Tony Robbins It’s not about reinventing the wheel, its about modelling the leaders in your field so that you can emulate or even surpass their results. Recommended for YouWebcast: Growth at a Scale Up: How to Grow When You're No Longer a Startup In this post, I’m going to review a few of the best paid and free competitive analysis tools that will help you discover and analyze your competitors’ strategies. 1. SimilarWeb has become a staple tool for competitive analysis. 2. 3. Google Alerts Wrapping It Up
Innovations in Education » Understanding Content Curation July 7, 2012 Come to my session at ISTE 2016: “Personalize Learning With Student Curation” 6/28 4:00 – 5:00 CCC 113, Table 2 There are many buzzwords and phrases prevalent in education today. “21st Century Learning”, “Blended Learning”, “Personalized Learning”, “Flipped Classroom” – just to name a few. The one that has recently caught my attention and curiosity is “content curation.” I manage a grant project in my district designed to assure students acquire “21st century skills” A current strategy for this is using backwards design, formative assessments of 21st century skills, and “blended-learning.” This curiosity led to further questions: Why curate? Collecting vs. I set out to read as much as possible of what others have written on the subject, (see my Scoop-It on Curating Learning Resources) to help with my understanding. Defining Curating in Education by Nancy White is licensed under a Creative Commons Attribution 4.0 International License. Thinking Level Process Organization Value
Home Beautiful Email Marketing for Gmail Design amazing emails with our drag-and-drop editor. Create a list from your contacts. Send & track. Design Emails Build Lists Track Results It's Free Sign Up for FREE Try Flashissue for Mailchimp People told us marketing with Gmail was too darn hard and we agreed. Take a Look Make yourself look more professional. Faster Design The Flashissue drag & drop editor is so easy to use anyone can create stunning looking emails in minutes . Keeping it simple We turned your existing Gmail account into a total online marketing tool. No need to sign up for yet another online service. Try Flashissue for Free Win more business Your message to people's inbox Look professional 100% integration with Gmail Sign Up for FREE Take the Tour Step 1: Create mailing list Your starting point is the people you already have in your address book. Create my first mailing list here Step 2: Design Email Create your email using our simple drag and drop editor. Health & Fitness
The Power of Google By Delano Taylor|source: Feb 22nd, 2012 Google.com is pretty self explanatory. Right? If you said yes, there’s a good chance you’re not using Google to its full potential. Recently, I found that there’s this complete underground world of mind-blowing search tools for Google, never before mentioned to me. With midterm papers beginning to breath down my back, this information will be quite beneficial. 11k 5 Methods And 15 Tools To Find Your Audience And Build a Community No matter what you do in life, chances are good you’re reliant on some kind of a community. People to read your writing. Social sharers to spread your message and curate your content. Customers to review your products or services and tell their friends about you. Communities work because they’re built on relationships, and during the early stages of any new project, you need all the strong relationships you can get. The community you grow will be the source of your very first (and potentially most supportive) group of brand advocates. So how do you find this all-important community and get to know them—the right way? Audience discovery has a lot to do with self-discovery. In this post, we’ll show you many of our favorite tools (including our own) and methods to learn about your first users and customers, find your audience and begin to build a community from scratch. Mention: Find the audience for your passion topics Forums & groups: Build new relationships Intercom: Act on real-time data
39 Blogging Tools to Help You Work Faster, Write Better, and Land More Readers When you’re finding amazing content to share on social media—the kind of thing that grabs attention and gets people to click, share, and comment—one of the most valuable, most original places to turn is your own blog and the content you personally create. So the questions become: How to create amazing content, how to put together blogposts strategically and efficiently, and how to get your content out to the masses. Writing tips are a good place to start. And to supplement the words you use to build your blogposts, I’ve found a huge number of blogging tools that help with everything from coming up with ideas to spread the content far and wide. Do you have a favorite blogging tool? Read on to see if it’s included here in the list, and drop a note in the comments with which ones you love. The Huge List of 39 Blogging Tools Tools to brainstorm blogging ideas 1. 2. 3. Enter a URL into Quick Sprout, and you get an analysis of the site’s performance and content. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13.