Microsoft Excel Spreadsheet Basics

Member price:


Your price:

$ 99.00

Location details:

Course Description

This course is designed for those who’ve never worked with Excel spreadsheets or for those who haven’t for several years. Excel expert David Ringstrom takes you step-by-step through the basics of Excel spreadsheets, providing the knowledge needed to create functional spreadsheets and manipulate large lists of data. He presents an overview of the different types of files you can create, explains Excel’s rows and columns grid, demonstrates how to remove duplicates from a list, shares keyboard shortcuts to simplify repetitive tasks, and more.

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 Covered:

  • Managing column widths within your spreadsheets.
  • Understanding how to enter dates in an Excel spreadsheet.
  • Surfacing hidden Excel commands instantly by way of the Tell Me feature in Excel 2016 and later.
  • Copying formulas efficiently down one or more columns at the same time.
  • Understanding the difference between working within a cell versus working on a worksheet.
  • Getting familiar with Excel’s grid of rows and columns.
  • Learning the nuances of copying formulas within Excel spreadsheets.
  • Discerning the nuance of entering text into worksheet cells.
  • Using a keyboard shortcut so you’ll never have to manually type $ signs in a formula again.
  • Mastering Excel’s order of operations for mathematical formulas.
  • Utilizing the PMT worksheet function to calculate loan payment amounts.

Learning Objectives:

  • Identify how to skip confusing menus by way of time-saving mouse tricks and keyboard shortcuts.
  • Define the structural basics of Excel worksheets and workbooks.
  • Apply some basic data-analysis techniques.

Course cancellation policies

Our site uses cookies to improve your visiting experience. Please view our Cookie and Privacy Policy.
Got it