Preserve cell formatting when dragging formulas - Microsoft Excel Tutorial

Contents

• Introduction Introduction

  • Level up your Excel skills

    43s
• 1. Excel Data Entry Tips 1. Excel Data Entry Tips

  • AUTOSUM function: Fastest methods for Calculations

    27s
  • Excel Flash Fill: Enter data in seconds

    1m 4s
  • (Locked)
    Convert CSV data to Excel data

    1m 6s
  • (Locked)
    Quickly fill data series in Excel

    1m 21s
  • (Locked)
    Edit multiple Excel sheets simultaneously

    52s
  • (Locked)
    How to make an Excel drop-down list

    1m 51s
  • (Locked)
    Quick Insert: Batch add rows and columns

    55s
  • (Locked)
    Text functions: Extract cell content efficiently

    2m 15s
  • (Locked)
    SUBTOTAL vs. SUM: Choosing the right function

    1m 16s
• 2. Working with Data in Excel 2. Working with Data in Excel

  • Transpose rows to columns in Excel

    1m
  • (Locked)
    Quickly update data with Find and Replace

    1m 21s
  • (Locked)
    Excel shortcut: Quickly fill gaps in data

    59s
  • (Locked)
    Convert Excel formulas to static values

    1m 1s
  • (Locked)
    How to lock cell references in Excel

    3m 30s
  • (Locked)
    Discover the Excel status bar superpower

    42s
  • (Locked)
    Filter Excel data by color

    36s
  • (Locked)
    Filter data by top and bottom values

    52s
  • (Locked)
    Remove duplicates in Excel

    1m 32s
  • (Locked)
    Import data from a picture in Excel

    1m
• 3. Navigating Excel 3. Navigating Excel

  • (Locked)
    Create and use bookmarks in Excel

    46s
  • (Locked)
    Customize the Quick Access Toolbar in Excel

    1m 6s
  • (Locked)
    Navigate fast through your workbook sheets

    31s
  • (Locked)
    Organize Excel Workbooks by hiding or unhiding sheets

    39s
  • (Locked)
    Transfer worksheet to another workbook

    58s
  • (Locked)
    Keyboard shortcuts: Move through data fast

    1m 7s
  • (Locked)
    Work across multiple windows in Excel

    30s
  • (Locked)
    Freeze panes: Lock rows and columns for easy data scrolling

    1m 31s
  • (Locked)
    Zoom and navigation: Control view settings in Excel

    42s
• 4. Data Formatting in Excel 4. Data Formatting in Excel

  • (Locked)
    Preserve cell formatting when dragging formulas

    25s
  • (Locked)
    Copy formatting easily with Format Painter

    58s
  • (Locked)
    Highlight key insights with conditional formatting

    2m 13s
• 5. Data Visualization with Excel Charts and Graphs 5. Data Visualization with Excel Charts and Graphs

  • (Locked)
    Use recommended charts for quick data visualization

    58s
  • (Locked)
    Create pie of pie charts

    1m 24s
  • (Locked)
    Add data labels to charts

    49s
  • (Locked)
    Combine data with combo charts in Excel

    1m 23s
  • (Locked)
    Add totals to column charts using combo charts

    2m 42s
  • (Locked)
    Identify key trends with mini-charts (Sparklines) in Excel

    1m 19s
• 6. Data Analysis in Excel 6. Data Analysis in Excel

  • (Locked)
    Analyze data with the Quick Analysis tool in Excel

    55s
  • (Locked)
    Structure data with Excel tables

    2m 16s
  • (Locked)
    Summarize data with recommended PivotTables

    1m 18s
  • (Locked)
    Insert slicer to tables

    1m 46s
  • (Locked)
    Add a timeline to PivotTables

    1m 28s
  • (Locked)
    Analyze data with PivotCharts

    1m 37s
  • (Locked)
    Analyze data with Excel Analyze feature

    1m 26s
• 7. Copilot in Excel 7. Copilot in Excel

  • (Locked)
    Write basic formulas with Copilot in Excel

    1m 40s
  • (Locked)
    Create a dashboard with Copilot in Excel

    1m 38s
  • (Locked)
    Match and combine lists with Copilot in Excel

    1m 45s
  • (Locked)
    Transform text data with Copilot in Excel

    1m 49s
  • (Locked)
    Conditional formatting: Use Copilot to highlight values

    2m 17s
  • (Locked)
    Generate quick data insights with Copilot in Excel

    2m 12s
• Conclusion Conclusion

  • (Locked)
    Next steps

    21s