You probably even get chills when you hear "Excel", right? But don't worry, you already have the Excel tutorial you've always dreamed of!
We know that the vast majority of professionals are also wary of using spreadsheets. They really seem very complicated with their indecipherable formulas and complex functions.
Especially for marketing professionals who are not familiar whatsapp number philippines with this tool, I am going to show you why Excel — and its similar version, Google Spreadsheets — are fantastic tools.
I'm also going to teach you how to use them and take your analytical skills to the next level.
Excel Tutorial: The Logic of a Spreadsheet
When you open Excel, you are faced with an unfriendly interface. In the end, it is a very different interface from the ones we are used to, for example, this blog you are reading now and those of Word.
But don't worry, because using Excel is much simpler than it seems. In a spreadsheet, the basic block of information is called a cell. Each cell contains a piece of information, which can be a date, a number, a percentage, formulas, and other options.
The cell is part of a sheet and each worksheet can be composed of several sheets, each with its own purpose and its own range of cells.
So our hierarchy is:
File (name.xls or name.xlsx) > Sheet > Cell.
It's a pretty simple hierarchy, which governs any data set you're calculating.
A practical example:
Spreadsheet: Marketing Investments
A sheet: August
Cell: AdWords Investments.
This makes it easier to understand, right?
How to navigate a spreadsheet
When working with spreadsheets, you can reference (or look up) cell information in other places to perform calculations, comparisons, or other operations. Each cell thus has a unique "address" in its own sheet.
That address is composed of a coordinate, which contains its row (the vertical dimension) and its column (its horizontal orientation).