Hi all!
Nice to be a part of the community!
I am working as an SEO consultant for a Swedish Internet marketing company. Up until now, I have mainly used Excel for smaller stuff but I have decided to start using it much more.
This is a pretty good guide for how SEO'ers work with Excel and what I want to get a better understanding of.
I have read and done the lessons from about 50 % of the book "Slaying Excel Dragons" but I am not sure if that is the right source for me to learn.
Is there any other books or sources you guys would recommend?
Thanks a lot
Nice to be a part of the community!
I am working as an SEO consultant for a Swedish Internet marketing company. Up until now, I have mainly used Excel for smaller stuff but I have decided to start using it much more.
This is a pretty good guide for how SEO'ers work with Excel and what I want to get a better understanding of.
- Introduction
- Lesson 1 – Basic Tasks
- CONCATENATE
- Text To Columns
- COUNTIF
- IFERROR
- Tip: Using Tables
- Lesson 2 – More Functions
- LEN
- SEARCH/FIND
- Tip: Nested Formulas
- LEFT, RIGHT, & MID
- Tip: Time Saving Paste Special
- Lesson 3 – IF, AND, & OR
- IF
- OR/AND
- Tip: Killer Keyboard Shortcuts
- Lesson 4 – VLOOKUP, OFFSET, & INDEX/MATCH
- VLOOKUP
- OFFSET
- INDEX/MATCH
- Tip: Excellent Analytics
- Lesson 5 – Pivot Tables
I have read and done the lessons from about 50 % of the book "Slaying Excel Dragons" but I am not sure if that is the right source for me to learn.
Is there any other books or sources you guys would recommend?
Thanks a lot
