In this video, staff author Jess Stratton shows users how to work with Excel formulas, including how to enter them, find existing functions, display all formulas, and trace a single cell's value.
- [Tutor] Let's talk about formulas in Excel.…I'm not going to go over how to use formulas…as we have extensive videos on that,…but I do want to show you how to work with them in Excel…versus what you were used to in Google Sheets.…Formulas can be far more robust in Excel,…so I'll show you some neat things…that you can do to help you navigate…a complicated sheet or get your work done faster.…Like Google Sheets,…Excel has built-in functions.…To find those functions,…change to the Formulas ribbon tab.…These functions exist across all datatypes…to calculate a final value.…
In fact you can use these functions…to create your own formulas.…If you're looking for something in particular,…Excel does a great job of categorizing them.…So as long as you know what type of operation…you're trying to do,…you can know where to go find it.…You can scroll through the list…and if you hover your mouse over each function,…it's going to tell you what it does…and what the parameters are for you to enter in the cell.…Formulas in Excel start the same way…
- Identify which option allows you to download all of your Google files at once.
- Explain what happens when you double-click the border on the right side of a column.
- List the formula that will copy the contents of one cell into the current cell.
- Identify the location where an excel file needs to be stored to work on it simultaneously with another user.