Current Status Not Enrolled Price USD165 Get Started Take this Course Course Content Introduction Welcome Course Resource files OPENING AND PINNING FILES Shortcuts :File Management SHORTCUTS Shortcuts: Selecting data Adjusting column Widths Chapter Quiz 1 Quiz Expand Lesson Content Shortcut Keys – Quiz Formatting Text FORMATTING DATA Number Formats Date Formats Speedfill data Enter data using Flashfill FORMULAS AND FUNCTIONS Using Excel Basic Operators Evaluate Complex Formulas Formulas – Quiz 1 Quiz Expand Lesson Content Mathematical Formulas – Quiz Understanding Absolute values in Formulas Adding with Autosum Average Values Min Max and Count Functions Using Autosum for Subtotals and Grand Totals Calculating Loan Repayments 1 of 2 Related