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