Filters let you view only the data that you want to see. Pivot tables are a great way to summarize large amounts of data and sort it. You could create a macro that automatically inserts the current date when you open a workbook or a macro that automatically saves and closes your files. Macros are small programs that you can create to automate tasks in Excel. Formulas are one of the most powerful features in Excel, but they can take some time to learn.

Memorize the most common and useful formulas.

You could use data validation to ensure cells only contain numbers-or only dates.

Use data validation to ensure your sheet includes the right data types.

You could use conditional formatting to highlight all cells that contain a value greater than 10. Conditional formatting allows you to highlight cells that meet specific criteria.

Use conditional formatting to increase the readability of your sheet.

If you have a list of months, you can use AutoFill to fill in the days of the month automatically. The AutoFill feature in Excel is handy for filling in a data series.

Use the AutoFill feature when filling in similar values.

Pressing CTRL+C will copy the selected cells, while CTRL+V will paste them. Keyboard shortcuts can save you a lot of time working in Excel. Used to show relationships between data points.įinally, here are a few tips and tricks to help you work faster in Excel. Used to compare data points side-by-side. These advanced Excel functions can be a little more difficult to use-but they’re sophisticated methods of processing and analyzing data.

You can also use DAY(), MONTH(), and YEAR(). Similar to now, but this just gives the date, rather than the date and time. Note that it will return the time of the system you’re on. Return the number of characters in a string, useful for data validation.

Round a number down to the first number of significance, e.g. Round a number up to the first number of significance, e.g. Example: MAX(A1:O1)įormats text with the correct capitalization useful when importing data from other sources. Example: MIN(A1:O1)įinds the maximum value of a set. Example: VALUE(B1)įinds the minimum value of a set. Example: CONCATENATE(A1, B1)Ĭonvert numbers that have been stored in text to integers. Example: TRIM(A1)Ĭhecks whether a condition is met and returns one value if true and another if false Example: IF(A1=‘Yes’, True, False)Ĭombines the values of multiple cells into a single cell. Removes all white space from the front and back of a cell. Example: SUMIFS(A1:A4,B1:B4,E1)Ĭalculates the average values in a range of cells Example: AVERAGE(A1:A4)Ĭounts the number of cells in a range that contains numbers Example: COUNT(A1:A4)įinds the smallest value in a range of cells Example: MIN(A1:A4)įinds the largest value in a range of cells Example: MAX(A1:A4) Adds the values of a range of cells Example: SUM(A1:A4)

Macronutrients cheat sheet