Digital Designer

June 11, 2020

## Introduction

Ahh, Excel – it’s either you love it or hate it. Some people like things in order and the grids help you do just that. However, on the other hand, some people are quite confused if whether or not Excel can actually help with productivity. There are tonnes of Excel commands that can dramatically increase functionality and speed of your workflow, and if you’re not using any of those formulas and functions, you’re missing out on the vast potential of its application. However, we get it, that working with Excel can be frustrating at times, especially when it comes to finding the right commands.

What we’re trying to say here is – you don’t need to be an Excel expert, but if you’re looking to be one, or just simply want to be more effective we’re encouraging you to take a shortcut and use our Excel Formula Cheat Sheet below!

And by the way, if you’re interested in digital marketing service, or would like to join the team, drop us an email at [email protected]

## EXCEL FORMULA CHEAT SHEET

This cheat sheet highlights some of the most useful Excel formula for both Windows and Mac users

###### DATE

eg =DATE(year,month,day)

Returns a number that represents the date (yyyy/mm/dd) in Excel

###### TODAY

eg =DATE(year,month,day)

Insert and display today’s date in a cell

###### MONTH

eg  =MONTH(A1)

Extracts and displays the month from a date (e.g., 7/18/2018 to 7)

###### YEAR

eg =YEAR(A1)

Extracts and displays the year from a date (e.g., 7/18/2018 to 2018)

###### NOW

eg =NOW()

Returns the current date and time

###### TIME

eg =TIME(hour,minute,sec)

Create a time with hours, minutes, and seconds

###### VLOOKUP

eg =VLOOKUP(value, table,col_index, [range_lookup])

A lookup function that searches vertically in a table

###### HLOOKUP

eg =HLOOKUP(value, table,row_index, [range_lookup])

A lookup function that searches horizontally in a table

###### INDEX

eg =INDEX(array, row_num,[col_num], [area_num])

A lookup function that searches vertically and horizontally in a table

###### MATCH

eg =MATCH (lookup_value,
lookup_array, [match_type])

Returns the position of a value in a series

###### UPPER

eg =UPEPR(B5)

Converts all characters in text string to upper case

###### LOWER

eg =LOWER(B5)

Converts all characters in text string to lower case

###### PROPER

eg =PROPER(B5)

Converts all characters in text string to proper case

###### FIND

eg =FIND(A1,B5)

Returns starting position of sub string within another string

###### TRIM

eg =TRIM(B5)

Removes duplicate spaces at the start and end of a text string

###### VALUE

eg =VALUE(B5)

Convert a text value into number

###### SUM

eg=SUM(A1:B5)

Add the total of a series of numbers

###### AVERAGE

eg=AVERAGE(A1:B5)

Calculates the average of a series of numbers

###### MEDIAN

eg=MEDIAN(A1:B5)

Returns the median average number of a series

###### COUNT

eg=COUNT(A1:B5)

Counts the number of cells in a range that have numbers in them

###### PRODUCT

eg=PRODUCT(A1:B5)

Multiplies all of a series of numbers

###### ROUND

eg=ROUND(A1:B5)

Returns a number rounded to a given number of digits

Digital Designer