On Demand Webinar

Excel 101: Spreadsheet Basics

Webinar Details $219

  • Rated:
  • Webinar Length: 100 Minutes
  • Guest Speaker:   David Ringstrom
  • Topic:   Business Administration, Business Skills, Software, Taxation and Accounting
  • Credit:   CPE 2.0
All Access Membership
If Excel spreadsheets are new to you, or if you haven’t used a spreadsheet in years, this webcast is just what you need. Excel expert David Ringstrom begins with the basics and takes you through the process of building functional spreadsheets and then working with them efficiently and effectively.

David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in the subscription-based Office 365 version of Excel. David draws your attention to any differences in the older versions of Excel (2019, 2016, 2013, and earlier) during the presentation as well as in his detailed handouts. David also provides an Excel workbook that includes most of the examples he uses during the webcast.
 
Office 365 is a subscription-based product that provides new-feature updates as often as monthly. Conversely, the perpetual licensed versions of Excel have feature sets that don’t change. Perpetual licensed versions have year numbers, such as Excel 2019, Excel 2016, and so on.


Topics typically covered:

  • Bring Excel’s green error-checking prompts under control by managing the underlying rules.
  • Get a jump start on spreadsheet projects by using free, prebuilt templates in Excel.
  • Get an overview of the different types of files you can create in Excel.
  • Get oriented with Excel’s grid of rows and columns.
  • Jump-start data visualization with the Quick Analysis feature.
  • Learn the nuances of copying formulas within Excel spreadsheets.
  • Manage column widths within your spreadsheets.
  • Master Excel’s order of operations for mathematical formulas.
  • Navigate large workbooks with ease by way of a hidden menu as well as keyboard shortcuts.
  • Never type $ signs manually in a formula again; use a keyboard shortcut instead.
  • Simplify repetitive tasks by creating your own keyboard shortcuts.
  • Understand how to enter dates in an Excel spreadsheet.
  • Wrangle long lists of data by filtering instead of sorting.

Learning objectives:

  • Skip confusing menus by way of time-saving mouse tricks and keyboard shortcuts.
  • Learn structural basics about Excel worksheets and workbooks.
  • Master some basic data-analysis techniques.

Level: Intermediate
Format: Live webcast
Instructional Method: Group: Internet-based
NASBA Field of Study: Computer Software & Applications
Program Prerequisites: None
Advance Preparation: None

  1. Introduction
  2. Please Ask Questions Today 00:02:19
  3. Excel Versions 00:04:01
  4. Getting Oriented in Excel 00:04:39
  5. Saving Excel Files 00:10:41
  6. Working Within a Cell 00:16:18
  7. Entering Text Into Worksheet Cells 00:21:03
  8. Managing Column Widths 00:25:28
  9. Formatting Percentages 00:31:20
  10. Formatting Numbers 00:35:22, 00:37:33
  11. Formatting Worksheet Cells 00:40:17
  12. Copying Formulas 00:443:37
  13. Entering Dates 00:48:36
  14. Calculating Our Loan Payment 00:54:14
  15. Excel’s Order of Operations 01:02:08
  16. Use F4 to Toggle Absolute References 01:06:51
  17. Copying Formulas 01:11:50
  18. Verifying Our Work 01:16:53
  19. AutoSum Feature 01:19:10
  20. Freeze Panes Feature 01:22:51
  21. Monitoring Print Scale 01:25:25
  22. Applying Borders and Color 01:28:52
  23. Instant Amortization Schedule 01:32:09
  24. Using Excel Templates 01:34:07
  25. Worksheet Tab Navigation Tricks 01:35:46
  26. Manage Error Checking Prompts 01:38:10
  27. Search (Tell Me) Feature (Excel 2016+) 01:40:50
  28. Thanks For Attending! 01:42:27
  29. Presentation Closing 01:43:31
  • Absolute References 01:08:31
  • Accounting Format 00:38:53
  • AutoSum 01:21:03
  • Cell 00:07:02, 00:22:03
  • Column 00:06:08, 00:25:30
  • Currency Format 00:39:06
  • Fill Handle 00:53:07
  • Format 00:40:29
  • Format Command 00:25:50
  • Formula 00:07:17
  • Formula 00:44:11
  • Formula Bar 00:18:42, 00:44:56
  • Freeze Panes 01:22:56
  • Keyboard Shortcut 00:40:48
  • Macro 00:13:33
  • Order of Operations 01:02:09
  • Print Scale 01:25:25
  • Row 00:05:53
  • SUM 01:21:18
  • Templates 01:32:57, 01:34:07
  • Workbook 00:05:47
  • Worksheet 00:06:13

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.

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.

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.

Format Command: When we format cells in Excel, we change the appearance of a number without changing the number itself.

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.

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.

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.

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.

SUM: Microsoft Excel defines SUM as a formula that “Adds all the numbers in a range of cells”. This definition clearly points that Sum function has a job to add numbers and the arguments can be supplied using combinations of both numbers and range of cells. =SUM The SUM function is a built-in function in Excel that is categorized as a Math/Trig Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the SUM function can be entered as part of a formula in a cell of a worksheet

Templates: Documents designed to serve as a starting point so that information does not have to be recreated. Templates also make it much harder for users to inadverently save over a master copy when replicating a document or spreadsheet.

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.


Guest Speaker

  • David H. Ringstrom, CPA

CPE Credit

Continuing Professional Education

Aurora Training Advantage is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org.

For more information regarding administrative policies such as complaint and refund, and cancellation please contact our offices at 407-542-4317 or training@auroratrainingadvantage.com.

You must answer all questions during the webinar, view the recording completely and pass the test at the end with 70% correct answers to receive CPE credit.