jmt

Home/Jackie Meddows-Taylor

About Jackie Meddows-Taylor

This author has not yet filled in any details.
So far Jackie Meddows-Taylor has created 292 blog entries.

Top tips for Power Query Data Types

by Eric Marshall Assigning Data Types Assigning data types is an essential step when working with Power Query in Excel or Transform Data in Power BI Desktop. Here are some useful tips on how to change data types while maximising the efficiency of your models: Tip #1: Don’t Change Types Until the End of a [...]

Multiple Teams logins with Edge Chromium

by Wyn Hopkins How to handle teams when you have multiple different logins Often people are required to be part of "Teams" in organisations other than their own. The desktop app is OK at allowing you to switch between different organisations if you have the same email address for all teams. The trouble starts when [...]

2020-06-30T12:46:52+08:00Teams|

Excel tips & tricks to boost productivity

by Wyn Hopkins Boost your productivity with these shortcuts With over 20 years' experience in Excel we've picked up a few tips and tricks. We'll show you the shortcuts, features and formulas that will speed up your daily use of Excel. From SWITCH to Dependent Drop downs,  Grouping to Conditional Formatting,  clever validation lists and [...]

Connect to files stored on OneDrive and SharePoint

by Wyn Hopkins How to use Power Query to connect to a file on OneDrive or SharePoint A growing number of organisations are starting to store their files on OneDrive for Business and SharePoint. Users will begin to discover that connecting to these files with Power Query is not as straight forward as clicking the button for [...]

Hard coded data sources in Power BI

By Eric Marshall Hard coded data sources in Power BI Simple, hard-coded data tables can be useful data sources in Power BI (provided your data won’t change!). Here’s how to incorporate hard-coded data into your data model: Under the Home ribbon of Power BI Desktop, click “Enter Data”.   Double click on “Column1” and rename [...]

2020-04-21T13:34:25+08:00Power BI|

Power BI & Excel Virtual Classroom

Virtual Classroom - Power BI & Excel We're 100% still open for business and set up to deliver our highly rated Power BI and Excel "in - person" training via the magic of the internet! This is great, as not only do Perth clients continue to get access to our training courses, folks around Australia [...]

The Rise and Fall of the escalation formula

By Robert Hind Does your contract Rise and Fall let you down? When you're providing products or services in a long term relationship there is usually a contract which will typically include an Escalation (Rise and Fall) formula. The intent of the Escalation Formula is that cost increases or decreases should be passed on so [...]

Power Query and a Key Word search

By Wyn Hopkins Power Query and a Key Word search (Episode 1) This demonstration came about due to a real life scenario where I needed to categorise a transaction listing (like a bank statement for example) so that I could generate a summary report of categories of spend. All sorts of tips can [...]