FrankensTeam's Excel Collection
107.8K views | +15 today

 Scooped by Kris onto FrankensTeam's Excel Collection

How to use Advanced Filters in Excel. Find exact text using Advanced Filters with formula criteria.
Kris's insight:

Formulas in criteria - Great!

Progressive training's curator insight,

# FrankensTeam's Excel Collection

Useful, interesting and funny Excel stuff
Curated by Kris
 Scooped by Kris

## Introduction to MDX for PowerPivot Users, Part 1

This is a series of posts I’ve wanted to write for a long time. The more I use PowerPivot, the more I realise how many more cool things you can do when building your Excel reports if you know a bit of MDX. Of course it seems a bit strange to say this, because (at…
No comment yet.
 Scooped by Kris

## Use Slicer to select value fields for Pivot table or PowerPivot! - E90E50fx

Use Slicer to select value field, measure for Pivot table or PowerPivot
Kris's insight:
Do you like this trick?
No comment yet.
 Scooped by Kris

## PowerPivot: Constant in calculated field results blank rows - E90E50fx

PowerPivot blank rows in pivot table problem constant in DAX calculation formula
No comment yet.
 Scooped by Kris

## Excel Pivot Cache • My Online Training Hub

The Excel Pivot Cache enables your PivotTable reports to be very responsive, but it comes at a cost. Learn how to manage the Pivot Cache here.
Kris's insight:

Great summary! Must-read for all pivot table users!

No comment yet.
 Scooped by Kris

## La Luna - Moon phases animated chart in Excel - E90E50fx

Moon phases animated Excel chart, area chart, la Luna
No comment yet.
 Scooped by Kris

## Sort the Power Pivot measures (and fields) in the PivotTable Fields

When designing your pivot tables based on a Power Pivot model you typically add fields and measures continuously, and in the measure list they will by default list then be sorted by the order you h...
No comment yet.
 Scooped by Kris

## Column Chart with Category Axis Labels Between Columns - Peltier Tech Blog

This quick tutorial shows how to use a hidden XY series to provide custom labels where desired along a chart's axis.
No comment yet.
 Scooped by Kris

## Reciprocal Chart Axis Scale - Peltier Tech Blog

This tutorial uses an Arrhenius plot to demonstrate construction of an axis with arbitrary scale and gridlines, ordinarily not available in Excel.
No comment yet.
 Scooped by Kris

## Meeting in Milano, trip to the Alps and an Excel chart - E90E50fx

FrankensTeam meeting in Milano, Alps Excel chart
No comment yet.
 Scooped by Kris

## Selecting and Highlighting Areas on Excel Charts

Interactive Selecting and Highlighting Areas on an Map or an XY Scatter Chart in Microsoft Excel
Kris's insight:

Really it's magic! :-)

No comment yet.
 Scooped by Kris

## Area chart with levels - Excel-Croissant - E90E50fx

Excel area chart to visualize small and large values
Kris's insight:

Area-levels chart in #Excel

No comment yet.
 Scooped by Kris

## Secondary Axis as Percentage of Target - Peltier Tech Blog

Usually, secondary axes are confusing and cognitively butrdensome. But this tutorial shows how a secondary axis with percentages can be a good thing.
No comment yet.
 Scooped by Kris

## DATEDIF Worksheet Function

Kris's insight:

Very useful, but very hidden Excel function!

No comment yet.
 Scooped by Kris

## Visualize underlying parts and total value - alternative column chart - E90E50fx

Total value and underlying data on one column chart. Excel column chart with different width columns.
No comment yet.
 Scooped by Kris

## Clean up Pivot Cache - Desktop Liberation

Liberate the desktop
No comment yet.
 Scooped by Kris

## How to save as binary Excel workbook

Excel files with lots of formulas, data and objects (e.g. shapes) can expand considerably in size. Large files take longer to open/save or email and occupy valuable mailbox or disk space. The tip...
No comment yet.
 Scooped by Kris

## Combine Excel Worksheets with Power Query • My Online Training Hub

How to combine Excel Worksheets with Power Query. This example looks at combining budget and actual data on two separate sheets into one Table.
Kris's insight:

Works not only for worksheets, but with tables too.

No comment yet.
 Scooped by Kris

## Break PivotTable Report Filters into Multiple Columns | Bacon Bits

No comment yet.
 Scooped by Kris

## Zooming in and out of Excel Charts

Interactive zooming in and out on Charts in Microsoft Excel
No comment yet.
 Scooped by Kris

## Export Excel Dashboards (Improved Version)

An improved version of the example workbook exporting Excel Dashboards to other applications
Kris's insight:

Very useful tool!

No comment yet.
 Scooped by Kris

## Excel Named Range Shortcut • My Online Training Hub

This Excel Named Range shortcut using the exclamation mark will enable you to create a global name with local scope.
No comment yet.
 Scooped by Kris

## Apply Custom Data Labels to Charted Points - Peltier Tech Blog

This tutorial describes a number of ways (manual, built-in, and programmatic) to add custom data labels to an Excel chart.
Kris's insight:

Great summary about the labeling possibilities.

No comment yet.
 Scooped by Kris

## Another Technique for Interactive Excel Charts

Another technique to create interactive charts in Microsoft Excel using an ActiveX Label Control on top of the chart
Kris's insight:

VERY impressive !!!!

No comment yet.
 Scooped by Kris

## Free Org Chart Add In - Beyond Excel

Kris's insight:

With professional documentation!

No comment yet.
 Scooped by Kris

## Chart Events in Microsoft Excel - Peltier Tech Blog

When using a computer, you continuously interact with objects and programs through events. Here is how to use Chart Events to enhance your workbooks.
Trainedge Consulting's curator insight,

Chart events can make it much easier for people to use your programs, and add interactivity to your charts.