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.
Excel and Business Math - Introduction to Excel, Why We Use Excel for Math, First Formula
ExcelIsFun via YouTube
Overview
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
