Utilizing Formulas in Microsoft® Excel®
1 hour 5 minutes
Learn how to unlock powerful Excel® formulas and features.
This course provides a keen understanding of creating formulas and using the built-in functions for analysis and effective spreadsheet results. Expand your analytical capabilities and add a whole new level of depth and analysis to your worksheets.
Learn how to perform calculations, return information, or manipulate the contents of other cells. Even if you already know how to apply basic formulas, you’ll discover how to structure your formulas, including mathematical, textual, and logical, to get more out of Microsoft Excel.
• You will be able to define the must-know Excel formulas.
• You will be able to describe how to quickly access the built-in library of functions.
• You will be able to explain troubleshooting techniques when formulas don’t work.
• You will be able to identify the order in which Excel performs operations in formulas and nested functions.