marketing

I have the following three columns of data in Power Query that looks like this: Category...……….Month...……..............Amount Sales...…………….Jan Actual...……………......$100 Sales...…………….Jan Budget...................$90 Sales................Feb Actual....................$200...

Hi experts, for reporting on e-commerce data I am preparing daily, weekly and monthly reports. The data sits in different databases (Oracle, Google Analytics and numerous third partner platforms). The KPIs needed are: order count, revenue, cost, clicks, impressions. Is there a way to automate...

Hi I have a table like the one below. I inserted a table then I inserted Slicer for age. So I can use the slicer to filter. My question, can I group age into group like this 18-30 31-50 51-65 So the slicer can show only 3 groups only. I know that can be done in Pivot table but can it be done...

HI Guys i have the data below <colgroup><col span="2"><col><col></colgroup><tbody> group ID Department products A 1 sales pc A 2 marketing pc A 3 marketing ons A 4 HR pc A 5 marketing tons A 6 marketing pc B 7 sales pc </tbody> I want to do a count if , using this logic...

I am trying to help a friend and I am confused by the results. In a separate column called "Avatar", they want to identify the role of each individual based on their title. For instance, if the title has the word SALES in it, they want the avatar to be SALES, if the title has the word MARKETING...

Hi there - I'm working with a data set that is in a less than friendly format. I'm trying to turn this data set into a more user friendly format for querying and pivot tables. Here's how the data is currently structured: <tbody> Business Entity Control1 Control2 Control3 Control4 Control5...

Hi, Ive been working on a a dynamic INDEX / MATCH, which I've sovled. How ever the values I'm returning on not always unique, and I want to lookup other values from the same column/row. <!--[if !mso]><style>v\:* {behavior:url(#default#VML);}o\:* {behavior:url(#default#VML);}x\:*...

Hi I have a file called AllEmployees.xlsx which has one sheet called ALL and inside that sheet an empty table with only labels as below. I have 3 other excel files sales.xlsx, marketing.xlsx and hr.xlsx, each file has one sheet (sales, marketing, hr) and each one has one table as below. I want...

Please help A1 has the list has specialisation ( From a data validation list ) B1 has the semester no. ( 1 to 6) Now from Cells c1 to j1 the values should change based on the value of cells a1 and b1 like if the specialisation is marketing Management and semester number is 1 cell c1 till cell...

hi there I'm new to Power Pivot but trying to learn as much as possible for a project. Using Office 365/2016 and Windows 10. In my file, I have two imported Excel files (let's call them Sales and Marketing) and among other items, each contains a client list and entries of time spent on that...

Hi Everyone, I am trying to create a tool for an email marketing campaign. I was able to make codes that will send an email to a distro based on the customer type with an opt in option. Everything was working fine until my boss asked to add objects depending on the email campaign that has...

Hello. This is a bit off topic of Excel other than I'm using the program, but I'm presuming a lot of people on here are in marketing and do similar things so looking for some advice. If anyone knows of a marketing / data forum where this stuff is commonly discussed please let me know as I could...

Afternoon all - I'm throwing my hat in the ring as an Excel developer and consultant and am wondering if anyone can give me advice on putting together printed marketing materials. I'll put together a website at some point, but for now I'd like to visit businesses in person and drop off...