- Видео 48
- Просмотров 17 318
Andrew Moss
Великобритания
Добавлен 29 июл 2021
Excel Aficionado | Deep Thinker | Curious Sceptic
The Billion Rows Excel Challenge
It's a common myth that Excel can only house 1,048,576 rows of data. After all, that's how many worksheet rows there are, right? However, thanks to the Data Model, it's possible to do more - way more.
Back in December 2021 (ruclips.net/video/anU7FMqko_A/видео.htmlsi=oeMM7FGW9kHNFT8H), I demonstrated how long it took to load varying-sized datasets into the Data Model with and without Power Query's Fast Data Load enabled.
I decided to repeat the experiment, except go two huge steps further by adding 500 million and 1 billion to the list.
How did I get on?
Find out here:
👇
andrewcharlesmoss.medium.com/the-billion-rows-excel-challenge-e290461b65ab
---
Where to find me:
Website - andrewmoss.me
LinkedIn ...
Back in December 2021 (ruclips.net/video/anU7FMqko_A/видео.htmlsi=oeMM7FGW9kHNFT8H), I demonstrated how long it took to load varying-sized datasets into the Data Model with and without Power Query's Fast Data Load enabled.
I decided to repeat the experiment, except go two huge steps further by adding 500 million and 1 billion to the list.
How did I get on?
Find out here:
👇
andrewcharlesmoss.medium.com/the-billion-rows-excel-challenge-e290461b65ab
---
Where to find me:
Website - andrewmoss.me
LinkedIn ...
Просмотров: 82
Видео
Clear values in a range - why the keyboard shortcut inconsistency?
Просмотров 1312 месяца назад
In Excel for Mac, when you select a range of values and then press Backspace, they are all cleared. The same behaviour occurs in Excel for Web. However, in Excel for Windows, it's a different story. Pressing Backspace only clears the first value in the range. If you want to move to the next cell, press Enter or Return. Then, you can rinse and repeat the process for that and the rest if you real...
Giles Male and Harry Matthews talk Excel with Jeremy Vine
Просмотров 1173 месяца назад
Last Thursday (30/05/2024), Jeremy Vine was joined by two guests on his BBC Radio 2 afternoon show. They were Giles Male, co-founder of Full Stack Modeller, and Harry Matthews, Group Financial Controller at the Landauer Group. Both discussed their love of Microsoft Excel and the versatile uses it has in everyday life. There was even talk about VLOOKUPs, XLOOKUPs, and INDEX and MATCH. However, d...
Unpivot data in Excel using Power Query
Просмотров 115Год назад
Sometimes data is perfectly shaped and structured - other times, it's not. If you've used pivot tables, you'll be familiar with the cross-tabular format, which summarises data based on two or more categorical variables. While this layout is great for presentational purposes, it isn't conducive to in-depth analysis. However, unpivoting the data converts it into tabular format, where multiple col...
Convert numbers to percentages the right way in Excel
Просмотров 396Год назад
In Excel, it's common practice to store percentage values as numbers under the General number format; for example, 12, 6, and 16. By only including the percent symbol (%) in a column's header, you can avoid repetition and extra clutter. However, doing so can cause problems later on if you decide to change these to Percentage. This is because values outside of this are multiplied by 100, meaning...
Extend Excel's Functionality with Kutools
Просмотров 1,4 тыс.Год назад
Extend Excel's Functionality with Kutools
Pin windows on top of others using PowerToys' Always On Top utility
Просмотров 581Год назад
Pin windows on top of others using PowerToys' Always On Top utility
Alcohol WON’T be sold in World Cup stadiums after eleventh-hour decision
Просмотров 904Год назад
Alcohol WON’T be sold in World Cup stadiums after eleventh-hour decision
The NEW Keyboard Shortcut for Pasting in Excel
Просмотров 113Год назад
The NEW Keyboard Shortcut for Pasting in Excel
Where was Newcastle‘s spectacular pre-match mosaic created?
Просмотров 25Год назад
Where was Newcastle‘s spectacular pre-match mosaic created?
Oz du Soleil - BBC Radio 5 Live Interview
Просмотров 382 года назад
Oz du Soleil - BBC Radio 5 Live Interview
How to Insert Data From a Picture in Excel
Просмотров 1222 года назад
How to Insert Data From a Picture in Excel
How to Apply Outlines to Data in Excel
Просмотров 6342 года назад
How to Apply Outlines to Data in Excel
Keyboard Shortcut for Displaying an Excel Function's Arguments
Просмотров 222 года назад
Keyboard Shortcut for Displaying an Excel Function's Arguments
How Fast is Fast Data Load in Power Query?
Просмотров 5 тыс.2 года назад
How Fast is Fast Data Load in Power Query?
Annoying Excel Problems: Trailing Zeros
Просмотров 973 года назад
Annoying Excel Problems: Trailing Zeros