YoVDO

Excel Basics - Number Formatting as Façade & the ROUND Function

Offered By: ExcelIsFun via YouTube

Tags

Microsoft Excel Courses Payroll Accounting Courses Income Taxes Courses Invoicing Courses

Course Description

Overview

Explore essential Excel skills in this 29-minute tutorial focusing on number formatting and the ROUND function. Learn how number formatting acts as a façade without affecting underlying formulas, saving time in data entry. Compare general, currency, and accounting formats, and master percentage formatting. Dive into rounding techniques, including when it's necessary and how to apply the ROUND function for payroll, invoicing, and income tax calculations. Gain practical insights from Highline College's Business 216 class, taught by Michael Girvin, with downloadable resources for hands-on practice.

Syllabus

) Introduction.
) What does Number Formatting do?.
) Formulas do NOT see Number Formatting.
) Number Formatting can save a lot of time for Data Entry.
) Compare General, Currency and Accounting Number Formatting.
) Percentage Number Formatting.
) Rounding.
) ROUND Function Basics.
) When you MUST Round.
) ROUND Function for Payroll.
) ROUND Function for Invoicing.
) ROUND Function for Income Taxxes when you need to round to the dollar.
) Summary - Conclusion.


Taught by

ExcelIsFun

Related Courses

Introduction to Bookkeeping
ACCA via edX
Financial Accounting: A Comprehensive Guide with E-book
Udemy
QuickBooks Payroll Essential Training
LinkedIn Learning
Bookkeeping in QuickBooks Online (Bookkeeping & accounting)
Udemy
Complete Accounting + Tallyprime + Tally ERP9 + GST (4 in 1)
Udemy