YoVDO

Excel and Business Math - Introduction to Excel, Why We Use Excel for Math, First Formula

Offered By: ExcelIsFun via YouTube

Tags

Microsoft Excel Courses File Management Courses Business Math Courses

Course Description

Overview

Learn the fundamentals of Excel for business math in this 39-minute introductory video. Discover why Excel is essential for mathematical calculations in business, explore the Excel interface, and create your first formulas. Download accompanying files, set up your workspace, and master basic Excel functions like navigating sheets, zooming, and using the Quick Access Toolbar. Practice creating formulas for total sales and net income, understand number formatting, and learn how to copy formulas efficiently. Gain valuable insights into Excel's capabilities and prepare for more advanced topics in business mathematics.

Syllabus

) Introduction.
) Class Web Site, Class Files & USB Drive to store files from class.
) Download Excel & pdf Files. Look at different Browsers: Chrome, Internet Explorer, Mozilla.
) Create Folder & Save Files using Save As & Windows Explorer.
) Why we use Excel for Business Math.
) Conventions for Class.
) What does Excel do?.
) Excel Workbook Layout.
) Move Between Sheets.
) Zoom in and out = Ctrl + Roll Wheel on Mouse.
) Ribbon Tabs.
) QAT – Quick Access Toolbar.
) First Excel Formula: Total Sales.
) Selecting a Range with the Selection Cursor.
) Number Formatting as a Façade to display numbers in a different way that the Actual Number in the cell.
) Second Excel Formula: Net Income. Also see how to copy a formula to the side (not down a column).
) Verify that Number Formatting is NOT misleading.
) Review PDF Notes ().
) Summary.


Taught by

ExcelIsFun

Related Courses

Become an Accounts Payable Officer
LinkedIn Learning
Become an Accounts Payable Officer
LinkedIn Learning
Excel & Business Math - Simple Interest Calculations & Short Term Loans
ExcelIsFun via YouTube
Excel & Business Math - Date Math, Invoices, Cash Discounts on Invoices, Nested IF Functions
ExcelIsFun via YouTube
Comprehensive Excel Payroll Example - SUMIFS, MROUND, MOD, VLOOKUP & More
ExcelIsFun via YouTube