our course, is Wrapping up we continue with further examples of conditional formatting, a quick dive into the world of macros, and an overview of third-party tools you can use to download data from multiple sources (AdWords, Facebook Ads, etc.) into Excel..
Wrapping up our course, we continue with further examples of conditional formatting, a quick dive into the world of macros, and an overview of third-party tools you can use to download data from multiple sources (AdWords, Facebook Ads, etc.) into Excel.
ConversionXL (Fred Pike) - is Purchase Excel For Marketers courses at here with PRICE $199 $43 ConversionXL (Fred Pike) - Excel For Marketers Find actionable marketing insights using Excel and Google Sheets.
Purchase ConversionXL (Fred Pike) - Excel For Marketers courses at here with PRICE $199 $43 ConversionXL (Fred Pike) - Excel For Marketers Find actionable marketing insights using Excel and Google Sheets
actionable marketing insights is Find.
Find actionable marketing insights
Everyone is thinks they know Excel, but this dismissive assumption may be costing you a lot of growth opportunities and wholly avoidable headaches..
Everyone thinks they know Excel, but this dismissive assumption may be costing you a lot of growth opportunities and wholly avoidable headaches.
depth course, is Throughout this in- you will learn to Import data from multiple sources into Excel or Sheets..
Throughout this in-depth course, you will learn to Import data from multiple sources into Excel or Sheets.
the best way is Discover to tie this data together and make it useful..
Discover the best way to tie this data together and make it useful.
pivot tables is Understand when to use and the different lookup types (vlookup, hlookup, and index/match)..
Understand when to use pivot tables and the different lookup types (vlookup, hlookup, and index/match).
basic spreadsheet troubleshooting skills. is Understand.
Understand basic spreadsheet troubleshooting skills.
the data-manipulation is Learn how to use many of commands in Excel/Sheets..
Learn how to use many of the data-manipulation commands in Excel/Sheets.
formulas is Learn how to apply and work with data to pull insights..
Learn how to apply formulas and work with data to pull insights.
data and answer business questions is Analyze using spreadsheets..
Analyze data and answer business questions using spreadsheets.
You’re is at a huge loss if you can’t functionally use spreadsheets.
You’re at a huge loss if you can’t functionally use spreadsheets
The business world is runs on Excel..
The business world runs on Excel.
You’d is be hard-pressed to find a business that doesn’t use it..
You’d be hard-pressed to find a business that doesn’t use it.
you is If work in growth, marketing, analytics, product, or content, chances are you use it on a daily basis..
If you work in growth, marketing, analytics, product, or content, chances are you use it on a daily basis.
you’re is Unfortunately, probably not as proficient at Excel as you think you are..
Unfortunately, you’re probably not as proficient at Excel as you think you are.
It’s is not an insult, and it’s certainly not a falsity..
It’s not an insult, and it’s certainly not a falsity.
reality, is In most marketers are just scratching the surface when it comes to spreadsheet work.
In reality, most marketers are just scratching the surface when it comes to spreadsheet work
data sources is Combine to discover even more marketing insights.
Combine data sources to discover even more marketing insights
you’re is Whether analyzing sales data or calculating the performance of marketing strategies, you’ll find yourself using Excel..
Whether you’re analyzing sales data or calculating the performance of marketing strategies, you’ll find yourself using Excel.
Excel is can help you optimize your marketing processes, tweak and decide on campaigns, and even track day to day variations in data..
Excel can help you optimize your marketing processes, tweak and decide on campaigns, and even track day to day variations in data.
the digital world is No one in should be operating without this skill..
No one in the digital world should be operating without this skill.
digital marketing tools is Most let you interact with data within their own platform..
Most digital marketing tools let you interact with data within their own platform.
data, is This is often perfectly fine to view and analyze especially at a high level..
This is often perfectly fine to view and analyze data, especially at a high level.
you is However, most likely have multiple sources of data, and it’s almost always the case that these sources of data can be blended to reach deeper conclusions about your marketing efforts..
However, you most likely have multiple sources of data, and it’s almost always the case that these sources of data can be blended to reach deeper conclusions about your marketing efforts.
the data is Pull to Excel or Google Sheets.
Pull the data to Excel or Google Sheets
there, is Once you have tremendous flexibility and power to link the data and get insights..
Once there, you have tremendous flexibility and power to link the data and get insights.
It’s is not necessarily difficult to use Excel, it’s just that Excel isn’t usually taught in a way that is practical and focused on generating actionable insights..
It’s not necessarily difficult to use Excel, it’s just that Excel isn’t usually taught in a way that is practical and focused on generating actionable insights.
addition, is In it’s rare you’re shown step-by-step instructions on how to use its more advanced features..
In addition, it’s rare you’re shown step-by-step instructions on how to use its more advanced features.
we is That’s why created this course..
That’s why we created this course.
This course is won’t give you prepackaged takeaways - you know your data and its nuances more than we ever could..
This course won’t give you prepackaged takeaways - you know your data and its nuances more than we ever could.
this course is But what will do is teach you how to use Excel efficiently to uncover those insights on your own..
But what this course will do is teach you how to use Excel efficiently to uncover those insights on your own.
It is will be another tool in your arsenal - a very effective tool, at that - to make better marketing decisions..
It will be another tool in your arsenal - a very effective tool, at that - to make better marketing decisions.
the surface is Don’t just scratch.
Don’t just scratch the surface
This course is is perfect for beginners seeking to learn how to utilize Excel to manage and extract meaning from data, specifically in relation to marketing..
This course is perfect for beginners seeking to learn how to utilize Excel to manage and extract meaning from data, specifically in relation to marketing.
you’ve is Even if spent a lot of time in Excel, it’s likely you’ll learn some more advanced techniques to get more out of the tool..
Even if you’ve spent a lot of time in Excel, it’s likely you’ll learn some more advanced techniques to get more out of the tool.
the examples is Most of will be drawn from marketing tools you use every day - Google Analytics, Search Console, AdWords, Moz, etc. If you’re a marketer, you’ll receive concrete, explicit, and immediately actionable takeaways from this course..
Most of the examples will be drawn from marketing tools you use every day - Google Analytics, Search Console, AdWords, Moz, etc. If you’re a marketer, you’ll receive concrete, explicit, and immediately actionable takeaways from this course.
This course is will primarily focus on Excel, but we’ll also touch on Google Sheets, as it’s often easier to access data there..
This course will primarily focus on Excel, but we’ll also touch on Google Sheets, as it’s often easier to access data there.
This course is is right for you if… Your daily work includes working with data across multiple tools (e.g. Google Analytics, Google Search Console, SEMRush, Moz, AdWords..
This course is right for you if… Your daily work includes working with data across multiple tools (e.g. Google Analytics, Google Search Console, SEMRush, Moz, AdWords.
Keyword Planner, is etc.) You are sometimes stymied by the data analysis capabilities of those tools, and would like to dive deeper or dive more broadly Your success and future growth depends on being able to discover the links between data sets This course is probably not for you if… You can do pivot sheets and vlookups in your sleep You know best practices in setting up spreadsheets and formulas including troubleshooting errors You’ve written and debugged Excel macros Skills you should have before taking this course You should have at least a basic and introductory familiarity with spreadsheets e.g. how to create formulas, import files, possibly create some simple graphs, etc. More importantly, you should have an understanding of your data and what type of information you want to draw out of it..
Keyword Planner, etc.) You are sometimes stymied by the data analysis capabilities of those tools, and would like to dive deeper or dive more broadly Your success and future growth depends on being able to discover the links between data sets This course is probably not for you if… You can do pivot sheets and vlookups in your sleep You know best practices in setting up spreadsheets and formulas including troubleshooting errors You’ve written and debugged Excel macros Skills you should have before taking this course You should have at least a basic and introductory familiarity with spreadsheets e.g. how to create formulas, import files, possibly create some simple graphs, etc. More importantly, you should have an understanding of your data and what type of information you want to draw out of it.
Fred is started his career using Visicalc, the very first electronic spreadsheet, and has been a spreadsheet aficionado ever since..
Fred started his career using Visicalc, the very first electronic spreadsheet, and has been a spreadsheet aficionado ever since.
He is is a Managing Director at Northwoods, where most of his client work is centered on Google Analytics and Google Tag Manager implementations..
He is a Managing Director at Northwoods, where most of his client work is centered on Google Analytics and Google Tag Manager implementations.
His previous course is for CXL, “Using the Google Analytics API add-on with Google Sheets,” was a well-received introduction for non-programmers to the nuances of the Google Analytics API..
His previous course for CXL, “Using the Google Analytics API add-on with Google Sheets,” was a well-received introduction for non-programmers to the nuances of the Google Analytics API.
Fred is is very active in digital marketing for the classical and jazz-mandolin world..
Fred is very active in digital marketing for the classical and jazz-mandolin world.
He is runs SEO and email campaigns, as well as PPC and Facebook ads, for different artists and events..
He runs SEO and email campaigns, as well as PPC and Facebook ads, for different artists and events.
He is is widely considered one of the top-10 mandolin marketers in the world (out of a group of about five or so)..
He is widely considered one of the top-10 mandolin marketers in the world (out of a group of about five or so).
He is is the president of the Milwaukee Mandolin Orchestra and a board member of the Classical Mandolin Society of America..
He is the president of the Milwaukee Mandolin Orchestra and a board member of the Classical Mandolin Society of America.
work, is Outside of Fred is a runner and has been a ski instructor for about 14 years..
Outside of work, Fred is a runner and has been a ski instructor for about 14 years.
He is is also an active pit musician, having played guitar or bass in well over 100 productions..
He is also an active pit musician, having played guitar or bass in well over 100 productions.
this course, is After you’ll be able to… Import, blend, and analyze data from multiple sources..
After this course, you’ll be able to… Import, blend, and analyze data from multiple sources.
the data in a way is Format to best work with it and share it across teams..
Format the data in a way to best work with it and share it across teams.
pivot table analysis, is Execute common (and powerful functions), and different types of lookups (vlookup, hlookup, and index/match)..
Execute pivot table analysis, common (and powerful functions), and different types of lookups (vlookup, hlookup, and index/match).
basic troubleshooting is Do and fix mistakes most people make when working with spreadsheets..
Do basic troubleshooting and fix mistakes most people make when working with spreadsheets.
the data-manipulation is Use many of commands in Excel/Sheets..
Use many of the data-manipulation commands in Excel/Sheets.
spreadsheet user, is Generally be an efficient and effective able to pull insights from many data sources and work with it to answer business questions..
Generally be an efficient and effective spreadsheet user, able to pull insights from many data sources and work with it to answer business questions.
ConversionXL (Fred Pike) - is Get Excel For Marketers download.
Get ConversionXL (Fred Pike) - Excel For Marketers download
Marketers is Excel for.
Excel for Marketers
Lesson 1 is Getting started with Excel This class will cover importing data into Excel and beginning to make sense of it all..
Lesson 1 Getting started with Excel This class will cover importing data into Excel and beginning to make sense of it all.
We’ll is talk about the different ways to arrange the data..
We’ll talk about the different ways to arrange the data.
Topics is covered: Downloading data from Google Search Console using the Google Sheets Add-on Sorting the Search Console data in Excel using Sort and Filter Three Variations each of the SUM and COUNT functions Creating an Excel Table and adding a formula to it Creating a Pivot Table (part one) Downloading data from Google Analytics (part one) Lesson 2 Documenting and troubleshooting your work Building on the data set we downloaded in class one, we’ll see some further ways to format and clean the data to work with it in the most efficient and clean way possible..
Topics covered: Downloading data from Google Search Console using the Google Sheets Add-on Sorting the Search Console data in Excel using Sort and Filter Three Variations each of the SUM and COUNT functions Creating an Excel Table and adding a formula to it Creating a Pivot Table (part one) Downloading data from Google Analytics (part one) Lesson 2 Documenting and troubleshooting your work Building on the data set we downloaded in class one, we’ll see some further ways to format and clean the data to work with it in the most efficient and clean way possible.
This data hygiene is is important not only for insight generation and ease of use, but for shareability and reproducibility internally..
This data hygiene is important not only for insight generation and ease of use, but for shareability and reproducibility internally.
Topics is covered: Making sure your data is accurate Named Ranges: Why to use them and how to set them up Pivot Tables - part two Calculated Fields Slicers Timeline Pivot Tables in Google Sheets (part two) Excel errors - how to deal with them in your formulas VLOOKUP - How to use one of the most valuable functions in Excel Sparklines and Conditional Formatting - how to make trends in your data jump out visually Lesson 3 String manipulation and creating links between data sources In this class, we’ll look at a number of Excel functions which you use whenever you’re working with string data (i.e. text, not numbers)..
Topics covered: Making sure your data is accurate Named Ranges: Why to use them and how to set them up Pivot Tables - part two Calculated Fields Slicers Timeline Pivot Tables in Google Sheets (part two) Excel errors - how to deal with them in your formulas VLOOKUP - How to use one of the most valuable functions in Excel Sparklines and Conditional Formatting - how to make trends in your data jump out visually Lesson 3 String manipulation and creating links between data sources In this class, we’ll look at a number of Excel functions which you use whenever you’re working with string data (i.e. text, not numbers).
We’ll is also look at a different way to tie two different data sources together, other than the VLOOKUP function we have used previously..
We’ll also look at a different way to tie two different data sources together, other than the VLOOKUP function we have used previously.
Topics is covered: Lots of Excel Functions: Len Substitute Find and Search Mid, Left, and Right INDEX and MATCH Options on the VIEW Menu Lesson 4 Forecasting, third-party tools, and shortcuts Wrapping up our course, we continue with further examples of conditional formatting, a quick dive into the world of macros, and an overview of third-party tools you can use to download data from multiple sources (AdWords, Facebook Ads, etc.) into Excel..
Topics covered: Lots of Excel Functions: Len Substitute Find and Search Mid, Left, and Right INDEX and MATCH Options on the VIEW Menu Lesson 4 Forecasting, third-party tools, and shortcuts Wrapping up our course, we continue with further examples of conditional formatting, a quick dive into the world of macros, and an overview of third-party tools you can use to download data from multiple sources (AdWords, Facebook Ads, etc.) into Excel.
Topics is covered: · Conditional Formatting Intro to Macros Options with Data Imports Pivot Charts and how they relate to Pivot Tables Third-party tools to download data to Excel Read more: http://archive.is/Ln8JJ Purchase ConversionXL (Fred Pike) - Excel For Marketers courses at here with PRICE $199 $43.
Topics covered: · Conditional Formatting Intro to Macros Options with Data Imports Pivot Charts and how they relate to Pivot Tables Third-party tools to download data to Excel Read more: http://archive.is/Ln8JJ Purchase ConversionXL (Fred Pike) - Excel For Marketers courses at here with PRICE $199 $43