- Популярные видео
- Авто
- Видео-блоги
- ДТП, аварии
- Для маленьких
- Еда, напитки
- Животные
- Закон и право
- Знаменитости
- Игры
- Искусство
- Комедии
- Красота, мода
- Кулинария, рецепты
- Люди
- Мото
- Музыка
- Мультфильмы
- Наука, технологии
- Новости
- Образование
- Политика
- Праздники
- Приколы
- Природа
- Происшествия
- Путешествия
- Развлечения
- Ржач
- Семья
- Сериалы
- Спорт
- Стиль жизни
- ТВ передачи
- Танцы
- Технологии
- Товары
- Ужасы
- Фильмы
- Шоу-бизнес
- Юмор
Excel vs Power Query rounding: WARNING difference results | Excel Off The Grid
★ Want to automate Excel? Check out our training academy ★
https://exceloffthegrid.com/academy
★ Check out the blog post ★
https://exceloffthegrid.com/excel-power-query-rounding/
★ About this video ★
This video shows that rounding in Excel and rounding in Power Query lead to different results.
0:00 Introduction
0:27 Scenario
2:56 Rounding methods
4:23 Which method is best?
7:30 Excel calculating bankers rounding
8:30 Power Query calculating traditional rounding
9:40 Summary
★ Download 30 most useful Excel VBA Macros ebook for FREE ★
https://exceloffthegrid.com/
★ Where to find Excel Off The Grid ★
Blog: https://exceloffthegrid.com
Twitter: https://twitter.com/exceloffthegrid
#MsExcel #PowerQuery
Видео Excel vs Power Query rounding: WARNING difference results | Excel Off The Grid канала Excel Off The Grid
https://exceloffthegrid.com/academy
★ Check out the blog post ★
https://exceloffthegrid.com/excel-power-query-rounding/
★ About this video ★
This video shows that rounding in Excel and rounding in Power Query lead to different results.
0:00 Introduction
0:27 Scenario
2:56 Rounding methods
4:23 Which method is best?
7:30 Excel calculating bankers rounding
8:30 Power Query calculating traditional rounding
9:40 Summary
★ Download 30 most useful Excel VBA Macros ebook for FREE ★
https://exceloffthegrid.com/
★ Where to find Excel Off The Grid ★
Blog: https://exceloffthegrid.com
Twitter: https://twitter.com/exceloffthegrid
#MsExcel #PowerQuery
Видео Excel vs Power Query rounding: WARNING difference results | Excel Off The Grid канала Excel Off The Grid
Комментарии отсутствуют
Информация о видео
22 сентября 2022 г. 14:00:07
00:10:27
Другие видео канала
Declare data type when creating a Custom Column | Saving Power Query steps | Excel On The Go
3 ways to create nice looking Office Scripts Buttons | Excel Off The Grid
Why Excel Solutions On YouTube Don't Work For You!
Power Query: Connect to Files in a List | Excel Off The Grid
Dynamic Text in Excel | TEXT function + Number Formats | Excel Off The Grid
Power Query Vs VSTACK: Combine Tables in an Excel workbook | Excel Off the Grid
Built Your Own Tools with Office Scripts to Automate Excel Tasks
Create multiple folders at once with Excel (the easy way!) | Excel Off The Grid
Put Excel into easy mode by implementing First Normal Form.
HELP! Power Query Didn't Refresh... Or Did It?
How to make an Excel worksheet Very Hidden | Excel On The Go
EOMONTH Function in Excel: How to + 8 Examples | Excel Off The Grid
Change category while keeping history | Slowing changing dimensions with Excel and Power Query.
EASILY toggle between Standard & GetPivotData in Excel | Excel On The Go
Excel Waffle Charts that work everywhere (including Excel Online) | Excel Off The Grid
Tricky Unpivoting Problem... SOLVED: How to Unpivot Paired Columns in Power Query
Automate Excel with Loops in Office Scripts
Make Waffle Charts in Excel... the EASY way | Excel Off The Grid
Approximate Match in Power Query – The FASTEST Way Revealed!
Promote headers in nested tables before expanding columns | Power Query | Excel Off The Grid
