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…
LinkedIn Learning (Lynda.com) is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- Converting Google Sheets to Excel format
- Working anywhere with Excel Online
- Working with sheets
- Creating an Excel table
- Applying conditional formatting
- Working with formulas
- Working with charts and sparklines
- Sharing files and collaborating with others
- Reviewing and tracking changes