Tags » Pivot Tables

T-Mobile #NetflixOnUs Social Media Case Study

by Benjamin Woodruff

Many large global companies are in a constant and sometimes bitter competition to win the greatest market share in their respective fields of operation. 4,228 more words

Case Study

Pivot tables 101: How to construct a pivot table and how NOT to construct one.

Many people who do not regard themselves as Excel gurus find themselves in situations where they would like to be able to represent tabular data somehow to allow them the functionality of filtering, cross-tabulation (pivoting) and hierarchical sorting that pivot tables offer. 636 more words

Power Pivot

Python Pivot Tables

Just like in Excel, we can do Pivot Tables in Pandas as well. This is a very convenient feature when it comes to data summarizing. Let’s look at an example-

Cheers!

Data Science

Using AUTOFILL in Excel - Part 2

(click here for Part 1)

Paste Formulas

Another way that you can autofill a formula across multiple cells is to Paste Formulas.

Here we have a projected amount of sales of $5,000 per day along with the actual total sales for that day. 100 more words

Excel

Using AUTOFILL in Excel - Part 1

The Autofill button is one of the simplest, yet greatest tools in Excel. There are a variety of different ways to use the autofill feature depending on how you are using your data. 342 more words

Excel

DATE - Excel Function

What it does: The DATE() formula returns the serial number that represents a particular date.

Plain English: This formula returns the serial number of the year, month, and date provided. 24 more words

Excel

REPT - Excel Function

What it does: The REPT() function repeats text a given number of times.

Plain English: This function repeats text a given number of times so that you don’t have to. 38 more words

Excel