Learn Excel

Excel Data Analysis with Statistics

In this article, we are going to look at how Data Analysis with Statistics can be done efficiently through the use of Microsoft Excel.

Laurie Ulrich

Basic Excel Calculations and Order of Operations

Calculations. Let's take a look at how you can perform very simple calculations in Excel.

Paste Special: Excel Skills with Key Techniques

Paste Special. In this section, we will use Paste Special to apply formats as well as perform calculations on selected cells.

Date Analysis with Pivot Tables: Grouping and Timelines

Pivot Tables, Grouping, and Timelines. In this section, we'll look at how Pivot Tables make it really easy for you to work with dates in your dataset.

Joining Text in Excel: Using Concatenate and Ampersand

Joining Text. In this section, we're going to take a look at joining text.

Conditional SUMPRODUCT for Data Analysis in Excel

Conditional SumProduct. Using SumProduct with conditions to exclude data that does not meet a certain criterion.

HLOOKUP: Mastering Horizontal Data Searches

HLOOKUP. HLOOKUP is exactly like VLOOKUP except for two things.

Absolute Cell References in Excel Calculations

Absolute cell references. Absolute cell references are very important in Excel when you're working with calculations where you have multiple values and a...

Excel's User Interface: Key Features Explained

The Microsoft Excel User Interface. We're going to start this particular video off by talking about the Quick Access Toolbar.

Excel's True-False Comparisons for Data Analysis

The true/false statement. What does the true/false statement do?

Data Organization: Sorting, Filtering, and Subtotals in Excel

Sort and Filter. We will use Sort and Filter to find and organize data in large databases.

Mixed Cell References in Excel Formulas

Advanced cell locking. Create powerful formulas by locking either the column or the row or both.

Combining & Filtering Data from Multiple Worksheets

Learn how to combine data from two different sources with varying column arrangements and use formulas to filter and manipulate the data to achieve desired...

Cell Referencing

Improve your understanding of Excel's cell referencing system, including the use and implications of absolute and mixed cell references and how they impact...

Working with Shapes in Excel

Dive into the intricacies of shape manipulation in digital drawing, from rotating and formatting shapes to working with Z-order and altering points, providing...

Creating Grand Totals in Excel

Explore various formulas to calculate the grand total in an Excel worksheet, discussing alternative methods, the potential for errors, and the optimal solution.

Filtering Data in Excel

Discover the various ways to filter data in Excel and utilize this feature to efficiently organize and analyze your datasets.

Conditional Formatting in Excel

Explore the wide-ranging capabilities of Excel's conditional formatting, including the ability to format cells based on specific conditions, highlight cells...

Data Validation in Excel

Explore how to use data validation to set restrictions on cell entries, alert users, and prevent incorrect values from entering your data cells, with examples...

Number Formatting in Excel

Explore the different ways to effectively format numbers in Excel, including shortcuts, custom categories, and understanding the use of individual characters.