Course info

The following reference materials were provided as context. Use them as guidance only -- always prefer the latest, most current information over any potentially outdated content in these files. --- Reference: Excel 365 Introduction Outline.txt --- 1. Getting Started Signing in with a Microsoft Account Understanding Excel 365 Online vs. Desktop (brief overview) Starting Excel Opening a Workbook Understanding the Excel 365 Interface Exploring the File Tab/Backstage View Working with the Quick Access Toolbar Working with the Status Bar Using Excel Help Getting Help with Copilot (365) 2. Entering Data Moving the Cell Pointer Selecting a Range of Cells Creating a New Workbook Inserting, Renaming, and Deleting Worksheets Saving a Workbook Entering Constant Values Using Auto Fill to Enter Data Entering Dates, Numbers, and Text Editing Cell Contents Clearing Cell Contents Working with Undo and Redo Closing a Workbook 3. Using Formulas Understanding Formulas vs. Functions Entering Basic Formulas Using Auto Fill with Formulas Using the SUM Function Automatically Summing Columns and Rows Using Basic Functions (AVERAGE, COUNT, MAX, MIN) Working with the Range Finder Using Formula Error Checking Copying and Pasting Formulas Cutting and Pasting Formulas 4. Formatting Worksheets Formatting with Font Group Options Working with Alignment Group Options Applying Number Group Options Changing Column Width Changing Row Height Inserting and Deleting Columns or Rows 5. Editing Workbooks Working with AutoCorrect Checking Spelling Using Find and Replace Inserting Notes 6. Printing Worksheets Using Print Preview Working with Print Settings Using the Page Setup Dialog Box Printing a Worksheet 7. Collaborating in Excel 365 Saving to OneDrive or SharePoint for Collaboration Sharing Workbooks with Others Real-Time Co-Authoring Viewing Presence Indicators Version History Overview Using Comments for Conversations