Ken Russell

7,103 Flips | 3 Magazines | 92 Likes | 32 Following | 730 Followers | @kenbo01 | Keep up with Ken Russell on Flipboard, a place to see the stories, photos, and updates that matter to you. Flipboard creates a personalized magazine full of everything, from world news to life’s great moments. Download Flipboard for free and search for “Ken Russell”

Export PowerQuery query to CSV

Recently I found a PowerQuery gem, trick with Java/VB Script that allows to <b>export data from Power Query to CSV</b> without R / DAX Studio / SMS and …

A Few More Power BI Roadmap Details From The Dynamics 365 Release Notes

Back in March, with the publication of the Dynamics 365 Release Notes document (which you can download here, halfway down the page), we learned a lot …

Using Email Attachments As A Data Source In Power BI

Many of my customers get the source data for their Power BI reports – usually Excel or csv files – sent to them as an email attachment on a regular …

How to Do Multi level sorting in Excel (by two Columns)

Excel – Applying Conditional Formatting to Charts

Hopefully you are familiar with applying conditional formatting to cells, and creating rules to apply more complex formatting rules. If not, check …

Data Visualization

Strange borders in Excel 2016

There is a recent bug in Excel 2016 that can cause strange black borders to appear in cells or rows when you enter text. More details and a fix can …

RiP Chip Pearson

I’ve just learned that Chip Pearson sadly passed away on 19th April.<p>A true legend, and a really good guy in my interactions with him, he will be …

Organizational Custom Visuals

Turn Off Visual Headers

Measure Filtering

Default Summarization

Persistent Filters

Getting Started with Power BI Desktop

Q&A Explorer

Sync Slicers

Custom Date Tables

Buttons

Power BI for HoloLens

Power BI Desktop Update - May 2018

Implementing Power BI Data Modeling with Avi Singh

VBA Assumes the Active Workbook and Active Worksheet in Excel

<b>Bottom line:</b> Learn 2 critical assumptions that VBA makes when running our macros in Excel, and avoid errors & disaster.<p><b>Skill level:</b> Beginner<p>Watch on …

Expand and Collapse Entire Pivot Table Fields - VBA Macro

Expand and Collapse Entire Pivot Table Fields – VBA Macro<p><b>Bottom line:</b> Learn how to add buttons to your pivot tables and pivot charts to quickly …

How to Change Date Formatting for Grouped Pivot Table Fields

<b>Bottom line:</b> Learn how to change the date formatting for a grouped field in a pivot table.<p><b>Skill level:</b> Intermediate<p>Changing the Days Field Number …

How to Turn Off GETPIVOTDATA Formulas for Pivot Tables

<b>Bottom line:</b> Learn how to turn the GETPIVOTDATA formulas on/off when you create a formula that references a cell inside a pivot table.<p><b>Skill level:</b> …

Why Excel Table Number Formatting Doesn't Copy Down and How to Fix It

Why Table Number Formatting Doesn’t Copy Down and How to Fix It<p><b>Bottom line:</b> Learn why the number formatting for new rows of a table doesn’t always …

3 Tips for Writing Formulas with VBA Macros in Excel

<b>Bottom line:</b> Learn 3 tips for writing and creating formulas in your VBA macros with this article and video.<p><b>Skill level:</b> Intermediate<p>Watch on YouTube …

5 Uses for VBA Macros in Excel with Your Job

<b>Bottom line:</b> Learn 5 ways to use VBA macros to automate Excel tasks you do frequently at work.<p><b>Skill level:</b> Beginner<p><p>Watch on YouTube and give it a …

Excel Shortcuts to Move the Selected Range with the Arrow Keys

<b>Bottom line:</b> Learn how to create custom shortcuts to move the selection to an adjacent range. This technique is great for selecting rows or columns …

“how do I incorporate visual design into our monthly deck?”

After reading <i>storytelling with data</i> or participating in a workshop, people often ask how they can incorporate the lessons into a recurring (i.e. …

Excel & Business Math 45: Future Value, Present Value and Periodic Payments for Annuities