Blogs about: Pivot Table

Featured Blog

Un-pivot Excel

Insight is Wonderful wrote 5 days ago: From http://superuser.com/questions/78439/is-it-possible-to-unpivot-or-reverse-pivot-in-excel Sub un … more →

Tags: Business Intelligence, Tools, Microsoft Excel, Excel, spreadsheet, PowerPivot

Build your spreadsheets right!

Telmo Silva wrote 5 days ago: At ClicData we are working hard to make sure we can connect to any and all data sources and any type … more →

Tags: Business Intelligence, ClicData, Excel, Fact, Layout, load, Loading Data, Table, transactional

Pivot Table & National Volunteering Month

spreadsheetsolving wrote 1 month ago: April is National Volunteering Month, so let’s celebrate!  What better way is there to ce … more →

Tags: Charts, Data Analysis, Spreadsheet Solving, SpreadsheetSolving.com, www.spreadsheetsolving.com, Volunteering

Pivot Table

prernasinghal wrote 1 month ago: Spreadsheet feature that allows data tables to be rearranged in many ways for different views of the … more →

Tags: business terms, business term, business terms, MBA

MS Excel PivotTable Deleted Items Remain

zbarresse wrote 2 months ago: By Zack Barresse   PivotTable’s are a wonderful thing, but they have their downsides. One of t … more →

Tags: Excel, Slicers, PivotTable

The Job Interview #70

tobbetto wrote 2 months ago: … more →

Tags: the job interview, Job, Interview, Excel

Learn Excel from MrExcel - "Roulette Analysis": Podcast #1661

MrExcel East wrote 2 months ago: Conrad says that some numbers are more popular than others – it’s not completely random. … more →

Tags: accounting 2, Bill Jelen, excel 2010, Excel 2013, excel for business, Excel for Educators, Excel for Students, Excel For Teachers, Learn Excel 2007 through Excel 2010

Power Pivot with Test playing nations

seesiva wrote 2 months ago: I have tried to attempt to create a power pivot using the data from ESPNCricket Info. Power pivot se … more →

Tags: power pivot, Excel, PowerPivot, Scores

Pivot table excercise

excelpasionate wrote 2 months ago: I’ve tried teaching once: I was asked to explain pivot tables – very useful tool. However to demonst … more →

Tags: Fun, Plot

MrExcel at the 2013 Microsoft MVP Summit in Redmond, WA

MrExcel East wrote 2 months ago: PowerPivot 2013 ‘Rental’? Why is it not in Office 15? A  50% Off Sale on brand new merch … more →

Tags: Mike Girvin and Bill Jelen, ExcelisFun, Bill Jelen, Tom Urtis and Kevin Jones, MVP13, 2013 MVP Summit, Microsoft Excel MVP, Microsoft Excel MVP Summit 2013, Customizing

Calculation of metrics at database level or reporting level..? which is the best way..?

balakrishh wrote 4 months ago: I just came across a same old situation of deciding where to do the calculation of certain metrics l … more →

Tags: Microsoft, Excel, additive, sem-additive, Measures, Non, Calculations, on the fly, Database

Tahukan Anda Pivot Table Excel ?

amugadalink wrote 5 months ago: Apakah anda sudah mengetahui adanya fasilitas Pivot Table pada Excel ? … more →

Tags: spreadsheet excel, Excel

Create Pivot Table Using VBA

ashish koul wrote 7 months ago: If you want to create a pivot table using VBA. Snapshot below - Download Sample File https://www.box … more →

Tags: Create Pivot Table Using, Pivot Table Using VBA

Create new tables with subsets of your data using the Pivot table in LibreOffice

pvanb wrote 7 months ago: Just accidentally discovered this nifty feature in Calc of Libreoffice allowing to quickly create su … more →

Tags: LibreOffice, OpenOffice, OpenOffice, cross-table, Filter, calc

Learn Excel 2010 - "Many Charts but One Pivot Table": Podcast #1596

MrExcel East wrote 8 months ago: Today, Tim wants to know if he can produce several Charts based on one Pivot Table, so that on … more →

Tags: Bill Jelen, Charts And Graphs 2010, Excel, excel 2010, Excel for Students, Excel For Teachers, free 2, Learn Excel 2007 through Excel 2010, Learn Excel 2010

MS Office: Transpose a Table - Excel 2007

A Mess of Pottage wrote 8 months ago: Have you ever had this problem? You receive data formatted as a table and you need to transpose it i … more →

Tags: MS Office, Excel, transpose, normalize

VBA Refresh Data and Pivot Table, along with Try/Catch/Finally block for Error Handling

BateTech wrote 8 months ago: I recently had a requirement to import data from a LOB application into Excel, and then refresh a pi … more →

Tags: Exception Handling, vba, Excel

Visualizing dataset of 2 million+ passwords:5 comments

Paras Doshi wrote 9 months ago: I found a data-set of password(s) on DataScienceCentral: Password and hijacked email dataset for you … more →

Tags: Data Visualization, Data Analysis, SQL, Microsoft SQL Server, Data Set, Excel, Google, Security, Data science

Social Media Analytics. Facebook Page Smackdown: Status updates vs Images?5 comments

Paras Doshi wrote 9 months ago: In this post, we’ll answer the question: For a Facebook page – which post-type* is bette … more →

Tags: paras doshi blog, Data Visualization, Microsoft Excel, facebook, Data, Social Media, social network, insights


Related Tags
All →

Follow this tag via RSS