6 Truques ESCONDIDOS do Excel (+Bônus)

Introduction

This tutorial will guide you through six hidden tricks in Excel that can significantly enhance your productivity and efficiency. Whether you're a beginner or looking to advance your skills, these tips will help you work smarter in Excel.

Step 1: Converting Measurements

To quickly convert measurements in Excel, you can use built-in functions or create a conversion table.

• Using Functions:

  • Use the CONVERT function to change units, such as:

    =CONVERT(number, from_unit, to_unit)
    

  • Example: To convert 10 meters to feet:

    =CONVERT(10, "m", "ft")
    

• Creating a Conversion Table:

  • Create a table with units and their conversion factors.
  • Use VLOOKUP to reference this table for conversions.

Step 2: Changing Date Formats

You can easily switch between American and Brazilian date formats.

• Using TEXT Function:

  • To convert a date to Brazilian format:

    =TEXT(A1, "DD/MM/YYYY")
    

  • To convert a date to American format:

    =TEXT(A1, "MM/DD/YYYY")
    

• Formatting Cells:

  • Right-click the cell, choose Format Cells, and select Date.
  • Pick the desired format from the list.

Step 3: Quick Data Entry using AutoFill

Utilize the AutoFill feature to save time on repetitive tasks.

• How to Use AutoFill:
  • Enter the first value in a cell.
  • Click and drag the fill handle (small square at the cell's bottom right corner) to extend the series.
  • Excel automatically fills in the series based on the pattern detected.

Step 4: Using Conditional Formatting for Better Insights

Make your data visually impactful with Conditional Formatting.

• Applying Conditional Formatting:
  • Select the range of cells.
  • Go to Home > Conditional Formatting.
  • Choose a rule type (e.g., Highlight Cells Rules, Data Bars).
  • Set your conditions (e.g., greater than, less than).

Step 5: Hiding Rows and Columns

To keep your spreadsheet organized, you can easily hide rows or columns.

• Hiding Rows/Columns:
  • Right-click the row number or column letter.
  • Select “Hide” from the context menu.
  • To unhide, select the rows or columns adjacent to the hidden ones, right-click, and choose “Unhide.”

Step 6: Creating Dynamic Charts

Dynamic charts can update automatically as your data changes.

• Steps to Create a Dynamic Chart:
  • Create a table for your data.
  • Insert a chart based on this table.
  • Use Excel’s Table feature (Insert > Table) to ensure the chart updates as you add data.

Conclusion

By incorporating these six hidden tricks into your Excel routine, you can enhance your productivity and efficiency. Experiment with these techniques and see how they can streamline your workflow. For more advanced features, consider exploring additional resources or courses on Excel. Happy Excel-ing!