If you work in design, illustration, video, or any creative discipline, you probably think Excel isn't for you. However, A simple spreadsheet can become your best ally for organizing projects, budgets, timelines, and clients.The key lies not only in the pretty tables, but in the formulas that turn that data into useful information.
Excel is much more than adding numbers. It is an analysis, planning and control tool that, when used correctly, saves you hours of repetitive work.You don't need to memorize hundreds of functions: by mastering a handful of essential formulas you can create professional templates, automate parts of your workflow and make better decisions in your creative projects.
Why Excel is a key tool for designers and creatives
For many people, Excel is just a grid where they jot something down from time to time.But for those who manage projects, teams, or budgets, it's practically a Swiss Army knife. In creative studios, agencies, marketing departments, and among freelancers, it's used daily to monitor everything from the status of projects to the profitability of each client.
With Excel you can extract data and convert it into graphs to detect trends, problems, or workload spikes. You can also gather information scattered across various files or sources (briefings, timesheets, invoices, resource lists) and centralize it into a single, well-structured document.
The true heart of all this is the formulas and functionsThanks to these functions, you can organize information, perform complex calculations, filter relevant data, and see patterns that would otherwise go unnoticed. The problem is that, for beginners, these functions are often the major barrier between simply opening Excel and truly leveraging its capabilities.
Furthermore, You don't need to know the more than 400 functions that Excel includes.The important thing is to master a small but very powerful set of functions and understand how to combine them effectively. For the rest, you can use Excel's built-in Function Wizard, which helps you find the right formula, and autocomplete, which suggests functions and structures as you type.
This guide assumes that You already have the basics down.Opening a new workbook, navigating between worksheets, entering data into cells, changing formatting, and little else. If you're still struggling with that, it's best to familiarize yourself with the basics of Excel first. Ideally, use Excel 2013 or a later version (including Microsoft 365), where all the functions we'll cover are available or have modern equivalents.
Basic operations that every creative person should master
Before getting into more advanced features, it's important to understand the basics: simple mathematical operationsThey are the starting point for almost any spreadsheet, from a budget to a timesheet.
In Excel, The sum is a function as suchSubtraction, multiplication, and division are performed using operators, while subtraction, multiplication, and division are performed using operators. Mastering these four pillars will allow you to build longer formulas with confidence.
Sums With the SUM function, which accepts both individual cells and entire ranges. For example, if you want to know the total amount of a project by adding the items in column A, you would use something like: =SUM(A1:A50). This gives you the total costs of printing, licenses, fees, etc., in an instant.
To subtract You don't need a specific function; simply use the minus sign between cells or values: =A2-A3. This can be useful, for example, to calculate the difference between the approved budget and the actual cost of a job.
Brianda multiplicationsExcel uses the asterisk: =A1*A3*A5*A8. It is very useful for calculating amounts based on units and rates, such as hours worked per hourly rate or printed copies per unit cost.
For divisionsThe slash bar is used: =A2/C2. This operation is key to finding ratios, such as the average cost per designed part or the average billable hourly price in a specific project.
Note that Excel respects standard mathematical order.First multiplication and division, then addition and subtraction. If you want to change that order, use parentheses. For example, in a formula like =(A1+C2)*C7/10+(D2-D1), you control exactly what is calculated first and avoid misleading results.
Functions for analyzing data: averages, maximums, and minimums
Once you've mastered the basic operations, it's time to move on to functions that allow you to summarize informationAverages, highest and lowest values. They are perfect for analyzing campaign results, delivery times, or project costs.
The function AVERAGE Calculates the arithmetic mean of a group of cells. Its structure is very simple: =AVERAGE(range). If, for example, you have recorded the hours spent on different projects in a row, with =AVERAGE(A2:B2) you can find out how many hours you usually spend on a particular type of project, which is very useful for refining budgets and deadlines.
If you're interested in knowing the price higher For a series of data (for example, the day with the most visits to your portfolio or the campaign with the highest investment), the appropriate function is MAX: =MAX(cells). You can use entire ranges, such as =MAX(A2:C8), or mix cells and individual numbers.
In addition, MIN It tells you the lowest value: =MIN(cells). This helps you identify your cheapest project, the month with the lowest revenue, or the worst-performing campaign, which will help you determine which types of jobs might not be worth accepting.
Error handling in formulas: IFERROR
When you start chaining together more complex formulas, it's very common to see messages like #DIV/0! or similar. These errors not only detract from the spreadsheet's appearance, but can also trigger a cascade of errors if other formulas depend on them.
To prevent this, Excel includes the function YES.ERRORThis function lets you control what is displayed when a formula returns an error. Its general structure is: =IFERROR(operation; value_if_error). That is, first you enter the formula you want to evaluate, and then you specify what to display if something goes wrong.
Imagine you divide a maximum value by a minimum value taken from a range, and that minimum could be zero or nonexistent. You could use something like: =IFERROR(MAX(A2:A3)/MIN(C3:F9),"There has been an error"). If everything goes well, you will see the result of the calculation.Otherwise, the cell will display the custom message you wrote.
Conditions and decisions: the IF function
The function SI It is probably one of Excel's most powerful and versatile tools. It allows you to make automatic decisions depending on whether or not a specific condition is met.
Its basic structure is: =IF(condition; value_if_true; value_if_not_true). This condition can be a comparison of text, numbers, dates, or even another formula. For example, you can make a project table display "DELIVERED" if the date has already passed and "PENDING" if it is still pending.
A typical example applied to location data would be: =IF(B2="Madrid", "Spain", "Other country"). Here, if cell B2 contains exactly the text “Madrid”Excel will return "Spain"; otherwise, it will show "Other country". This is very useful for classifying customers by origin, filtering campaigns by market, or segmenting results.
By combining several IF functions or nesting them with other formulas, you can create quite elaborate rules, such as marking unprofitable projects in red, highlighting late deliveries, or assigning labels according to the type of client.
Counting and summing with criteria: COUNTA, COUNTIF, and SUMIF
Another family of key functions for designers and creatives are those that They count or add up data under certain conditions.They are ideal for tracking tasks, clients, and produced parts without having to filter manually.
The function WILL COUNT Counts how many cells in a range are not empty, regardless of whether they contain numbers or text. For example, =COUNTA(A:A) tells you how many entries are in a column of projects, client lists, or creative references, ignoring empty cells.
If you want to go a step further and count only the cells that meet a criterionThen COUNTIF comes into play. Its structure is: =COUNTIF(range; criteria). A typical example would be: =COUNTIF(C2:C;"Pepe"), which would count how many times a specific name appears in a column of managers, authors, or contacts.
For conditional sums, the key formula is ADD IFIt works similarly to COUNTIF, but instead of counting rows, it sums the values in another associated column. The general syntax is: =SUMIF(criteria_range, criteria, sum_range).
For example, in a table where column B indicates the client's city and column C the project amount, you could use: =SUMIF(B2:B50,"Madrid",C2:C50). This formula will only add the amounts from C when the city in B is “Madrid”This allows you to see at a glance how much you have billed to a specific geographical area.
Random numbers for quick decisions: RANDBETWEEN
It may seem anecdotal, but in creative environments the function RANDOM.BETWEEN It can be very useful. It's good for generate a random integer between two valuesFor example, to randomly choose who presents a project, decide which concept to explore first, or draw a prize among workshop attendees.
Its structure is: =RANDBETWEEN(lower_number;upper_number). A simple example would be: =RANDBETWEEN(1;10). Every time the sheet is recalculated (for example, when modifying any cell), the generated value will changeIt's a quick way to introduce controlled randomness into internal selections.
Date management: DAYS, NOW and WEEKDAY
Deadlines are a classic headache when managing creative projects, especially if there are many milestones, partial deliveries, and revisions. Excel includes several functions that make it easier. working with calendars and deadlines.
The function DAYS This function indicates the number of days between two dates. Its structure is: =DAYS(end_date;start_date). You can use dates typed directly, like "2/2/2018", or reference cells, as in =DAYS("2/2/2018",B2). It's perfect for calculating the actual duration of a project from the briefing to delivery, or the time remaining until a deadline.
With NOW You get the current system date and time: =NOW(). It requires no parameters. This function updates automatically every time formulas are recalculated or the file is reopened, and it allows you to mark the present moment in monitoring controls, logs, or change records.
The function DAYSEM It returns the day of the week from a date in numeric format. Its basic structure is: =WEEKDAY(date;account_type). The second parameter defines how the days are numbered, and there is a good variety of options to accommodate different formats.
Among the most commonly used types, you can find:
- 1: numbers from 1 (Sunday) to 7 (Saturday)
- 2: numbers from 1 (Monday) to 7 (Sunday)
- 3: numbers from 0 (Monday) to 6 (Sunday)
- 11: From the 1st (Monday) to the 7th (Sunday)
- 12: From the 1st (Tuesday) to the 7th (Monday)
- 13: From the 1st (Wednesday) to the 7th (Tuesday)
- 14: From the 1st (Thursday) to the 7th (Wednesday)
- 15: From the 1st (Friday) to the 7th (Thursday)
- 16: From the 1st (Saturday) to the 7th (Friday)
- 17: From the 1st (Sunday) to the 7th (Saturday)
So, something like =WEEKDAY(NOW();2) will tell you what day of the week it is, numbering from Monday as 1. This can help you organize deliveries according to working days or create templates where certain tasks are only activated on certain days.
Links and table reorganization: HYPERLINK and TRANSPOSE
In many creative workflows you will work with multiple external tools and resourcesCloud folders, online portfolios, material repositories, etc. Integrating these links into your Excel spreadsheets greatly improves navigability.
The function Hyperlink It allows you to turn any cell into a clickable link with any text you want. Its structure is: =HYPERLINK(address;link_text). For example: =HYPERLINK("http://www.google.com";"Visit Google"). This way, in a project table, you can have a column linking to the Figma mockup, the final file in the cloud, or the asset repository.
On the other hand, when you work with data imported from other sources or with structures that don't suit you, the function TRANSPOSE She's your best friend. She's useful for Convert rows to columns and columns to rowsIt is an array function, which means it is applied over an entire range of cells.
For this to work, you must select a destination range whose dimensions are the inverse of the original table. If your original table has 2 rows and 4 columns, the range where you apply TRANSPOSE must have 4 rows and 2 columns. Then you type something like {=TRANSPOSE(A1:C20)} and confirm it as an array formula (in older versions, with Ctrl+Shift+Enter). This is especially useful for reorganizing imported data or adapt lists to the structure that best suits you.
Text functions for cleaning and combining information
In design and creativity, it's not all about numbers. You often work with client names, project titles, tags, and descriptions. Excel includes several text functions that help you with this. clean, combine, and search for information within text strings.
The function REPLACE It allows you to replace part of a text with another, specifying the position and how many characters you want to remove. Its structure is: =REPLACE(original_text;start_position;number_of_characters;new_text). For example: =REPLACE("Merry Christmas",6;8;"Hanukkah"). Here, The new text will be inserted in position 6, deleting 8 characters from there..
If you want to join several text fragments, the classic function is CONCATENATEIt's used to combine values from different cells into a single string, useful for generating file names, project codes, or automatic descriptions. Its structure is: =CONCATENATE(cell1;cell2;cell3;…). An example: =CONCATENATE(A1;A2;A5;B9). Keep in mind that It does not accept full ranges as a parameterbut individual cells separated by semicolons.
When you copy and paste data from other sources (emails, PDFs, websites), it's very common for errors to creep in. extra spaces at the beginning, middle, or endThe TRIM function solves this: =TRIM(cell_or_text). For example, =TRIM(F3) will return the text from F3 without extra spaces. This is key to avoiding errors in searches or comparisons of text that appear identical but have invisible gaps.
Finally, the function DISCOVER MORE It helps you locate one text within another. Its syntax is: =FIND(search_text;original_text). If it finds it, it returns the position of the first match; otherwise, it returns an error. For example: =FIND("needle";"haystack"). This would give an error, but combined with IFERROR you can handle these cases without filling up the spreadsheet with unsightly messages.
Advanced table search: VLOOKUP and XLOOKUP
When your spreadsheets start to fill up with data, it becomes essential have features that automatically search for informationThat's where VLOOKUP and its more modern version, XLOOKUP, come into play.
VLOOKUP It's one of the most popular functions among intermediate users. It allows you to search for a value in the first column of a table and return the content of another column in the same row. In practice, this means you can enter a product code, a project ID, or a customer's name and instantly get their rate, status, or any other associated data.
Its basic structure is: =VLOOKUP(lookup_value, table_range, column_number, [range_lookup]). A typical example would be: =VLOOKUP(A2, B2:D100, 3, FALSE). Here, Excel will look up the value in cell A2 in the first column of the range B2:D100 and return the data from the third column of that range. Using FALSE indicates that you want an exact match, which is most common when working with precise identifiers or names.
SEARCHX It's the modern evolution available in Microsoft 365 and recent versions. It's more flexible, allowing you to search both left and right across columns, work with more intuitive ranges, and better handle cases where the value isn't found. Although we're focusing on VLOOKUP here because it's the classic function, it's recommended that you also use XLOOKUP if you have access to it. start using it in your new templates because it simplifies many complex searches.
Applied to creative work, these functions are perfect for creating databases of resources, clients, fonts, color palettes, or templates where, when selecting a code or a name, the rest of the related data (price, permitted use, purchase date, download link, etc.) is automatically filled in.
Taken together, all these formulas make Excel much more powerful than a simple table. They allow you to automate tasks, reduce errors, analyze your creative activity, and professionalize your management Without needing to become an accountant or a programmer. With a small initial effort to understand and practice them, you'll gain agility, clarity, and control over your projects, your time, and your money.