Tutoriais do Excel

Treinar 2 ou mais pessoas?Experimentar DataCamp for Business

How to Highlight Duplicates in Excel

Explore how you can identify duplicate entries in Excel using Conditional Formatting, the COUNTIF() formula, and Power Query. Learn best practices and troubleshoot issues.

Laiba Siddiqui

13 de novembro de 2024

VLOOKUP() from Another Sheet: A How-to in Excel

See how to use VLOOKUP() to pull data from another sheet in your Excel workbook. Build confidence with practical examples and troubleshooting techniques.

Laiba Siddiqui

11 de novembro de 2024

How to Find P-Value in Excel: 3 Easy Methods

Learn how to find p-value in Excel using Excel functions like T.TEST() and Z.TEST(), by using the Data Analysis Toolpak, or through manual calculations. Equip yourself to make confident, data-backed decisions in Excel.

Jachimma Christian

31 de outubro de 2024

VBA Excel: How to Get Started and Make Your Work Easier

Learn how to effectively use VBA in Excel to automate tasks, create macros, and enhance your data processing skills with practical examples and best practices.

Laiba Siddiqui

7 de setembro de 2024

How to Use Goal Seek in Excel: A Guide with Real Examples

Simplify your data models with Excel’s Goal Seek, one of its powerful What-If Analysis tools. Solve real-world problems like loan payments and revenue targets.

Arunn Thevapalan

5 de setembro de 2024

How to Compare Two Columns in Excel: A Step-by-Step Guide

Learn how to compare two columns in Excel for matches and for duplicates using methods like the equals operator, IF() function, EXACT(), XLOOKUP(), and more.

Laiba Siddiqui

27 de fevereiro de 2026

Excel Substring Techniques: Extract and Format Text

Learn how to extract and format text position or delimiter using Excel substring functions, including LEFT(), RIGHT(), MID(), and more, with step-by-step instructions.

Laiba Siddiqui

29 de agosto de 2024

XLOOKUP() vs. VLOOKUP(): A Comparison for Excel Users

XLOOKUP() searches in any direction, defaults to exact matches, and has built-in error handling, while VLOOKUP() only searches right and needs manual column indexing.

Laiba Siddiqui

27 de agosto de 2024

How to Separate Names in Excel: 3 Easy Methods

Discover how to separate names in Excel with features like Text to Columns, Flash Fill, and custom-built formulas. Make your spreadsheets cleaner and easier to work with.

Laiba Siddiqui

26 de agosto de 2024

How to Do a VLOOKUP() with Multiple Criteria

Master the art of using VLOOKUP() with multiple criteria in Excel. Explore advanced techniques like helper columns and the CHOOSE() function.

Laiba Siddiqui

7 de agosto de 2024

How to Calculate Standard Deviation in Excel

To calculate standard deviation in Excel, enter your data into a range of cells and use either =STDEV.S() for sample data or =STDEV.P() for population data.

Arunn Thevapalan

23 de dezembro de 2025

How to Combine VLOOKUP() with IF() in Excel

Combine VLOOKUP() with IF() for efficient data analysis, including conditional lookups, error handling, and dynamic column indexing.

Laiba Siddiqui

18 de julho de 2024