Excel Basics - Commercial ROUNDING - Learn Excel from the start!
The ROUND function performs commercial rounding to a specified position before or after the decimal point. Many other rounding methods exist, which will not be discussed in this introductory video.
The file is available again on my blog: https://thehosblog.com/2020/11/28/exc...
Topics covered in this video:
00:00 Overview of rounding options
01:28 The theory behind ROUND
02:34 Numerical errors due to floating-point errors
05:20 The ROUND function - after the decimal point
07:57 Rounding to zero decimal places
08:42 Rounding to the nearest ten before the decimal point
This is part 10 of this basics series. Overview of all parts:
01 - Overview and File Formats - November 14, 2020 • Excel-Grundkurs - Übersicht und Dateiforma...
02 - Worksheets - November 15, 2020 • Excel-Grundkurs - Tabellenblätter - Excel ...
03 - Data Entry and Corrections - November 17, 2020 • Excel-Grundkurs - Eingabe und Korrektur vo...
04 - AutoFill - November 18, 2020 • Excel-Grundkurs - Zeit sparen mit AutoAusf...
05 - Calculating with Cell References - November 19, 2020 • Excel-Grundkurs - Relative und absolute Ze...
06 - Custom Formulas and Basic Functions - November 20, 2020 • Excel-Grundkurs - Einfache Berechnungen - ...
07 - Basic Functions - November 23, 2020 • Excel-Grundkurs - Summe & Co. - Einstieg ...
08 - Overview of the Interface - November 24, 2029 • Excel Grundkurs - Oberfläche - Überblick u...
09 - Number Formats - November 26, 2020 • Excel-Grundkurs - Zahlenformate Buchhaltun...
10 - ROUND Function - November 28, 2020 • Excel-Grundkurs - Kaufmännisches RUNDEN - ...
11 - Tables - November 30, 2020 • Excel-Grundkurs - Tabellen - Excel lernen ...
12 - Printing and Page Layout - December 14, 2020 • Excel-Grundkurs - Drucken und Seitenlayout...
13 - Coming soon
#Excel #ExcelBasicCourse #athehos #Microsoft365
----------------------------------------------------------------------------
Here you'll find There are longer articles, files to download, my business information, and more information on how you can support the channel:
Blog - https://thehosblog.com
----------------------------------------------------------------------------
Want to connect? You can find me on the following services:
XING - https://www.xing.com/profile/Andreas_...
LinkedIn - / thehos
----------------------------------------------------------------------------
You can also find more information on the following social media networks:
Instagram - / at_excel
Twitter - / athehos