• About

Dr James Bayley

~ Creating successful projects

Dr James Bayley

Category Archives: Excel

Power Query “each”

17/12/2021

I am learning Power Query and the “each” function comes up a lot. Here is an explanation of its function …

Continue reading →

Power Query Refer to previous row

17/12/2021

There is an excellent tutorial from Goodly here. TLDR; use the list index selector {}

Power Query SumIF

17/12/2021

Yesterday I wrote about how to calculate a running total (cumulative total) using Power Query. This used List.FirstN and the …

Continue reading →

Creating running totals in Power Query

16/12/2021

Power Query brings the power of ETL (extract, transform and load) tools to Excel. Almost every job I have now …

Continue reading →

How to add a row number to an Excel table 2020 using Power Query Editor

18/04/2020

Back in 2013 I wrote post on how to add a row number to an Excel table. This post is …

Continue reading →

Power Query: How to load only fresh rows and create an Excel history table

23/04/2018

I have previously written about the powerful ETL (Extract, Transform and Load) functions that are now in Excel Office 365 …

Continue reading →

Next steps in Excel ETL – learning M

18/03/2018

Excel 365 Get and Transform Data (was Power Query, actually ETL) allows you to use the M language to create …

Continue reading →

Excel ETL – import multiple CSV files

18/03/2018

I have previous blogged on how to unpivot data using Excel  and Excel 365 (was Excel 2016) just keeps getting …

Continue reading →

Using Excel 2016 to unpivot data

03/04/2017

Normal people, by which I mean those who don’t process data all day will often create data that is present …

Continue reading →

Create the Union of two tables in Excel revisited

03/04/2017

In 2013 I published a technique to create the union of two tables in Excel. This post is still very …

Continue reading →

← Older posts

Enter your email address to receive email notification of new posts

Recent Posts

  • How to add a “sleep” button to a Microsoft Sculpt Ergonomic Keyboard
  • Getting a job – the interview
  • Crypto is not about FTX
  • Solved: Cannot login to Office 365 on mobile with the error “Your account or password is incorrect. If you can’t remember your password, reset it now”
  • Support My Local now sells digital raffle tickets for schools and charities

Archives

  • Application design
    • Frameworks
    • HTML5
    • Requirements Management
    • User Experience
  • applications
  • Artificial Intelligence (AI) and Machine Learning (ML)
  • backup
  • Books I like
  • brexit
  • Business models
    • Lean startup
  • Cloud
    • Amazon Web Services (AWS)
    • Bitnami
  • Crypto-currencies
  • cryptocurrencies
  • Cryptostar.money
  • Economics
  • Education
  • ElephantPM
    • PRINCE2
    • Project Management
  • energy
  • Enterprise Architecture
  • Excel
  • FogBugz and Kiln (Mercurial)
  • formidable forms
  • Francesca
  • Game
  • GTD
  • Hardware
  • Humour
  • Infrastructure
  • iot
  • Job Applications
  • Keyapt
  • Lean Management
  • Management Consulting
  • Marketing
  • Medical
  • Microsoft Teams
  • Mobile Development
    • Android
    • iPhone
    • Windows Phone 7
  • Net Promoter Score
  • office 365
  • Outlook
  • Personal
  • Personal productivity
  • Petition
  • Politics
  • Science
  • security
  • Sharepoint
  • Software
  • Technologies to build applications
    • JavaScript
    • Microsoft SQL Server
    • Railo and ColdFusion
    • Tomcat
    • Wordpress
  • Uncategorized
  • Ventilators
  • virtualisation
  • web design
  • Windows
  • Windows Desktop
    • Excel
    • Windows 10
    • Windows 8.1

RSS

RSS Feed RSS - Posts

RSS Feed RSS - Comments

My Other Sites

CryptoStar - #1 Crypto Directory with User Reviews
Suport My School - #1 For School Fundraising

(C) 2010 – 2014

Blog at WordPress.com.

Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy
  • Follow Following
    • Dr James Bayley
    • Join 110 other followers
    • Already have a WordPress.com account? Log in now.
    • Dr James Bayley
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar
 

Loading Comments...