Excel 101: Spreadsheet Basics
Webinar Details $219
- Webinar Length: 100 Minutes
- Guest Speaker: David Ringstrom
- Topic: Business Administration, Business Skills, Software, Taxation and Accounting
- Credit: CPE 2.0, ATATX 1.5, ATAOP 1.5
- Bringing Excel’s green error-checking prompts under control by managing the underlying rules.
- Copying formulas efficiently down one or more columns at the same time.
- Discerning the nuance of entering text into worksheet cells.
- Getting oriented with Excel’s grid of rows and columns.
- Handling situations where numbers are presented as # signs on-screen and in Print Preview.
- Jump-starting spreadsheet projects using free, prebuilt templates in Excel.
- Learning about the different types of files you can create in Excel.
- Learning the nuances of copying formulas within Excel spreadsheets.
- Managing column widths within your spreadsheets.
- Mastering Excel’s order of operations for mathematical formulas.
- Navigating large workbooks with ease by way of a hidden menu as well as keyboard shortcuts.
- Preventing errors from the start by choosing from thousands of free Excel spreadsheet templates.
Format: Live webcast
Instructional Method: Group: Internet-based
NASBA Field of Study: Computer Software & Applications
Program Prerequisites: None
Advance Preparation: None
- Please Ask Questions Today 00:02:13
- Excel Versions 00:04:53
- Getting Oriented in Excel 00:05:20
- Saving Excel Files 00:11:23
- Working Within a Cell 00:17:04
- Entering Text Into Worksheet Cells 00:23:13
- Managing Column Widths 00:28:15
- Formatting Percentages 00:31:55
- Formatting Numbers 00:38:23
- Formatting Worksheet Cells 00:41:14
- Copying Formulas 00:45:34
- Entering Dates 00:49:07
- Calculating Our Loan Payment 00:55:50
- Excel’s Order of Operations 01:07:57
- Use F4 to Toggle Absolute References 01:16:54
- Copying Formulas 01:19:17
- Verifying Our Work 01:21:02
- AutoSum Feature 01:21:26
- Freeze Panes Feature 01:25:06
- Print Headers/Footers 01:27:55
- Monitoring Print Scale 01:30:14
- Applying Borders and Color 01:32:43
- Instant Amortization Schedule 01:34:04
- Using Excel Templates 01:35:21
- Worksheet Tab Navigation Tricks 01:36:51
- Manage Error Checking Prompts 01:38:54
- Search (Tell Me) Feature (Excel 2016+) 01:41:36
- Thanks For Attending! 01:44:43
- Presentation Closing 01:45:14
- .XLSB 00:16:17
- .XLSM 00:13:29
- .XLSX 00:13:23
- Absolute References 01:16:57
- Accounting Format 00:38:47
- AutoSum 01:21:26
- Cell 00:06:48, 00:10:38, 00:17:09, 00:22:31, 00:32:30, 00:41:10, 00:56:40, 01:16:47, 01:21:37, 01:32:47
- Cell Reference 01:16:20
- Column 00:07:06, 00:24:30, 00:28:47, 00:41:20, 01:18:44
- Currency Format 00:38:48, 00:40:27
- Dialog Box 00:12:38, 00:41:12, 00:55:56, 01:34:15
- Fill Handle 00:46:32, 0:52:04
- Format 00:29:10, 00:32:00, 00:33:41, 00:49:14
- Formula 00:56:43, 01:08:08, 01:16:35, 01:39:13
- Formula Bar 00:18:54, 00:21:33, 00:23:37
- Freeze Panes 01:25:06, 01:26:25
- Keyboard Shortcut 00:41:39, 01:16:54
- Macro 00:13:32
- Microsoft 365 00:04:53
- Name Box 00:07:44
- Number Formatting 00:33:04
- Order of Operations 01:08:03
- PDF 00:14:21
- PMT Function 00:55:50
- Quick Access Toolbar 01:06:03
- Redo Command 00:43:39
- Ribbon 00:17:46, 00;39:19
- Row 00:07:07
- Undo Command 00:43:09
- Workbook 00:05:30, 00:13:27, 01:37:15
- Worksheet 00:05:36, 00:17:25, 00:56:26, 01:39:03
- Page Layout Menu 01:28:32, 01:30:27
- Print Scale 01:30:14
.XLSB: A file with the XLSB file extension is an Excel Binary Workbook file. They store information in binary format instead of XML like with most other Excel files (like XLSX). Since XLSB files are binary, they can be read from and written to much faster, making them extremely useful for very large spreadsheets.
.XLSM : The .XLSM file extension signifies a Macro-Enabled Excel Workbook. Such workbooks may contain programming code that can automate repetitive tasks in Excel. If prompted, do not enable macros in .XLSM workbooks of unknown provenance because viruses and malware are sometimes transmitted by tricking users into opening such workbooks.
.XLSX: A file with the. xlsx file extension is a Microsoft Excel Open XML Spreadsheet (XLSX) file created by Microsoft Excel. You can also open this format in other spreadsheet apps, such as Apple Numbers, Google Docs, and OpenOffice.
Absolute Reference : Absolute references in Excel are a direct link to a specific cell or range of cells that remain fixed if you copy or drag the formula. Absolute references are represented by $ symbols. A $ before a column letter freezes the column, while a $ before the row number freezes the row number. You can freeze the column letter and/or row number when needed.
Accounting Format: Like the Currency format, the Accounting format provides options for decimal places and a currency symbol, and it automatically uses a comma to separate thousands. Unlike Currency, there are no options for negative numbers. The Accounting format places parentheses around all negative numbers by default.
AutoSum: The AutoSum feature appears on both the Home menu and the Formulas menu as a Greek sigma symbol. When you click AutoSum, or press Alt-= Excel adds a sum function to the current cell or cells that you've selected.
Cell: In spreadsheet applications, a cell is a box in which you can enter a single piece of data. The data is usually text, a numeric value, or a formula. The entire spreadsheet is composed of rows and columns of cells.
Cell Reference: A cell reference refers to a cell or a range of cells on a worksheet and can be used in a formula so that Microsoft Office Excel can find the values or data that you want that formula to calculate. There are three types: Relative, Absolute, and Mixed
Column: A column is a vertical series of cells in a chart, table, or spreadsheet in Excel.
Currency Format: The Currency format places the dollar sign right next to the number.
Dialog Box: A dialog box in Excel is a screen where you input information and make choices about different aspects of the current worksheet or its content, such as data, charts, and graphic images.
Fill Handle: The little notch in the bottom right-hand corner of the selected cell or block of cells. You can drag the fill handle to copy the contents to other cells, double-click to copy contents down a column, or right-drag to reveal a hidden context menu.
Format: When we format cells in Excel, we change the appearance of a number without changing the number itself. We can apply a number format (0.8, $0.80, 80%, etc) or other formatting (alignment, font, border, etc). By default, Excel uses the General format (no specific number format) for numbers.
Formula: A formula is an expression which calculates the value of a cell.
Formula Bar: A toolbar at the top of the Microsoft Excel spreadsheet window that you can use to enter or copy an existing formula into cells or charts. It is labeled with function symbol (fx). By clicking the Formula Bar, or when you type an equal (=) symbol in a cell, the Formula Bar will activate.
Freeze Panes: This command on the View tab of Excel’s ribbon interface, or the Window menu in Excel 2003 and earlier, allows you to ensure that one or more rows and/or columns always remain on-screen as you scroll down through a worksheet.
Keyboard Shortcut: A keyboard shortcut is a series of one or several keys that invoke a software program to perform a preprogrammed action. This action may be part of the standard functionality of the operating system or application program, or it may have been written by the user in a scripting language.
Macro: One or more lines of programming code that automate tasks. The Macro Recorder allows users to automate tasks without seeing the underlying programming code.
Microsoft 365: Microsoft 365, formerly Office 365, is a line of subscription services offered by Microsoft which adds to and includes the Microsoft Office product line.
Name Box: The Name Box is the box to the left of the formula bar that displays the cell that is currently selected in the spreadsheet. If a name is defined for a cell that is selected, the Name Box displays the name of the cell. You can use the Name Box to define a name for a selected cell as well.
Number Formatting: Number formats are used to control the display of cell values that contain numeric data. This numeric data can include things like dates, times, costs, percentages, and anything else expressed as a number. To apply a number format, just select one or more cells and choose a format.
Order of Operations : The sequence with which Excel carries out arithmetic operations. Unless superseded by enclosing portions of a calculation in parentheses, Excel first divides, then multiplies, then adds, and finally subtracts.
PDF: Portable Document Format, a universal document format created by Adobe that allows cross-platform compatibility of documents.
PMT Function: The PMT function enables you to calculate a loan payment based on providing an interest rate, period of the loan, and amount to be borrowed or lent. The interest rate must be on the same footing as the term of the loan, so if the loan period is expressed in months, be sure to divide the interest rate by 12.
Print Scale : A measure in Excel that shows how much a printed page has been reduced in size. The Scale command appears on the Page Layout tab in Excel 2007 and later. The average person will find documents printed in a scale of 63% or less to be frustrating to read.
Quick Access Toolbar: A customizable shortcut toolbar that appears above the ribbon in Office 2007 and later.
Redo Command: Like the undo action, redo can be performed multiple times by using the same keyboard shortcut over and over. The Excel Ribbon also has a redo button right next to the undo button; it is represented by an icon with an arrow pointing to the right. After using the Undo button on the Quick Access toolbar, Excel 2010 activates the Redo button to its immediate right. If you delete an entry from a cell and then click the Undo button or press Ctrl+Z, the ScreenTip that appears when you position the mouse pointer over the Redo button appears as Redo Clear (Ctrl+Y).
Ribbon: The "ribbon" is the strip of buttons and icons located above the work area that was first introduced in Excel 2007. The ribbon replaces the menus and toolbars found in earlier versions of Excel. Above the ribbon are a number of tabs, such as Home, Insert, and Page Layout.
Row: A row is the range of cells that go across (horizontal) the spreadsheet/worksheet. Rows are identified by numbers e.g. row 1, row 5. Examples of use. A row might contain the headings of a table e.g. product ID, product name, price, number sold.
Workbook: In Microsoft Excel a workbook is a collection of one or more spreadsheets, also called worksheets, in a single file.
Worksheets: A worksheet is a collection of cells where you keep and manipulate the data. Each Excel workbook can contain multiple worksheets.